Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

OBIEE 11.1.1.9.5 'Include null Values'

user13816768May 2 2016 — edited May 2 2016

Hi all,

We are creating graphs, pivots in the obiee analystics (11.1.1.9.5) in the new releases we have option of showing rows with null values also.

But is there a way to print zero in the place of null?

The requirement is to show 0 instead of nulls for the months if there is no data.

Because of showing nulls, the lines on the graph are splitting because of no data.

Please help.

Graph With null values.png

Graph With 0 values.png

Locked Post

New comments cannot be posted to this locked post.

Locked on May 30 2016

Added on May 2 2016

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #obiee11g

12 comments

1,811 views