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.
