I was having trouble with some dimension based calculated members defined in Analyzer.  They would work and then not work.   At one point I had two identical calculated measures, same code, same specification and one would work and one would not.  I was trying to set them up in "shared storage", that checkbox in the calculated member dialog that should allow the measures to be used across multiple pivots. 

0 2
0 129

Measures and dimensions can be calculated using other members of the cube with MDX. Several measures and dimensions are added to a cube via Architect and their use demonstrated in Analyzer.

InterSystems IRIS Analytics (DeepSee) InterSystems IRIS Analytics (DeepSee)Cubes
0 0
0 0

MDX provides several functions for use with dimensions and measures. There are also several DeepSee specific functions. Sets and tuples can be included in your MDX query. Filters limit the scope of the dimensions and aggregates in the cube.

InterSystems IRIS Analytics (DeepSee) InterSystems IRIS Analytics (DeepSee)MDX
0 0
0 0

The DeepSee API provides a single method to prepare and execute your MDX query. In addition, you can execute a prepared query asynchronously which needs to be checked for completion before using the result set.

API InterSystems IRIS Analytics (DeepSee) InterSystems IRIS Analytics (DeepSee)MDX
0 0
0 0

Presenter: Joe Gallant
Task: Create a good analytical data model
Approach: Discuss what makes a good analytical data model. Provide examples of using DeepSee’s APIs for building custom dimensions, measures, and KPIs

Data models are the foundation of effective analytics. This session focuses on the factors that make good analytics data models. 


Content related to this session, including slides, video and additional learning content can be found here.

0 1
0 228

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.

0 6
0 407
Derrek Kegler · Mar 4, 2017
Calculated Fields
  1. How can I create a calculated field to give the previous date. For example, I need to create a pivot table that shows total payments posted for the prior day.

  2. How to create a calculated field to show average daily collections divided by the number of the days passed in a month. So, for today, it would be the average daily collections divided by 4days.


0 3
0 373

Hi community,

When I export the cube and the pivots that I made and import to another environment , the calculated metrics and dimension and also de pivot variable didn´t appear in the other environment. Because of this the pivot that use these metrics show error when you try to open. 

I want to know that this behavior is normal or exist a way that you can export everything, independent if you build inside the cube or inside analyzer.  


Jaqueline Krieger

0 3
0 297


I would like to know if DeepSee has some feature regarding synchronization which could help me with this:

I have two tables, TableA and TableB in a 1:n relationship, and one cube for each table, CubeA and CubeB.
CubeA have a list dimension based on records from TableB.
Both tables has DSTIME parameter set to "AUTO".

Some application proccess updates data only on TableB, leading an entry on ^OBJ.DSTIME global for synchronization of CubeB.
However, as the TableA wasn't updated, there isn't such entry for CubeA.

0 2
1 152
Daniel Buxton · Aug 1, 2019
DeepSee security issue

Hey Guys, 

Have enabled DeepSee on my cache db via 

Do EnableDeepSee^%SYS.cspServer(0)

I have created user with access to a profile with all the %Deep_See options (%DeepSee_Admin, %DeepSee_Analyzer etc etc) as well as %All.  I have also added %All to unknownuser

When click the DeepSee page and choose a namespace Architect, Analyzer, Reporting Data Definition and Reporting Builder are all greyed out with 'you do not have privilege to view this page

0 3
0 176

Subject Areas allow you to create a subset of an existing cube for use in Analyzer. You can filter the cube data and modify the cube members for the specific needs of your users.

InterSystems IRIS Analytics (DeepSee) InterSystems IRIS Analytics (DeepSee)Cubes
0 0
0 0

Using the MDX Query window of Analyzer, the syntax of MDX can be viewed. This is a great way to become comfortable with writing your own MDX queries.

InterSystems IRIS Analytics (DeepSee) InterSystems IRIS Analytics (DeepSee)MDX
0 0
0 0

Once you have successfully executed an MDX query using the DeepSee API, you have access to axes information through several methods. You can determine the number of axes and how many tupbles on each axes as well as axis metadata.

API InterSystems IRIS Analytics (DeepSee) InterSystems IRIS Analytics (DeepSee)MDX
0 0
0 0

Presenter: Barry Cooper
Task: Enable users to perform analytics within an application and take actions based on those analytics
Approach: Provide examples of embedding DeepSee within applications

Analytics is more than just using data to provide insight. Analytics is about taking action on that insight. See examples of how you can embed DeepSee in your applications, allowing you to take action.


Content related to this session, including slides, video and additional learning content can be found here.

0 0
0 148
Benjamin Bryans · Nov 23, 2016
DeepSee: Filtering a filter

When creating a filter located on a dashboard that targets all, is there a way to narrow that filter down?

For example, in our data we have some dates that are well out of range due to data quality issues, but they still appear in the drop downs. Is there a way to say, only make available the below dates in the filter?

Another example, If we want to only look at Emergency data, it still provides all the wards for inpatient activity and activity in other hospitals, meaning, to get to just the Emergency wards you have to scroll through everything?

Hope that makes sense.

0 4
0 370

Hi everyone! My company has a Zen ERP application with CSP delegated authentication. Now, we're developing a separated BI application, using Angular, which consumes DeepSee REST API services. Both applications access the same Caché database.

How to implement single sign-on strategy in order to allow an already authenticated ERP user to access DeepSee REST services? Has anyone already implemented something like that?

Thanks in advanced.

0 3
0 462

Hi everyone.

I have a cube with two dimensions, DimA and DimB, with the following structure:





LevelC is modeled in such way because its bound property (C) is group by properties A and B in transactional database, but A and B haven't relation.

I can use DeepSee REST API service /Info/FilterMembers/:datasource/:filterSpec specifying each dimension one filterSpec parameter and handle the results.

But, I would like to have the results for both dimension in only on service call.

0 4
1 178
Oliver Wilms · Aug 13, 2019
Dashboard - Line Graph


I want to create a dashboard with a line graph that shows system availability over time. I used this code to create a Dashboard:


            Set tItem = ##class(%DeepSee.UserLibrary.Link).%New()
                Set tItem.fullName = "Availability"
                Set tPage = "Availability.UI.CSVImport.zen"
                Set tItem.href = $system.CSP.GetPortalApp($namespace,tPage)_tPage
                Set tItem.title = "Availability"
                Set tSC = tItem.%Save()


0 7
0 224