Using Repository Session and Presentation Variable in Title/Subtitle/Narratives

Sometime Business demands to show the Repository Session and Presentation variable in Title , Subtitle , Narrative etc . Now let see the way to achive this :
Using Presentation Variable in Title,Subtitle,Narratives
Defined a variable called ‘var_ename’ as Presentation Variable.

Define the title with ‘var_ename’ and use it as below : @{var_ename} .Also same can be defined in Subtitle and Narrative .

The default looks of the report will be below where Ename has been “Is prompted”  in report criteria.

After choosing the prompt Title, Subtitle and Narrative would be changing automatically :

Using Repository Session Variable in Title,Subtitle,Narratives
Customer requirement was to show dynamically the Currency type of the country in report title to show the Sales currency of the individual country in multi national deployment in the same report .
To achieve this I have written a Session variable initialisation block called “Country_Int” and return the currency value for the user from LOV type and make a Non-System session variable target called “CURRENCY” .
Now in my Sales Report it has been picked up by Presentation services after defining the below syntax under Subtitle :
The currency displayed is @{biServer.variables['NQ_SESSION.CURRENCY']}.

Similarly variable could be used in Narratives as RPD dynamic variable  ‘var_country’ added under Prefix section of the BI Narrative view .  

Creating a Reports in OBIEE 11g

For Creating New Reports,

1.Got to -> New ->Analysis you will have your Presentation Tables under Select Subject Area
Click on your Subject Area -> you'll get list of tables under the Subject Area
2. Expand the Folders and click the required column.
3. Click on Result tab - > you'll get Title and Table View
4. Format your Table view and Title View
5. Save your New Report in Shared Folders (You may create your own folder under Shared folder)

View the Reports on Dashboard.

1.Got to -> New ->Dashboard -> you will have New Dashboard Window
Name - Give the name of your Dashboard
Select Location - /Shared Folders/Standard Dashboard/
Click Ok -> you'll get Empty Dashboard window.
2. Edit the Dashboard -> Drag and Drop your Saved reports from Shard Folder under Catalog
3. Click on Save button (Top Right) and save your dashboard -> click run [Green right Arrow(Top Right)].
4. Now you'll have your report in your dashboard page.
Rename Dashboard Page

Edit the Dashboard - > Click Properties Nedt to X Symbol -> Dashboard Properties
-> You'll have the Dashboard Properties window -> Select the Dashboard Page -> Rename

Prompts:

