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

Filter with multiple Dimensions with different names

Started by emanuelarico, 26 Jul 2018 04:39:46 AM

Previous topic - Next topic

emanuelarico

Hi everyone,
I am new with Report Studio.
I need to apply a filter to different cubes. They all have the same dimension structure, the only difference is that one has a different cube name and there the filter is not working.

This is the Member Unique Name of the one element from the dimension I use for the prompt and it works with all the cubes they use the same dimension's name (ACCOUNTS):
[PLANUNG_SALARY].[ACCOUNTS].[ACCOUNTS].[Accounts Level2]->:[TMR].[ACCOUNTS].[ACCOUNTS].[KS000]

This is the member unique name of the one that has a different dimension's name.
[PLANUNG].[ACCOUNTS_PERS].[ACCOUNTS_PERS].[Accounts  Level2]->:[TMR].[ACCOUNTS_PERS].[ACCOUNTS_PERS].[KS000]

I have one parameter where I save with a value prompt the value of [PLANUNG_SALARY].[ACCOUNTS].[ACCOUNTS].
There is a way were I can force a replace of the unique name saved inside the parameter? I tried already with a substitute but is not working (I was following this thread ->https://www.cognoise.com/index.php?topic=32829.0)

Thank you in advance!

rockytopmark

Well, I'd say substitute() is the way to go.  You indicated its not working... can you post your expression and any errors/messages that are produced to indicate its not working?