Customized Error Messages for WebI Report

[Former Member]

Hi All,

Is it possible to add customized error messages for WebI Report.

e.g. When I refreshes a report, if data is not available for selected Prompt values, i would like to show the message as 'Data not available for the combination A, B and C.' instead of 'No data fetched for Query'.

Also, please let me know if any other tool within BO can facilitate this requirement.

Thanks

Anu

[MariannevL · Accepted solution]

You can use the following work-around without the need for an SDK solution.

Display this info in the report in stead of in the pop-up...

Just create a cell with the info want to show and hide it if there is data,

(use and alerter to empty it when you have data and hide on empty)

show it when there is no data fetched.

Hope this helps,

Marianne

[Former Member · Accepted solution]

That is a cool idea, but how to supress the Query message 'No Data to fetch'?

Thanks,

Anu

[MariannevL · Accepted solution]

Hi,

The only work-around I have seen to suppress that is by unioning another query to it that selects a dummy row,

which is filtered out in the report.

Not pretty, but it works.

Good luck,

Marianne

[Former Member · Accepted solution]

Anu,

That post exactly correct one. UNION of queries to avoid no data to fetch message.

It will work out, just try it.

Thank You!!

Sent from iPhone

[Former Member]

checking Union option