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

Tree Prompt

Started by Jeka, 08 Jan 2009 02:03:57 PM

Previous topic - Next topic

Jeka

Hi,
Maybe someone can answer my question.

Using Cube.

Created an Optional Tree prompt with (rootMembers([Ledger].[Department].[Department]) )
then
I created a member in the report with ([Ledger].[Department].[Department])

When user selects for example 2nd level on in the Tree prompt then he can drill down in the report.

Issue: If the user doesn’t select anything in the tree prompt then after running the report i see every single level(and all the members of all levels) of the Department Hierarchy in the report.
How can i make it if the department not selected then only show the highest level NOT All levels ?

Thank-you