Displaying text whenever there is no value present in Database

Post Author: Sujitha

CA Forum: WebIntelligence Reporting

Hi

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!!!