No Results error message Handler — Oracle Analytics

Oracle Transactional Business Intelligence Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

No Results error message Handler

1
Views
0
Comments
Kimberly_Nguyen
Kimberly_Nguyen Rank 2 - Community Beginner

Description

A way to catch the No Results error message with a user-friendly message

Use Case and Business Need

I have a dashboard that reports on HR metrics based on data range.  At time, there is no data returns, which is perfectly correct.  However, it is alarming for business users to to see this blaring No Results detail message.  It is an alarming message to users although it is not an error and the report simply returns zero result.  I tried using IFNULL(expr, value) however this does not work. Is there another way to customize this message when result does not return any data?

Original Idea Number: fac96c4087

No_Results_friendlier_message.png

1
1 votes

Submitted · Last Updated