Extra Pages

▼

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

at

8 comments:

  1. obiee_noviceAugust 26, 2011 at 10:56 AM

    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?

    ReplyDelete
  2. John MinkjanAugust 26, 2011 at 12:50 PM

    Move the ifnull to a source view in your physical layer


    regards

    John

    ReplyDelete
  3. AnonymousOctober 19, 2011 at 7:34 AM

    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?

    ReplyDelete
  4. AnonymousOctober 25, 2011 at 8:39 AM

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

    ReplyDelete
  5. AnonymousDecember 26, 2011 at 7:55 AM

    I guess John does not have answer.

    ReplyDelete
  6. John MinkjanDecember 26, 2011 at 4:40 PM

    @Anonymous,

    Which ype of db are you using?

    ReplyDelete
  7. AnonymousJanuary 3, 2012 at 7:45 AM

    I am using Oracle.

    ReplyDelete
  8. AnonymousJanuary 12, 2012 at 9:02 AM

    any clue?

    ReplyDelete

Note: Only a member of this blog may post a comment.