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

cross hierarchy slicer to simulate an 'or' statement

Started by tlambert, 10 Apr 2012 02:24:02 PM

Previous topic - Next topic

tlambert

Hi all,
I have a dimensional data source (a cube I built) for hospital discharge data.

This is what I need to do: Count up the number of discharges where the principal diagnosis code or any of the 9 other secondary diagnosis codes where the code equals 493.

I have each of these dimensions in separate hierarchies.
1) Principal diagnosis
2) SD1 - the first secondary diagnosis code
3) SD2 - the second secondary diagnosis code
4) SD3
...
9) SD9

If I create one slicer for principal diagnosis = 493, and one slicer for each of the secondary diagnosis codes=493, the results are wrong (far too small, basically it's always 0) because it's like putting an 'and' statement between the slicers. Like saying: Count all the discharges where the principal diagnosis code = 493 and all of the secondary diagnosis codes are also equal 493.

What Cognos won't allow is a slicer which crosses hierarchies.

Perhaps my model of the diagnosis codes should be different (I'm also up against cube size issues). Perhaps there's a magic method to overcome this [can I somehow use the filter() function which isn't supposed to be used on dimensional sources?]

Another simplified example of what I'm trying to do might resemble: tell me how many products we sold to any woman or person over 50.

Thanks in advance for any help you can provide.