Hi everybody.
I am currently working on a cube and I would like to use a session parameter as a default value in a #prompt function.
This is my point:
In my cube, I have an axis Entity. Each user may access several entities but has only one default entity.
To make it easier to find the default entity, I created a session parameter which contains the MUN of the default entity.
I would like to create a #prompt function on the Entity axis taking in default value the default entity.
To do that, I inserted a data item containing this kind of function :
#prompt('Entity','memberuniquename',$SessionParameter)#
When I run my report, I can see the correct default entity but the session parameter is recognized as a string, not as a MUN (when I use a fonction such as children(data item), i get an error).
Does anybody have an idea ?
Thanks in advance,
Stephanie
EDIT : we finally found a solution to our issue => we added in the construction of the session parameter a combination of two substitute function in order to replace the quotes by nothing.