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

Dimensional queries from two dimensions

Started by ssfmik, 15 Mar 2011 04:05:35 AM

Previous topic - Next topic

ssfmik

Hi,
I have a powercube where I have version dimension (ie. ver1, ver2 etc). I want to have crosstab where i have one column for current planning version (works ok!) and another for selected version. I pick the selected version using #prompt('Versio', 'token', '[VersionDate]')# as normal filter would also filter out the default values.

The problem is that prompt (when nothing is selected) returns member set and when a value is selected a single member. I want to have a columns which shows default value or the selected version value - depending on choise. Any ideas? This column is then used to compare different versions against current.

Mikki