#Analyzer

DeepSee Analyzer is a WYSIWYG editor for MDX queries which are the data sources for DeepSee interactive widgets

By update

Question

Trevor Strong · Jul 26, 2016

Defining pivot variables

Is it possible to populate a pivot variable with a defined runtime variable from the settings page?

If so, what is the syntax?

#InterSystems IRIS BI (DeepSee) #Analyzer

0 4

0 354

Question

Evgeny Shvarov · Mar 31, 2016

Running total without %CELL

Hi!

There is an example in Samples which shows how to implement 'running total' measure: "Pareto Chart for Category" dashboard.

To calculate running total this pivot uses calculated measure with %Cell expression:

Measures.[Revenue as Percent of Total] + %CELL(0,-1)

#InterSystems IRIS BI (DeepSee) #Analyzer #MDX

0 3

0 436

Question

Daniel Kutac · May 31, 2016

API to retrieve MDX from a save pivot?

Hello,

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.

TIA!

Dan

#Analyzer #InterSystems IRIS BI (DeepSee)

3 9

0 553