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

Suppressing Nulls in a cube

Started by Yunus, 28 Aug 2009 12:15:13 PM

Previous topic - Next topic

Yunus

Hi all,

I have a cube that has many many NULLS in it and I can't make them go away.  In Transformer I have "Suppress blank categories" as my setting for Blanks, and inside the cube data that works great(I can tell by the size of the cube.  However when I look at the Cube in Analysis, any given intersection is correct but the totals by default still include all the Nulls.  This means that if you add up a given columns data you get the correct number, one example is 1524.  But at the bottom where it says total it says 25,879 because of the Null values.

Is there a way to make the totals not include the Null values?  My measure is simply a column with the #1 and I want to avoid having to make 10 measures, 1 for each column that contains nulls.

If my explanation is not descriptive enough or you need more info please let me know, I appreciate any help.

twlarsen

Hey Yunus,

I'm not really following your question.  If you have null values, then adding up the nulls should still lead to the 1524 number.  In transformer, are you using count instead of sum?

How would make 10 measures solve your goal?

I'm trying to understand what your goal is.

Todd

Yunus

I am using Count, I will try to use Sum and see if that changes my results.

If I use 10 queries then I can filter the Nulls out of each column.  Right now I can't filter those nulls out because the data looks like this
Columns are named 1,2,3,4,5 and X means there is data in that row, blank means its null.
|1|2|3|4|5|
|X| |X|X| |
|  |X|X| | |
|X|  | | | |

So if I filter all the nulls I drop rows I want, but if I do it in multiple queries I can remove the nulls out of a single column at a time, which is my goal, well either drop them or make transformer not display the results with them.