1.Got to -> New ->Dashboard Prompt-> you will have your Presentation Tables under Select Subject Area
Click on your Subject Area -> you'll get the Untitle Prompt Window
-> Click + symbol -> Column Prompts ->you'll get list of tables
2. Expand the Folders and click the required columns from the list (the Columns should be your Report's table).
3. Save your New Prompts in Shared Folders.

Note: The Prompt columns should be Is Promptd in your Reports Filters.

Unable Sign in OBIEE 11g

Error: Unable to sign in in OBIEE 11g
OBIEE 11g has a common issue with it. Some time suddenly OBIEE server stops responding of user authentication.You will confuse if you have not changed any password or changes in repository.

This issue occurs due to an incorrect value for the <DNS> parameter for the BI Server in the Instanceconfig.xml file for the BI Presentation Server compared to the value in the Operating System's ODBC Administration setup for the Oracle BI Server Data Source

Steps to be correct this issue:
There are 3 steps to resolve this issue. If after step1 login fails then go for step 2 and so on.

Steps are:
Step A: Refreshing GUIDs (or Regenerating User GUIDs)

1. Check to see if any error messages regarding GUID mismatch is seen in the sawlog located in \OBI11g\instances\instance3\diagnostics\logs\OracleBIPresentationServicesComponent\coreapplication_obips1 folder/directory.
2. If yes, follow steps to refresh GUID as below:
1. Update the FMW_UPDATE_ROLE_AND_USER_REF_GUIDS parameter in NQSConfig.INI
1. Open NQSConfig.INI for editing at:

2. ORACLE_INSTANCE/config/OracleBIServerComponent/coreapplication_obisn

3. Locate the FMW_UPDATE_ROLE_AND_USER_REF_GUIDS parameter and set it to YES, as follows:
   

   FMW_UPDATE_ROLE_AND_USER_REF_GUIDS = YES;

4. Save and close the file.
2. Update the Catalog element in instanceconfig.xml:
   
   1. Open instanceconfig.xml for editing at:
      

      ORACLE_INSTANCE/config/OracleBIPresentationServicesComponent/
      coreapplication_obipsn

   2. Locate the Catalog element and update it as follows:
      

      <Catalog>
      <UpgradeAndExit>false</UpgradeAndExit>
      <UpdateAccountGUIDs>UpdateAndExit</UpdateAccountGUIDs></Catalog>

   3. Save and close the file.
3. Restart the Oracle Business Intelligence system components using opmnctl:
   

   cd ORACLE_HOME/admin/instancen/bin
   ./opmnctl stopall
   ./opmnctl startall

4. Set the FMW_UPDATE_ROLE_AND_USER_REF_GUIDS parameter in NQSConfig.INI back to NO.
   Important: You must perform this step to ensure that your system is secure.
5. Update the Catalog element in instanceconfig.xml to remove the UpdateAccount GUIDs entry.
6. Restart the Oracle Business Intelligence system components again using opmnctl:
   

   cd ORACLE_HOME/admin/instancen/bin
   ./opmnctl stopall
   ./opmnctl startall

7. After completing step 2, login to OBIEE as the problematic user to verify if you still encounter any login errors.

Step B: Delete user from Repository (RPD) file,  if present

1. Launch admin tool and open RPD in OFFLINE Mode.
2. Click Manage -> Identity -> Users tab to verify if you see this user present
   Note : Normally you will only see list of users when you open RPD in ONLINE mode. Unless the users were created manually in RPD, no users should be visible in OFFLINE mode.
3. If the user is present, delete this user entry from RPD.
4. Save RPD and deploy this changed RPD using EM.
5. Restart OBI Server component.
6. Re-login as the problematic user to see if you still encounter log in error.

If login errors persist after completing Step A and Step B above, then complete the following.
Step C: Delete the cacheduserinfo files from webcatalog

1. Take a backup of your webcatalog.
2. Navigate to \OBIEE11G\instances\instance2\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalog\SampleApp\root\users\Administrator\_prefs
3. Delete the files named "cacheduserinfo" and "cacheduserinfo.atr."
4. Open web browser and retest OBIEE 11g login for that user.

Note : The cacheduserinfo and cacheduserinfo.atr files get automatically recreated when the user logs in next time

Cache Management (Disable Cache in Perticular Report and Whole Environment)

Cache Management (OBIEE 10g and OBIEE 11g)

Cache management is used to improve query performance of reporting in OBIEE environment. But due to some reasons sometime we require to disable cache in OBIEE environment.

Below is the process how to disable/enable cache in OBIEE 10g and OBIEE 11g.

Cache management in OBIEE 10g:

There are 3 ways that we can implement to disable cache:

1. Disable cache for whole environment.

2. Disable Query Cache for one session

3. Disable query cache for single report/answer.

Disable cache for whole environment

To disable the query cache for the entire application, you must set to the ENABLE cache parameter the value NO in the file NQSConfig.INI

Disable Query Cache for one session:

To disable query cache for one session, you have to set the below mentioned session system variables with the value 1:

• DISABLE_CACHE_HIT

• DISABLE_CACHE_SEED

Disable Query Cache for for one Request/Answer:

 To disable query cache for one Request/Answers, you have to set the below mentioned request variables with the value 1:

• DISABLE_CACHE_HIT

• DISABLE_CACHE_SEEDE

If you want to disable query cache for a particular request, then do thefollowing things.

1. First add the required number of columns in criteria tab of Answer.

2. Then click on Advanced table.

3. Find the Prefix Box and write the following statements.

SET VARIABLE DISABLE_CACHE_SEED=1,DISABLE_CACHE_HIT=1;

When the value of the request variable DISABLE_CACHE_SEED is 1 for any request, then the OBI Server does not store the result of that request in Query Cache.

When the value of the request variable DISABLE_CACHE_HIT is 1 for any request, then the OBI Server does not look into Query Cache. So, even theQuery Cache contains result of the similar request, BI Server will not look into it,and it will get the result from back end Database.

OBIEE 11G Disable Caching

1. Open a browser and enter the following URL to navigate to Enterprise Manager Fusion Middleware Control: http://localhost:7001/em 

2. Log in as an administrative user. Typically you use the administrative username and password provided during the Oracle BI installation. In this example the user name is Weblogic.

3. In the left navigation pane, expand Business Intelligence and click coreapplication.

4. Click the Capacity Management tab.

5. Click the Performance sub tab.

6. Locate the Enable BI Server Cache section. Cache is enabled by default.

 

7. Click Lock and Edit Configuration.

8. Click Close when you receive the confirmation message "Lock and Edit Configuration - Completed Successfully.

 9. Deselect Cache enabled. Caching is typically not used during development. Disabling cache improves query performance.

 10. Click Apply

11. Click Activate Changes.

12. Click Close when you receive the confirmation message Activate Changes - Completed Successfully.

13. Restart the server to apply changes.