I have exposed my dimension to the end user selection via a table of dimension, and used the selection to dynamically show it in a table (and graph etc ...) This is now working fine, but if I whan to add in the list a hierarchy it doesn't work ...
Here are an example I built to reproduce my problem :
create a variable : VselectedDimension [Dimension]
load this in the script
VariableDimension :
NoConcatenate
lOAD * inline
[
Dimension, DimensionOrder, DimensionPresentationName
Budget_Hierarchy, 1 , Budget_Hierarchy,
Level0, 2, 'Level 0'
];
//Data for test
TestData :
NoConcatenate
lOAD * inline
[
Level0, Level1, Level2, Value
A, AA, AAA,10,
A, AB, ABA,15,
A, AB, ABB,20,
A, AC, ABC,30,
B,AA, AAA,5,
B,AB, ABC,12
];
Create a table where field is =$(=$(VSelectedDimension)) and the label is =$(VSelectedDimension)
It works fine for simple dimension, but doesn't work for the hierarchy, any help ? is there a specific way to invoke a hierarchy ....
Thanks for your help and support,
Hedi
