How to show Null values as blank in reports

It is very common from a user to ask you mask Null values to something else, for example Null to be shown as Zero.

But, I come through a reverse requirement where user wanted to show Null as Null without any masking. By default, Obiee was showing zeros.

Quickly, it clicked in my mind I changed the setting at Physical layer in RPD.

Let’s go step by step.

  1. Values are being shown as 00/00/00 and 0.0 in second fourth and fifth column rescpectively in below screen shot.null1
  2. User wanted them to be shown as below.null2
  3. All you have to do is to login to RPD and Navigate to Physical columns of respective columns.
  4. Check the ‘Nullable’ option as shown below and Press OK. Then save the rpd and check
  5.  .null3Please share your thoughts if it helped and keep watching this space for more updates.You can follow me on twitter (@akashdgarg) for quick updates about what’s happening in the area of BI, Big data, OBIEE etc
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s