Oracle Transactional Business Intelligence Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› More Solutions Idea Labs› Oracle Transactional Business Intelligence Idea Lab

Categories

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

No Results error message Handler

Submitted
21
Views
3
Comments
Kimberly_Nguyen
Kimberly_Nguyen Rank 2 - Community Beginner
in Oracle Transactional Business Intelligence Idea Lab

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

Tagged:
1
Up
1 votes

Submitted · Last Updated

Comments

  • Michael Scaduto
    Michael Scaduto Rank 3 - Community Apprentice

    You can enter a custom "no results" message in Edit Analysis Properties, screen shot below...

    3-21-2018 1-28-39 PM.jpg

  • Kimberly_Nguyen
    Kimberly_Nguyen Rank 2 - Community Beginner

    AH!  Thank you.  That was simple

  • Munish Goswami-66923
    Munish Goswami-66923 Rank 1 - Community Starter

    Wouldn't it be easier to be able to define a universal No Results so it is not required to define on each analysis. The current option could be used as override if any analysis require a specific message rather than a universal message!!