Wednesday, September 10, 2008

OBIEE Null, Nul and Nullable

Consider the following table:


After adding it to the repository make a simple report:
Hmmmmm, something is not right here..

I was expecting a "NULL" and a "0"....

Go back to you the physical layer of your repository and check the Nullable box.

Now it's right:
OBIEE converts a "NULL" in double type field to "0" if this box isn't checked.

Till Next Time

8 comments:

obiee_novice said...

There are columns in my physical layer marked as nullable and they are mapped to logical columns.

I am using these columns to define calculated logical columns.

If the value in one of the column is null, the calculated column evalues to null.

For example, col1 + col2
If col2 is null, then expression evaluates to null.

I think adding IFNULL check can sovle this issue, but I have hundreds of such calculation defined, Is there a better solution?

John Minkjan said...

Move the ifnull to a source view in your physical layer


regards

John

Anonymous said...

i am facing same issue. i deselected Nullable in physical layer, but the values are still showing up null when queried. what's wrong here?

Anonymous said...

Any clue. I am still stuck. Deselecting Nullable aint working.

Anonymous said...

I guess John does not have answer.

John Minkjan said...

@Anonymous,

Which ype of db are you using?

Anonymous said...

I am using Oracle.

Anonymous said...

any clue?