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 will only show the highest hierarchy level

Started by SimonWM, 07 Dec 2016 04:37:53 AM

Previous topic - Next topic

SimonWM

Hey everyone,

I have got huge difficulties with a Report that contains both dimensional and relational data (wrapped up in one package via Framework Manager).

For a start: I would like to create a tree-prompt (based on the dimensional source), that's showing only two hierarchy Levels, 'Article Group' and 'Article'.
Having a formula like children([Article Group]) the prompt will only Show the highest Level, leaving the user being unable to "drill down".
Having a formula like Descendants([Article Group];2) the prompt will only show the lowest (article) level leaving the user with 200+ choices...

On a different report, children([Dimension]) is working perfectly well.. I have no clue, how to solve this.

Anyone already encountered this kind of Problem?

Thanks and regards,
Simon