Skip to Content
Author's profile photo SESHA PS

Hiding Unwanted information/data in Webi Reports


This document will focus mainly Hiding unwanted data with relevant LOV in Webi report. There are scenarios where we need to hide objects/blocks/charts/rows/columns based on business needs. This document will cover most of the scenarios.

Sample data used in all scenarios :


Below are the list of scenarios which are going to cover in this document .

1.Hiding Dimension Object

2.Hiding Rows/columns when dim/measure value is null/empty

3.Hidng measure value which contain 0 as value

4.Hiding  duplicate records

5.Hiding data based on most  recent record in Webi

6. Hiding data based on user response

7.Hiding data based on condition

8.Hiding data using input control

9.Hiding section

1.Hiding Dim object :

To hide dim object selct particular dim object like here emp name and right click on selected object and you will get list of options as below and there you will see hide option.


Now select Hide dim option then emp name will be hidden in report .If you wan to show it again then right click on table/block then you will get show hidden dim option selct show hidden dim.It will display all hidden dim in report.

Note : when you create  a new name for  a column i.e custom header and it isn’t attached to the dim .Therefore , when you hide dim the column and show it again it will revert to the old name .If you want to show a new name and have it persist , you will need to create a variable.

Ex: In the above table If we rename emp name as Emp First name as header  and we hide this and again If I show then it will display emp name instead of Emp First name .

2. Hiding row/column when dim /measure value is null/empty.

There are 2 approaches for this  a) Using variable b)Changing default standard settings.

a) Using variable

Create variable in report as v1 =if(isnull([sal] then “1” else”0″

Now restrict table/block with created variable as “1”  then it will hide empty/null values of sal in report .



For dimensions also same will be applicable .

v2 = If (isnull(Emp name])) then “1” else”0″

b) Changing default setting of table /block :

Right click on created table/block then you will see format table option and in General tab you have to change settings as below .


Here by default show rows with empty all measure values will be enabled just disable this option then empty measure values will be hidden in the report.

3. Hiding measure objects which contains “0” as value.

By default for  a table/block   as shown in above image show rows for which all measure values =0 & show rows for which the  sum of measure values =0  these 2 will be enabled just disable  then it will hide measure objects which contains “0”

Ex: Here in above table for ps emp it has 0 as measure value



4. Hiding duplicate records in webi

   How to get Unique /Distinct Records in Webi Reports

5.Hiding data based on most recent record using date dim

How to get most recent  record in Webi report

6.Hiding data based on user response

7. Hiding data based on condition

8. Hiding data using input control


9 Hiding section

Hiding Section in a Webi Report

I will  update more scenarios .

Any suggestions/comments are welcome.



Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Saurabh Raheja
      Saurabh Raheja

      very nicely articulated 🙂

      Author's profile photo Yassine BOURICHI
      Yassine BOURICHI

      Good article.

      Is there a way in webi to display dimensions in a compact rows as in Analysis for office ?

      I would like to make my crosstab in picture1 the same as in picture 2.



      Thank you,

      Author's profile photo Venugopal Reddy
      Venugopal Reddy

      Hello expert,


      I need to hide a row when there is an active order in webi report.


      If no active order then need to show which is present


      Could you plz explain how I can achive