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.
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 :-)
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".