OBIEE 11g – No Results

No Results feature in OBIEE helps users to customize the default message.
Below is the default message received, when the report contains restrictive filters or no data in it.

You can customize the default message as per your requirements.
1. Create Simple Report
On the Criteria Tab, click on Properties and select ‘Display Custom Message’
Type the header & custom message in the message box and click ok.

2. Check the Result
Select the prompts to run the report.

- Santosh

OBIEE 11g Edit Analysis – Criteria Tab

Posted by Santosh Kumar Gidadmani on May 13, 2012
If you have observed in 11.1.1.5 version, there was no direct option to go to criteria tab when clicked on edit analysis. This feature is available now in 11.1.1.6 in my account section.

If you want this feature, click on my account -> Analysis editor and select “Start on Criteria tab when editiing analysis”. click ok.
Next time when you click on edit analysis, the system will take you to criteria tab.
- Santosh

OBIEE11g – Import Data – Connection Failed Error

Posted by Santosh Kumar Gidadmani on May 12, 2012
If you get “The connection has failed” error while trying to import data from the database using OCI call interface in RPD, perform the below steps.
1. Add the tnsnames.ora file in the BI Home Directory
Ensure, you add all the data source tns entry details in the tnsnames.ora file
Copy the tnsnames.ora file from Oracle Home (Root directory: \App\User\Product\Network\Admin) and paste the file to the below location in OBIEE11g directory
Root directory: \OBIEE11g\Oracle_BI1\network\admin and
Root directory: \OBIEE11g\oracle_common\admin
2. Add the tnsnames file location path in User.cmd file
Add the tnsnames file location path from one of the above location in the user.cmd file. The user.cmd file is found in the below location
Root directory: \OBIEE11g\instances\instance1\bifoundation\OracleBIApplication\coreapplication\setup

Now, it should work. Still if you are unable to get the data, close your RPD and try it.
Restart the services if RPD is still not importing data.

No comments:

Post a Comment

Popular Posts