OBIEE Online Training

OBIEE Online training by ex-Rittman Mead and Oracle trainer.
Contact : naveen@bipracticals.com
Watsapp : +65-82830121
Training will be real time and more hands on.
Number of slots available : 2/5

Thursday, September 13, 2012

RESOLVING DATA UNAVAILABILITY ISSUE IN BI PUBLISHER


Today i had an issue with the BI Publisher(BIP) reports which i had created. I was able to resolve it and thought i will post the solution here.

Scenario : I created a BIP report by importing RTF template.

Issue : Data missing in certain columns of the BIP report.

Test : I ran the query in SQL developer. I found that data is present for these columns . But no data is present when i run the BIP report for this.

Reason : We had renamed the columns in the select. For example : select schema.employee_id as "emp ID"

Solution : Instead of using alias as emp ID , name it as emp_ID . That means you should not leave space between the alias name.

Thank you

- Naveen