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

Levels - nulls

Started by cognosun, 17 Nov 2012 10:53:54 AM

Previous topic - Next topic

cognosun

Is there any limitation in transformer cubes like if a primary key column in a table holds any nulls it won't show that level in the cube ?

Like we have 2 levels in a dimension, and when we drill down, Analysis studio is showing us only second level, skipping the first level.

This first level comes from a table whose primary key has 2 columns, one of which has nulls.

We are on oracle.

cognosun

Primary key won't allow nulls....but what I meant was, we have 2 columns ( in a table) as a key to join , here one of the column in the key is defined as primary key and other is non-primary key column, but this second one is also part of join-relationship, and has nulls :-)

bdbits

Personally I recommend using surrogate keys and would not allow nulls in key columns, but I realize that is not always an option. A couple of ideas...

In your data sources, right-click the query for your level and use the Data Source Viewer. See if the row is getting returned in the query. If not, you may want to have a look at the query subject in FM.

You might want to open the general tab on the level properties. If the source and/or label is null, maybe it is blank and you can use blank substitution on this tab to set a value. You might also want to set inclusion to "Always include".