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

Cascading prompt to chose hierarchy for tree prompt

Started by colt, 30 Jul 2010 07:30:30 AM

Previous topic - Next topic

colt

Hi,
I have created a tree prompt with help of assistant. From that I get a new Query with 1 Dataitem DIM1 = rootmembers([cube1].[DIM1].[DIM1]).
If I run the report, I get the tree prompt with DIM1 as Element. By clicking on + sign left from the element, I can navigate.

After that, I have added additional prompt with static values 'DIM1', 'DIM2','DIM3'. I have changed the 1. prompt to be cascaded from  the 2. one.
Then I changed dataitem DIM1 from 1. prompt:

DIM1=    CASE ?prompt2param'
                WHEN 'DIM1' THEN  rootmembers([cube1].[DIM1].[DIM1])
                WHEN 'DIM2' THEN  rootmembers([cube1].[DIM2].[DIM2])
                WHEN 'DIM3' THEN  rootmembers([cube1].[DIM3].[DIM3])
             END

WHEN I run the report now, I first chose DIM1 and I get the rootmember of hierarchy [cube1].[DIM1].[DIM1] in the tree prompt as expected, but the
+ symbol to navigate within the hierarchy is lost.

Any ideas how to get it back ?  Any help appreciated.

Colt

Arsenal

doesn't seem like you're really using "cascading" prompts. I'm no expert at MDL, but you may have to use slicers with data items set to some combination of item or descendants along with set and perhaps a #prompt macro.