OBIEE - Display Row Number(Serial Number) in Pivot Table Report

To add row number to your analysis, You have to follow the below steps:

Step no: 1

Add the required columns to your report with one additional column (Any column).

Step no: 2

Select 'Edit Formula' from the additional column.

Step no: 3

Edit the 'Column Heading' with the relevant name and replace the Column Formula value with 'Rcount(1)'

OBIEE 11G Version Downgrade

How to Downgrade Repository:

    There is repository downgrade utility nqgenoldverrpd available to downgrade repository version. Using this utility you can downgrade repository from one version to another 11g version. But you cannot downgrade the repository from 11g to 10g.

Path:

• On Server - $MW_HOME/bifoundadtion/server/bin
• On Client - <OBIEE_Client>\Oraclebi\orahome\bifoundation\server\bin

Syntax:

nqgenoldverrpd -P <RPD-Password> -I <Latest version RPD file name & path> -O <Downgrade version RPD file name & path> -V <Version you want to downgrade>

Note:

 -P         - Your RPD password

 -I          - Repository path & name

 -O        - Downgrade new RPD path & name

 -V         - Version you want to downgrade

Example:

In our case we have downgrade from 11.1.1.7.1 to 11.1.1.7.0

11.1.1.7.1 - 326

11.1.1.7.0 - 325

Command Prompt:

C:\Program Files\Oracle Business Intelligence Enterprise Edition plus client tools\oraclebi\orahome\bifoundation\server\bin>nqgenoldverrpd -P Admin123 -I C:\RPD\New\Oracle_Analytics.rpd -O C:\RPD\Old\Oracle_Analytics.rpd -V 325