• What is dbt_artifacts?

    dbt_artifacts is a package for modeling a dbt project and its run metadata. It includes the following models to help you understand the current state of a dbt project and its performance over time. It...

  • Data migration from the Salesforce to snowflake Data warehouse by using Matillion

    Purpose of the Article: This blog explains how to load the data from Salesforce to Snowflake Intended Audience: This article will help our Organizational level kind of developers working on data migra...

  • WiMAX-A Study of Mobility

    1. Introduction The wireless market is growing rapidly; being pushed through wireless connectivity demand various wireless connectivity means are emerging (WLAN/802.11, WMAN/802.16a, WWAN/802.16d) [IE...

  • Weblogic Upgrade

    Patch Name wls1036_upgrade_generic.jar Reference https://www.youtube.com/watch?v=Be6hrYTANQE Just Click Next and Next MAKE SURE ALL OBIEE SERVICES ARE DOWN AND CLOSED IN PROCESS Open CMD prompt C:Mid...

Tags

bics installation OBIEE obiee 11g installation guide Oracle

Categories

Custom No Data found Message in OBIEE 11g

Custom No Data found Message in OBIEE 11g

When the results of an analysis return no data, the following default message is displayed to users:

OBIEECustomNoResultsView

We can modify the No Results view, by adding custom message or more explanation on the use of report or hints on how to filter values.  We can also change it’s visual formatting.

To do that, go to Results tab and click on Edit Analysis Properties:

OBIEECustomNoResultsView1

In Analysis Properties change the No Results Settings to Display Custom Message:

OBIEECustomNoResultsView2

In the No Results view we can add custom HTML and CSS styles, so even very complex pages with links, images etc. can be created. We will change the default message by adding report Header, changing the custom message its text formatting and hiding the Refresh button. We will use the p selector to change the paragraph text to grey, specify the Header (ErrorTitle class) font size and color and hide the Edit / Refresh links (ResultLinksCell class) using display:none property.

Here’s our custom No Results Settings with custom styles and message:

OBIEECustomNoResultsView4

If you choose Display Custom Message, but leave blank fields for Header and Message, the No Results view would display nothing but Edit / Refresh links (which you can also remove using CSS display:none property)

This is how the No Results view will look like after our changes:

OBIEECustomNoResultsView6

No Comments
Post a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.