DeepSee: Comparision with the previous year

Question

Eduard Lebedyuk · Jun 3, 2021

#Analytics #Analyzer #InterSystems IRIS BI (DeepSee)

Is there a way in BI (DeepSee) to compare current value, to a value of a previous year?

For example I can hardcode this explicitly:

But I want in a widget to filter by year (1st column) and get the value for a previous year in a next column. YTY would be even better.

What MDX functions should I use? Examples?

Product version: IRIS 2020.1

Discussion (1)1

Eduard Lebedyuk · Jun 4, 2021

%CELL is exactly what I need:

SELECT
  NON EMPTY
  {
    [DateOfSale].[Actual].[YearSold].&[2016],
    [DateOfSale].[Actual].[YearSold].&[2017],
    %LABEL(%CELL(-1,0) / %CELL(-2,0), "YTY", "#%;")
  } ON 0,
  NON EMPTY [Product].[P1].[Product Name].Members ON 1
FROM [HOLEFOODS]

0 0