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

Suppress Cross Tab Column Headings

Started by kgcognos, 10 Nov 2014 07:59:52 PM

Previous topic - Next topic

kgcognos

Hi

I'm pulling data from 2 different dimensions in a cube. Region and Customer Class/Customer. Im using sectional headings for the Region and Customer class. Customer is my row. I am suppressing all rows with no data and also set the No Data content property.
When I run the report and filter on Customer class, the Customer class + the cross tab headings are still getting displayed even tho there are no Customer rows. How to suppress the empty crosstabs from displaying? I only want to show the Customer Class if there are customer rows.

This is what it looks like:

Region: XXX
--------------------------
Customer Class: ZZZ
--------------------------
Current Month    Prior Month
Sales                 Sales


Customer Class: YYY
--------------------------
                        Current Month    Prior Month
                        Sales                 Sales
Customer  A      123.00               456.00
Customer  B      123.00               456.00


Thank you in advance.

kgcognos

When columns are suppressed, the sectional headers are still getting displayed. Is there a way to only show the crosstabs with rows?
I want Customer Class YYY to show.

Region: XXX
--------------------------
Customer Class: ZZZ                     
--------------------------
No data available.


Customer Class: YYY
--------------------------
                        Current Month    Prior Month
                        Sales                 Sales
Customer  A      123.00               456.00
Customer  B      123.00               456.00