InterSystems IRIS BI (DeepSee) is a Business Intelligence (BI) technology that enables the real-time analysis of transactional data, and is designed to be optimal for embedding within transactional applications.
I'm trying to calculate the percentage of the top level with the SUM function. But I don't understand the PARENT behavior. It does not work in any way!
I am trying to calculate a dimension percentage for WFRole on a child cube named MbMRouteHistoryInitiatorObj joined to a parent cube named MbmQaSObj by using a calculated member dimension within MbmQaSObj.
If I use the calculated member dimension value expression of [WFRole].[H1].[WFRole].CurrentMember/ [WFRole].[All WFRole].%ALL in the child cube MbMRouteHistoryInitiatorObj, the percentages work correctly.
Using cube CubeA and cube CubeB that contains calculated measure TotalClients. I would like to use TotalClient calculated measure from a compound cube CubeC (CubeA,CubeB).
I need to pass multiple values to a FILTER to a DeepSee DASHBOARD via the URL. The documentation seems to indicate this can be done, i.e.: "Where each filterspec is filter_name.filter_values" but there are no examples I can find that indicates what is used to separate multiple values. Say I want to pass the three values 5, 6, and 1395 to a filter. To pass just the 5 I know this works:
&SETTINGS=FILTER:LEAD.MYUSERID.H1.MYUSERID.5
but how do I include 6 and 1395. None of the following seem to work:
In DeepSee, having a customer account cube. The cube includes a time dimension AccountCreationDate.
How do you create a calculated measure to get the total number of accounts from the beginning to a certain date in abscissa ?
I tried many things including this:
AGGREGATE(%TIMERANGE([AccountCreationDate].[H1].[MonthYear].&[190001],[AccountCreationDate].[H1].[MonthYear].CURRENTMEMBER) ,[Measures].[%Count])
But I don't get the right result because the date in abscissa creates a filter on the first date.
What would be the easiest or best way to filter the options presented by a filter control?
For example, suppose that I create a query using HoleFoods that uses a named filter to filter the product categories according to some criteria. When I display the query on the dashboard, I would like to provide a filter control that will allow users to further constrain the product categories. However, a simple filter control will display all the product categories available in the cube many of which are irrelevant to the current query.
is there any API available that would return an MDX query string for a given saved pivot name? I could not find anything except for pivots with manual MDX. But that's not my case, I need to get MDX for any pivot.
This year while at the Global Summit, I came to learn of a component that Stephen Morrison of Intersystems had written that was capable of infusing SVG content into a PDF document. Apparently Stephen was approached about this and was amenable to sharing the code with us as we have recently encountered a similar need. I'm hoping this post will lead to the sharing of this utility code, so that we can determine if it will indeed suit our need.
According to the documentation (2016.1) we can use either a system defined web application (/api/deepsee) or create a custom web application for handling requests. What are some reasons to use one rather than the other?
I have a dashboard which shows the growth of the months compared with the month from the last year.
The way I found to develop that, it was with a kpi. So, I overrode the %OnLoadKPI method with two mdx:
SELECT NON EMPTY [DataD].[H1].[MothYear].Members ON ROWS, [Measures].[CountVisits] ON COLUMNS FROM SubjectAtendimento %FILTER [DataD].[H1].[Year].&[2016]
SELECT NON EMPTY [DataD].[H1].[MonthYear].Members ON ROWS, [Measures].[CountVisits] ON COLUMNS FROM SubjectAtendimento %FILTER [DataD].[H1].[Year].&[2015]
is there any mechanism available in DeepSee to keep values of AGE dimension up-to-date without rebuidling cube? Can age be determined at the mdx query execution time?
Has anyone implemented the 'DeepSee Visual Reporting' tool in realtion to TrakCare? If so, has anyone used it to customise Zen reports for TrakCare questionnaire preview/printing?
Hi! I am working on a project and I am facing a weird problem. I have created an MDX using Analyzer. This MDX executes very fast. I am trying to automate its execution with %DeepSee.ResultSet and the query never returns:
Set tSC = oMDX.%PrepareMDX(tMDX)
Quit:$System.Status.IsError(tSC)
Set tSC = oMDX.%Execute()
Quit:$System.Status.IsError(tSC)
What could be causing %Execute() to take so long to run while Analyzer is responding fast?
I need to create a KPI similar to the DeepSee.Model.KPIs.DemoTrendLines kpi in Samples. This kpi supports a scorecard widget with a trend line. It shows patient counts by city with a trend line of the count of patients over a decade. What I want is to show the trend line based on the average allergy score ([Measures].[Avg Test Score]). A pivot table query that shows the data I would want to base the trend line on is:
I need an example of what I need to "map" to have a common dashboard defined so it will visible/usable in multiple namespaces.
I have created a dashboard in "SAMPLES" (namespace and database) and I would like to have this dashboard be accessable/useable from a 2nd namespace, but I'm not having any success in doing mappings (global/package/routine/data) to be able to get DeepSee to be able to see/display the dashboard.
The situation is, I have a Partner that is looking to create common Dashboards in a SaaS model where the Partner's Clients would want to have their individual views of this common dashbaord be branded (logos, color, styles, etc.) to match the Client's branding. This my Partner's Client's End Users will see this common dashboard as the dashboard from the "Client" and not the "Partner" (and certainly not ISC branding)
By date
