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

Read level of Drill-up and -down & use this for Variable

Started by IceTea, 31 May 2011 06:49:42 AM

Previous topic - Next topic

IceTea

Hi folks,

i have little problem with a report. The report starts with a crosstab showing - let's say - Level1 Data. At this level, all is ok. The User can drill-down with the normal "drill"funcionality within Report Studio on click at one of the Level1-items to Level 2. Modelling is DMR with Hierarchy Level1->Level2-Level3 and so on.

Now the thing is that i have to show a conditional block with a drill-through-content but this block should only be shown at all levels UNDER level1. In other words: This Block should not be shown at Report-Startup at Level1, but after the user decides to drill-down it should be shown.

The Level1 is available as parameter in the report.

I'm trying around several hours now to compare the Parameter with the level1-field within the query in a variable, but this doesn't work (the comparison never changes result while drilling).

So has anyone a hint how to solve this problem?