Skip to Content
Former Member
Dec 11, 2007 at 05:39 AM

Displaying text whenever there is no value present in Database


Post Author: Sujitha

CA Forum: WebIntelligence Reporting


My business demands that a text 'Defaulted to Zero' be displayed if for a given combination of columns there is no data present in the Fact table.We use oracle 9i.

I have already used the number format where we put a value for the undefined value to display a text N/A where ever the value is not applicable.But i need to display text "Defaulted to Zero" wherever the value is applicable but NOT present in database!!

Can this be acheived in Bo level,I am using BO XI R2.?

This is a very urgent requirement as my project delivery is scheduled.!!

Many Thanks!!!