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

Picking the lowest level parameter in a report studio report

Started by davephall, 01 Sep 2009 07:26:52 AM

Previous topic - Next topic

davephall

Hi there,

I've got a report in Cognos 8.3 report studio using a powercube data source. This report has two parameters passed from a previous drill-through (directorate and directorate1) that each contain an MUN from the same hierarchy (but either could be at any level of this hierarchy).

What I'd like to do is show a set on the row edge of my crosstab showing the lowest level of the two, I'm not really fussed whether this is done in a filter expression or a slicer or some other method.

I've tried all sorts of methods, but every one seems to be erroring (generally about improper use of prompts), has anyone got any idea how I would achieve this?

davephall

So I've been fiddling around and I've managed, using ordinals and an if statement, to get a data item that returns a string of directorate or directorate1 depending on which set I need to use.

What I can't do, however, is return the actual set at a level that I choose. Because an if statement is used, it's moaning that it has to return a single value.

Has anyone got any idea how to return a set from an if statement or if there's a workaround?