Depending on how specific you need to make your sorting, you can also modify the custom drilldown spec with ORDER functions. If needed, you could change the measure and the direction for each level. For example:
ORDER([Product].[P1].[Product Category].Members,Measures.[%COUNT],BDESC)
ORDER([Outlet].[H1].[Region].Members,Measures.[%COUNT],BDESC)
ORDER([Channel].[H1].[Channel Name].Members,Measures.[%COUNT],BDESC)
FYI: this bug has been reported to development
Congratulations, very exciting!
Thanks, this works. I did have to click the "+" icon and add a new namespace to the Explorer, since adding the namespace from InterSystems Server Manager did not pull it into the ObjectScript Explorer. This is kind of an unusual case since I don't necessarily have a project/workspace for the generated class I want to view. If I already had one, then I wouldn't need to use the namespace explorer.
Thanks, this is exactly what I was looking for
Hi Virat,
Here is a good resource for getting started with InterSystems IRIS BI (DeepSee):
https://learning.intersystems.com/course/view.php?id=1793
If you are interested in creating dashboards and exploring your data, IRIS BI is a good choice.
If you are interested in traditional reporting, you may want to consider InterSystems Reports:
https://learning.intersystems.com/course/view.php?id=1444
Hi Phillip,
Specifically, Studio connects using the superserver port: https://docs.intersystems.com/iris20221/csp/docbook/Doc.View.cls?KEY=PA…
As Tom mentioned, you will need to determine which port this has been configured as
Hi Ahmad,
These functions do not exist in MDX, please see the MDX function documentation here: https://docs.intersystems.com/iris20221/csp/docbook/Doc.View.cls?KEY=D2…
You likely want to use the %OR function: https://docs.intersystems.com/iris20221/csp/docbook/DocBook.UI.Page.cls…
Using %OR would allow you to reference multiple members, for example:
Expression="%OR({[Demographics].[H10].[Citizenship].&[USA],[Demographics].[H10].[Citizenship].&[U.S.A],[Demographics].[H10].[Citizenship].&[US]})"
Here is a quick video about databases and namespaces that may help you get started with your plan for what is needed:
I tried this and it worked:
Parameter TestParam = "Test";
Property TestCalc As %String [ SqlComputeCode = { Set {*} = ..#TestParam}, SqlComputed ];
[SQL]SAMPLES>>select * from DC.SQLCompute
1. select * from DC.SQLCompute
ID TestCalc
1 Test
What are you trying to modify inside of %DeepSee.Dashboard.Utils?
Hi Virat,
In %OnGetFilterMembers, you will have access to pFilter, which will contain the name of your filter, "SubjectName" in this example. You will also have access to pMembers, which is an array of members that the SearchBox dropdown will use in the UI. By default, this will contain the results from sql="SELECT DISTINCT SubjectName FROM BI.Invoice". You will also have access to pFilterValues, which contains an array of already selected values. In your case, "Virat and Big Show". You would then need to use this information to remove values from the pMembers array to reduce the available members.
By default, IRIS BI does this "member filtering" for you. The use of KPIs is very customized, so it requires some additional custom logic to allow this behavior
It turns out this was a bug with parallel processing where the negative numbers in the data were more negative than the null marker caused data to be skipped. Development is fixing this