How to Show Null Value Columns/Rows in OBIEE 11G Pivote Table | The Big Data - Business Intelligence by Sandeep Venu

Enter key word

How to Show Null Value Columns/Rows in OBIEE 11G Pivote Table


Analyses often have sparse data that includes null rows and/or columns. By default, these null rows/columns are always suppressed.


  1. Oracle Database
  2. OBIEE Server
  3. OBIEE RPD
  4. OBIEE Maps
  5. Weblogic
  6. Errors
  7. Upgrade
  8. Customize
  9. Patch




To allow designers to display this data, a Null Non-Suppress option is now available within the report definition



Step : 1 Create and analysis and add a pivote table view.

Step : 2 Position the rows and columns as needed.




Step : 3 Select the Pivote table properties and make the changes as below





Step 4  Result 




Thanks,
Sandeep



SHARE

About Sandeep Venu

    Blogger Comment
    Facebook Comment

1 comments:

Joseph A. Wallace said...

Thanks for Information OBIEE (Oracle Business Intelligence Suite Enterprise Edition) is a comprehensive Business suite of enterprise BI products that delivers a full range of analysis and reporting capabilities. It gives business users the capability to perform in depth analysis and data mining of detailed business data and gives real and significant information for making critical decisions.OBIEE Online Training

Top Links

Upgrading BI Publisher

Add Google Search

OBIEE- LDAP

Change Admin Password

Best Practices

ORACLE 11GR2

Host Files

Customization

OBIEE-SIEBEL

Bug Fixes

Setting Default

OBIEE Installation failed

OBIEE Installation

Oracle Databse

Oracle In Linux

Loopback Adapter

Weblogic Failed

Yum Commands

Weblogic Admin

Linux Static IP

OBIEE LDAP

Admin Paswword

Scaling

Weblogic Starting Error

Localizing BI

Physical Schemas

Multimedia Dashboard

Video in OBIEE

Variables in OBIEE

Ago 30 Days

Email Link

ODI Installation

AGO Function

Sort Pivote table

OBIEE Patch

Reset Sys password

Date Calculation

Add Row in Report

Increase Row limit

OBIEE with Essbase

Reset Weblogic

BIP Login Error

MDS and BI Platform

ORA 28001 Error

ORA 12560 TNS Protocal Error

ORA 12154 TNS Error

OBIEE ON AIX

Pre Requsite

AIX Commands

Commands