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?
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?