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

Eliminating Null Rows in a Crosstab - Dimensional Model

Started by imeu, 13 Jul 2015 07:20:20 AM

Previous topic - Next topic

imeu

Hi,

Im sure most of you would have come acrossed this issue while reporting on a Cube. I have a issue here, In a crosstab report im taking Level's from 2 different Hierarchies of the Same Dimension as Rows. It has measure and a column as Selected Year_Month from prompt.

For example my Report is like this
                       Column1
Row1  Row 2   Measure

Row1 im able to filter on Measure > 0
But Row2 need to filter on Row1

How to do this? I tried using a tuple, currentMember, filter etc...nothing is working for me. Is it not working due to 2 different hierarchies? Please help.