Hi Alexander,
I am a newbie so trying to even understand the documentation. I created a pivot table from the Cards cube. The %CONTEXT applies only to a KPI, is it correct?
When it comes to part 2), I also reviewed the %CELL function, I tried to use it but since I am new to Deepsee, I keep messing up:).
Let's say I have the following pivot table
| ScoreGrade | 2000 | 2001 | 2002 | 2003 | 2004 |
| A | 200 | 150 | 85 | 15 | 30 |
| B | 275 | 300 | 25 | 25 | 45 |
| C | 35 | 60 | 55 | 50 | 57 |
| D | 400 | 450 | 350 | 250 | 200 |
This table is based off the following MDX query:
SELECT NON EMPTY [ScoreDate].[H1].[Score Year].Customers ON 0, NON EMPTY [ScoreGrade].[H2].[Scorer].Customers ON 1 FROM [CARDS]
In order to create an expression that will calculate the growth rate from 2000 to 2001, 2001 t0 2002 and so forth, We are using %CELL. I am simply confused as when I use it, I don't get the correct information.
- Log in to post comments