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:
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?
Move the ifnull to a source view in your physical layer
regards
John
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?
Any clue. I am still stuck. Deselecting Nullable aint working.
I guess John does not have answer.
@Anonymous,
Which ype of db are you using?
I am using Oracle.
any clue?
Post a Comment