All
Accepted answers
Alessandro Marin · Dec 16, 2016 go to post

Yes, there is currently a bug with pivot variables and calculated member using shared storage. Let's hope this bug will get fixed soon. I replace the screenshots which include ISNULL in the expression

Alessandro Marin · Dec 6, 2016 go to post

Hello Evgeny,

Yes, in this example it makes sense to use %OR instead of AGGREGATE. AGGREGATE can become useful when we the user needs to bring a measure inside the calculated dimension, for example to avoid crossjoining or having two measures in different axes. Also note that in the next major version an AGGREGATE function that acts on a set (first argument) with no expression (second argument) will be automatically replaced at the parser level with %OR for the purposes of calculating results.
Thank you for your suggestion, I updated the post.

Alessandro Marin · Dec 6, 2016 go to post

Hello Samuel,

I posted an article on Developer Community with a possible solution for this implementation. Please check this article. 

Thanks

Alessandro Marin · Nov 23, 2016 go to post

Hello Benjamin,

I suggest we discuss these issues in a WRC or TRC. This is the link to Support.

For example, we might want to look into some of these concept: Time vs Data Dimensions, sorting the members in a level from Architect, and the "Depends on" setting for levels that can be set in Architect.

Thanks

Alessandro Marin · Nov 9, 2016 go to post

Hello Samuel,

This is definitely not a newbie question, and ParallelPeriod could be very useful for the MDX you need. However, your pivot table has to be dynamic enough to work with different periods (Quarter, Month, Week). For this reason we might have to work on a KPI. I have two questions:

1) If I understand you correctly you want to be able to select any period (such as Jan-2014 or Week 2 of 2015), not only the current one (such as Nov-2016 or Q4-2016). Is that correct?

2) If so, what filters you like to appear on your dashboard? For example, would you like to have a dropdown menu to select Quarter/Mont/Week and a "dynamic" filter showing a Quarter/Month/Week for all years in your data?
 

Alessandro Marin · Oct 17, 2016 go to post

Hello Alexandre,


Yes, DeepSee supports hierarchical structures. 

DeepSee models are based on cubes, which define elements such as Measures, Dimensions, Listings, etc. The hierarchical structure in your question can be modeled using a Dimension containing one hierarchy with three levels. The levels in the hierarchy are, in order, the Group, Name, and Code levels. Once you define this model in Architect you will be able to use the hierarchical structure in DeepSee Analyzer.

This is the link to a video in the Video Portal. The video I link explains how to define Dimensions in DeepSee cubes: http://video.intersystems.com/video/Video.Pages.VideoLibrary.cls?video=2663141302001&playlistid=2621105743001
 

This is the link to the "Defining DeepSee Models" book in the documentation: http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=D2MODEL

I recommend reading section 2.2 "Dimensions, Hierarchies, and Levels". There you will find an example based on the Patients cube where an Age dimension (AgeD) includes one hierarchy with three levels ordered from the least to the most granular:

I also recommend reading section 4.6 "Defining Hierarchies Appropriately". 

Alessandro Marin · Oct 4, 2016 go to post

Thank you for the tip.

This problem never happened to me so I am curious to hear what is the output of 

w ##class(%DeepSee.Utils).%BuildCube("CubeName")

is when the problem occurs. 

To understand the underlying cause of the problem is there any way this problem can be reproduced? 

Alessandro Marin · Jun 2, 2016 go to post

Hello David,

I wanted to suggest to use the DependsOn feature (see http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY… I noticed that that does not work with named filters.

For example, say that your pivot table based on HoleFoods filters on a named set which selects a single City, and you defined in Architect/Studio dependsOn="[Outlet].[H1].[City]" for the Product Category level of holeFoods. An applyFilter control on Product Category still show all the members for Product Category.