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

[RS] Zero suppression in drilldown-crosstab report against an powercube

Started by Iceman, 07 Nov 2006 03:30:51 PM

Previous topic - Next topic

Iceman

Hi,
I'm trying to build a crosstab report i ReportStudio against an Powercube. The report will be drillable in the rows (not drillthrough to another report, just through the dimension.) For example: I start with ProductLine in the rows, and click an row to drilldown to the ProductType level and so on.
On the lowest level I need ta apply zerosupression, (for exampleÃ,  ProductName), but I dont get it to work.
If I place a summary filter in the query, (meassaure<>0), I need to set a scope for the filter. Since I don't have ProductName in my original report I can't set the scope to it, and therefor the summary filter wont work.
If I add the ProductName level to the query and then set the scope to it, I'm no longer able to drilldown in the report, because you only can drill on the lowest-level-querysubject in the query...

Any suggestions how to solve this?

???

Regards.

Blue

Have you tried putting the filter at the detail level?
What about using a slicer filter?
Robert Edis
Principal
Robert Edis Consulting
Rotorua, New Zealand

Iceman

A detailed filter wont suppress the rows. A slicer don't suppress the other rows either, it just hide the figures for the "unsliced" categories...

  /Iceman