Clear cookies on exit Internet Explorer / Firefox

For Internet Explorer
Internet Option -> Advanced Tab ->security Section->Check Empty Temporary Internet Files folder when browser is closed

 



For Firefox

Option->Privacy Tab -> Select Firefox will Use custom setting for history -> check Clear history when Firefox closes

























Till next time

OBIEE – Report Prompt Link OBIEE 11G

These are steps for create report prompt link in OBIEE 11G:

1. Create the Dashboard Prompt

From Answer create dashboard prompt

Copy and paste this query to SQL results

Choose Presentation Variable on set a variable and for example name it with option then click OK

2. Create a Conditional Report

Drag any column and edit column formula. This logic will force condition to return Quarterly Balance Sheet value

 Fill Variable Expr with option (Presentation Variable)















Do same step for Monthly Balance Sheet report.

 




















3. Configure the condition on a Dashboard
Click on Section->Property->Condition

 Click on New Condition

 Click Browse button

Select Quarterly Balance Sheet Custom analysis, Click OK

Perform Test Button

 It should return True 
 Do same step as for Monthly Balance Sheet Custom

When user select view by from dropdown list Quarterly Balance Sheet, user will get Quarterly Balance Sheet report

When user select view by from dropdown list Quarterly Balance Sheet, user will get Quarterly Balance Sheet report



Till Next Time 

OBIEE variables overview

Unable to Sign In into presentation services and RPD obiee 11

Issue : Unable to Sign In into presentation services and RPD obiee 11 
Solution: refresh the GUID.A refresh forces the system to reference the user GUID contained in the new directory server. Authentication errors may result if the GUIDs are not refreshed and the system detects a mis-match for the user GUID.


Here are steps how to refresh the GUID's:


To refresh the user GUIDs:


1. Open the NQSConfig.INI file for editing.Locate the setting FMW_UPDATE_ROLE_AND_USER_REF_GUIDS = NO and change its value to YES.


2. Modify the instanceconfig.xml file to instruct Oracle BI Presentation Server to refresh GUIDs on restart. Edit the file to add the last line in the following instruction


3. <ps:Catalog xmlns:ps="oracle.bi.presentation.services/config/v1.1"> <ps:UpgradeAndExit>false</ps:UpgradeAndExit> <ps:UpdateAccountGUIDs>UpdateAndExit</ps:UpdateAccountGUIDs>


4. From a terminal window, stop and restart the managed processes using the opmnctl parameters stopall and startall.


5. Edit the NQSConfig.INI file to reset the FMW_UPDATE_ROLE_AND_USER_REF_GUIDS = YES to NO and restart the Oracle BI Servers.


6. Remove, set to none, or comment out the line (see UpgradeAndExit in the following example) added to the instanceconfig.xml file (that instructs Oracle BI Presentation Server to refresh GUIDs on restart).
<ps:Catalog xmlns:ps="oracle.bi.presentation.services/config/v1.1">
<ps:UpgradeAndExit>false</ps:UpgradeAndExit>
<ps:UpdateAccountGUIDs>none</ps:UpdateAccountGUIDs>
Restart the Presentation Server for the instanceconfig.xml file that was updated.


7.Make sure Oracle WebLogic Server and the system components are also running, if they are not running, restart them.

List of Bugs Fixed for Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.6.0

The attached PDF document provides a listing of Oracle Business Intelligence Enterprise Edition (OBIEE) bugs which have been fixed in the OBIEE 11.1.1.6.0 release. It also lists the bugs fixed in Oracle Business Intelligence Publisher (BIP) and Essbase
Please click here to download

OBIEE 11G Configuration and Log file

Here are OBIEE 11G Configuration and Log file:

• RPD Directory : C:\Middleware\instances\instance1\bifoundation\OracleBIServerComponent\coreapplication_obis1\repository
• NQSConfig.INI : C:\Middleware\instances\instance1\config\OracleBIServerComponent\coreapplication_obis1\nqsconfig.INI
• NQClusterConfig.INI : C:\Middleware\instances\instance1\config\OracleBIApplication\coreapplication\NQClusterConfig.INI
• nqquery.log : C:\Middleware\instances\instance1\diagnostics\logs\OracleBIServerComponent\coreapplication_obis1\nqquery.log
• nqserver.log : C:\Middleware\instances\instance1\diagnostics\logs\OracleBIServerComponent\coreapplication_obis1\nqserver.log
• nqsserver.exe : C:\Middleware\Oracle_BI1\bifoundation\server\bin\nqsserver.exe
• Webcat Directory : C:\Middleware\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalog\
• instanceconfig.xml : C:\Middleware\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1\instanceconfig.xml
• xdo.cfg : C:\Middleware\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1\xdo.cfg
• sawlog0.log : C:\Middleware\instances\instance1\diagnostics\logs\OracleBIPresentationServicesComponent\coreapplication_obips1\sawlog0.log
• sawserver.exe : C:\Middleware\Oracle_BI1\bifoundation\web\bin\sawserver.exe

Missing Administration Navigation OBIEE 11G

How to return missing administration navigation

 

Click on user->My Account

 

 

On Preferences tab set Accessibility Mode from On to Off

Your browser is not supported by Oracle BI Presentation Services (OBIEE 11G)

If you want to use the OBIEE 11.1.1.5.0 with Firefox 10+ there is one work around. Please perform following steps:

1. Type "about:config" into an address bar
2. Right click anywhere and choose New / String
3. Name it "general.useragent.override"
4. Put the value "Mozilla/5.0 (Windows; Windows NT 6.1; rv:10.0)Gecko/20100101 Firefox/9.0"
5. Refresh OBIEE login screen