New post
User bio
404 bio not found
Member since Jan 17
Posts:
show all 1
Replies:
show all 2
Mike Rowland · Jan 17

Hi Evgeny,

I'm not familiar with DSW, only started building dashboards via DeepSee User Portal within the last 6 months or so. I see it says the application is not supported by intersystems. What can DSW do for me and how difficult is it to setup? Would this affect maintenance agreements?

Mike Rowland · Jan 17

ah, yes, good point, sorry, first post.

Here is the query:

SELECT NON EMPTY NONEMPTYCROSSJOIN([IMResultDateTimeD].[H1].[IMResultDateHour].Members,%LABEL([MEASURES].[CAPACITIESTEST],"","#%")) ON 0,NON EMPTY [TestInstrumentIDD].[H1].[TestInstrumentID].Members ON 1 FROM [IMTESTCUBE] %FILTER [IMResultDateTimeD].[H1].[IMResultDateDayMonthYear].&[NOW] %FILTER ([ConnectionLocationD].[H1].[ConnectionLocation].&[(NULL)].%NOT,[ConnectionLocationD].[H1].[ConnectionLocation].&[System].%NOT)

And here is how I have capacityTest defined:

[TestStatusD].[H1].[TestStatus].&[Released]/%LOOKUP("Capacity",[TestInstrumentIDD].[H1].[TestInstrumentID].CURRENTMEMBER.Properties("Name"))

Followers:
Mike has no followers yet.
Following:
Mike has not followed anybody yet.
Global Masters badges:
Mike has no Global Masters badges yet.