If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

SOLVED : Session parameter used as default value

Started by mahieusteph, 08 Jul 2013 04:39:13 PM

Previous topic - Next topic

mahieusteph

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.