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