Obiee Developer Utility - Direct Log-on to Dashboard

If you are frequently logon to BI Dash Board and if you want to have a short cut key which can launch bi server page and also logons, then here is solution.

Open notepad type as below


BASEURL= http://bi-server-name/analytics/saw.dll?Dashboard


URL= http:// bi-server-name/analytics/saw.dll?Dashboard?NQUser=Desire-User-Name&NQPassword=User-Password


Then save this file as BIAnswers-or-whatever.url file extension must be .url and place it on desktop, now using ctrl+alt+L key press will launch BI Server url and also redirect you to default user preference page.

Enjoy shortcut's...

Obiee Developer Utility

If you are an OBIEE Developer then this utility will be very handy.

If you are encountering very frequently stop and restart of BI services ("Oracle BI Java Host","Oracle BI Presentation Server","Oracle BI Server","Oracle BI Scheduler") then go on reading.

Create a bat file with all services and assign shortcut key.

Here in detailed

1) Download bat file from here
2) Place it any folder.
3) Right Click and send to Desktop
4) Locate created shortcut on Desktop,
5) Right click choose properties and goto Shortcut tab assign key Ctrl+Alt+s
That’s all set; now you can stop restart all services with Ctrl+Alt+s key press.

Oracle BI Answers Access Prohibited

Yester day I saw something like ‘Access prohibited’. I have no clue why and from where it has come. So started investigating and I could reproduced it.

Dash Board says ‘You are not currently authorized to use Oracle BI Answers. If you would like to use this powerful capability, please contact this site's administrator. .Available Links: Dashboards’.

This screen occurs because of following sequences.
1 Using answers privilege log on to dash board
2 Click Answers Link
3 Sign out from this page i.e. url look like http://biservername/analytis/saw.dll? Answers&_scid=sessionid
Sample: http://localhost/analytics/saw.dll?Answers&_scid=eBsXeMHWIww
4 In the above page re-logon using un-authorized to Answers user.
5 As soon as logon message will be Access Prohibited.

It’s because of Url path suppose to land up user in Answers pages.

Step by Step to Bypass All Caches

Today i have requirement for Live Report(by pass server cache, presentation cache) if this requirement is for one page among somany pages in same subject area, all other pages are cacheable then following solution will be ideal.

1 Build Report with required fields,
2 Go to Advance SQL tab check the Check Box ' Bypass Oracle BI Presentation Services Cache'
3 Goto bottom of page look for 'Prefix' in text box type 'SET VARIABLE DISABLE_CACHE_HIT=1;'
4 Save the report

If you have any prompts on this page, want live data to be pull in prompts, for that while creation of prompt go to show, choose SQL Results from drop down, in edit box prefix 'set variable DISABLE_CACHE_HIT=1' followed by what ever the query required.

Advance SQL Query Prefix's

I'm in process of collecting all possible prefix postfix variables which can mention in Advance SQL Query tab.

As of now collected variables are


Sample usage:

For multiple commands to set ?

If you are using multiple varaibles in prefix make sure there is space in between variables and variables are separated by comma's other wise you may likely hit with following error.

Odbc driver returned an error (SQLExecDirectW).
Error Details
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 27002]
Near : Syntax error [nQSError: 26012] . (HY000)

Tool to FindOut Cache Creation Time

Sample cache file
these files usually resides under .\OracleBIData\cache or Cache folder specified in Config file(NQSConfig.INI -- >DATA_STORAGE_PATHS =’abc folder full path’)

XYZ is BI Server running Machine Name
733536 is Days elapsed since 12:00:00 midnight, January 1, 0001(millenium start date)
40458 is Seconds passed since 00:00:00 Hours
00000071 is Incremental number since active BI server session:

If cache file physically present in cache directories then its simple to find out cache creation date by checking modified date property in folder or using administration-cache menu check for creation date.
But if you want to analyze cache related errors under Usage track, its hard to find out when it got created so I have build a GUI which can aids in knowing cache creation date.

ho ho ...its shows exactly +3 days of creation date, in horry i have not properly coded,I will try to upload new GUI.

Step by Step to Connect Remote RPD from Local Machine

Step by Step to Connect Remote RPD from Local Machine So often I use to access remote RPD's (Dev,QA,Prod etc) to access them I use to use Remote Desk Top.

Recently I have discovered other method to do this, by make using ODBC Data Source Administrator (odbcad32.exe)
Create System DSN with all required information in following way.
Step1 Start-----Run—“odbcad32.exe” Enter. Step2 Go to System DSN,
Click on ADD Choose Oracle Bi Server as Driver.

Step3 Give a generic Name as you wants. Exp Dev-Server-RPD
Description: not a mandatory field
Server: Specify which server repository you want to connect either Machine Name or IP Address ,Click Next.

Step4 Specify login details of RPD /BI Server, Click Next.

Step5 If you wish to change any default behaviors you can change here other wise Click Finish.

Step6 Open Administration (Start—Oracle Business Intelligence –Administration)
Click on “Open Online”
Choose required RPD from list of available BI Servers.
Provide proper credentials, Click Open.

Now you have connected remote server from local machine, what ever the changes you want change them and save they will be reflected on remote server.