O.B.I.E.E

Site Map of BI(OBIEE) Application

2011-12-07T13:57:00.001-08:00

It's been more than a year was busy with projects and now got little time and thought of sharing with you all an interesting utility with you, I hope everyone loves it. Now coming topic, each and every text book will have index(chapters) which helps you to navigate to straight to specific page instead of looking at each and every page and if you look at many corporate sites will be having site

OBIEE 11g Download link

2010-08-13T17:59:00.000-07:00

Find OBIEE 11g download linkhttp://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/bus-intelligence-11g-165436.html

Working with Oracle BI Briefing Books

2010-07-02T22:06:00.001-07:00

Oracle BI Briefing Books are used to store/capture a series of static images of pages/requests at server, allowing the information to be viewed offline and shareable with others users or we can keep track of changes offline.How do we enable this feature?By default this functionality will not be available to everyone how is using Oracle Business Intelligence.We need to do few server side

OBIEE 11g Product Launch on July 7

2010-06-03T12:15:00.000-07:00

I am excited to look forward "OBIEE 11g" big bang.Count down has started .. only 34 days to go hurrayyyyyyyy :)If you want to join product launch event, click here to register

OBIEE On Cloud

2010-04-21T00:24:00.001-07:00

Check out this SlideShare Presentation: OBIEE On CloudView more presentations from guestb9ab838.

Best practices: Have warehouse statistics as report

2010-01-08T15:52:00.000-08:00

Today I would like to share one good practice for OBIEE administrators on warehouse statistics why they are good to collect. It’s better to have a dashboard page with all statistics/parameters of objects which are used in building your warehouse. By this administrator can judge/analyze/enhance few data issues very quickly on broader way. 1) User complains about not able to see latest data. 2)

Merry Christmas

2009-12-24T13:02:00.000-08:00

I wish you a Merry ChristmasHave a safe and happy holidays,Srinivas Malyala

Unexpected query string(obiee url) behavior

2009-12-17T16:52:00.000-08:00

I have observed one strange/unexpected behavior long back, thought of sharing with you guys. To observe please login to any OBIEE Dashboard now go to browser URL, replace all characters after saw.dll? With ReloadDashboard (url looks like: http://yourobieeserverurl/analytics/saw.dll?ReloadDashboard) and click on go. What you guys expect? What I have expected here, dashboard page reloads.

RSS option in OBIEE

2009-12-15T20:48:00.000-08:00

With RSS feed we can see/track changes within catalog folder that appears on dashboard page by enabling RSS feed option. To enable RSS feed option, follow these steps: 1) Go to Dashboard Objects (You can see dashboard objects when you create or edit dashboard pages) 2) Drag and Drop Folder object on to construction page. 3) Click on folder properties, Pops up with web panel. 4) In above

How to Get UserID and Password

2009-12-04T11:29:00.000-08:00

On OTN this question asked. Question is how to get current UserID and Password on a Report, to address this here I'm posting this blog so that it will be help full to other people as well. In Reporting we can get userid by using function 'USER()' but there is no flexibility on how to get password To get password we need to do little trick as shown below. Create new session initialization block

How to find current value of each Server Variables?

2009-08-25T11:02:00.000-07:00

If you want to know current assigned values of server variables with in your BI Server then follow these steps.1. Open RPD2. Goto Manage menu tab3. From manage menu select “Sessions …”From O.B.I.E.E4. Pops up Session Manager5. From available sessions choose a session 6. Now click on variables tab, it will show all server and session variables and respective values at that particular time.From

Quickly find out which presenation columns are used in which report

2009-08-08T22:12:00.000-07:00

There is no easy way to find out which presentation columns are used in which reports and dashboards. I have come across a situation where we need to quickly identify presentation columns used in each report. I didn’t have enough time to go thru all reports.To save time, I have created a tool which will output the below information. Report path and name Dashboard page name Presentation column

How to embed My Account link on dashboard page

2009-08-06T14:14:00.001-07:00

One of question asked in BI Forum about how to move "My Accounts" link into "My Dashboard" Here you can see half of solution i.e My Account embedding on to shared dashboard instead of My Dashboard.To do thatStep 1: Go to C:\OracleBI\web\app folderStep 2 Create a new file userPref.txt or what ever name you want.Step 3 Place following code in this file userPref.txt then save the file.< % @LANGUAGE

Leading or Trail Space Trim Issue

2009-08-04T13:35:00.000-07:00

If you have column-values with leading or trail spaces those space will be trimmed by presentation services by default, if you drilldown to detail, will lead to no-results or wrong records. Suppose in your column only these values are there ‘abc’, ‘abc ’ (spaced value),’xyz ’ (spaced value) if you drill on ‘abc’ you will get proper records of 'abc', if we drill on ‘ abc’ will display ‘abc’

nQSError: 61013 Can not save changes to the repository

2009-07-31T14:01:00.000-07:00

If you come across following error don’t be panic. warning: can not save changes to the repository because,[nQSError: 61013] File error: path= C:\OracleBI\server\Repository\paint.rpd , code=31: There has been a sharing violation. May be its because of, you have started working on repository (offline mode) then started BI Server, after server services start, if you try to save repository you

Obiee all Message Reference

2009-07-31T13:32:00.000-07:00

Siebel Analytics Message Reference(click here to download) it’s a powerful tool for developer for debugging any problem occurred in obiee environment. It explains context of each message and suggests possible steps to overcome the problem.

Display Data Base Images on report

2009-07-27T20:31:00.000-07:00

Inspired by one of post in OTN forum on how to populate data base images on a native report, here assumptions are database having image URL, images are residing in image resource folder. To do that first keep all images files in OracleBI\web\app\res\s_oracle10\images i.e fmap:images\xyz.jpgKeep all image file names (with file extn) in database as required.Exp: Suppose geo dimension with South as

Conditional Formatting in Grand Total in Pivot Table View

2009-07-27T00:09:00.000-07:00

Just now saw a post in OTN on Conditional Formatting in Grand Total - Pivot Table View, here is a possible work around for this.Sample ExpRegion price per unitsouth 89 north 86 west 92 east 99 Grand total 91.5 Conditional format is if 90% above is green other wise red this works well on individual cells but not in default grand total option. Possible solution is, create a report with

In Between Calendar Control with Sliding dates

2009-07-25T10:34:00.000-07:00

I would like to share how I use to implement sliding days and dynamic date range with in reports.Problem: Many times we come across requirement to have recent orders or activities etc. Here recent may be 1 day or 1 week or 1 month depends on different users.Solution: To accommodate all above, I will pull report with latest 7 days i.e Between CURRENT_DATE-7 and CURRENT_DATE and also I will give

List of co-obiee blog's

2009-07-17T14:22:00.000-07:00

Here is list of all co-obiee blogs at one place. A! HelpAnalytics Done RightAndreas NobbmannBI BlogsBI Publisher BlogBI This WeekBI-QuotientBlendBuilding a better BIBusiness Intelligence (BI) - ERP - DashboardsCarpediemconsulting's BlogDashboards, Applications & Business Intelligencekpi partnersKumar Kambam's OBIEE BlogNandoo's BlogO.B.I.E.EOBIEEobiee WordPress.com Tag FeedOBIEE - Oracle Business

Short your BI Presentation url.

2009-07-16T13:35:00.000-07:00

You and your end users got bored of typing lengthyyyy url or hard to remember dash board url? (http://localhost/analytics/saw.dll?Dashboard or http://crypticservername-04hr01/analytics ) Do you want to shorten some thing like this http://BI/ then here is solution.Step 1: Choose a short name for bi server or rhythmic words ( HRDash, SalesBI etc) keep it ready, edit host file i.e goto C:\WINDOWS\

Best practices: Auto-Notification on Dashboard Errors.

2009-07-15T15:27:00.000-07:00

Many people (at least myself) are ignorant, once development complete and shipped to production, then developers will be least bothered about how dashboards are working. Even though DEV/QA people thoroughly verified for data and functionality, some times end user can perceive error on dash board, because of QA slippage, resources unavailability or wrong combination of objects(listed

Bypass Obiee Log On Screen

2009-07-14T13:19:00.000-07:00

If you want to bypass log on screen when you first time access obiee page through launch url i.e. http://localhost/analytics then here is solution. Locate analytics virtual folder (C:\OracleBI\web\app\) in this folder replace default.asp page with following. I am assuming you have anonymous user exists and particular user role has assigned some dashboards. ##%@ LANGUAGE="JScript" %## ##%

Information on Request XML

2009-07-14T00:08:00.000-07:00

Today i would like to give some information on Report XML. Every request internally stored as xml. i.e Request XML, you can view request xml in two ways, goto request’s advanced tab, under Request XML segment you can view this xml or Using Catalog Manager – locate report— on report right click – choose properties –click on Edit XML button—pops window with xml.Here is through catalog manager.In

Tip of the Day on Saved Filters

2009-07-10T15:15:00.000-07:00

For each dash board prompt, create corresponding saved filter and use this filter across all reports. Are you thinking why? Suppose you have so many pages on dashboard with common dash board prompt across all pages and each page has one report, each report has drilldown to detail reports. In these situations many people will create filters on each and every report from scratch, even though

Sawping

2009-07-09T15:27:00.000-07:00

Sawping is BI server ping tool comes along BI installation, it has following otions.sawping [-p port] [-s host] [-v (verbose mode)] [-q (quiet mode)] [-h]Here is an example on ping local machine which has BI server services downC:\OracleBI\web\bin>sawping -vUnable to connect to server. The server may be down or may be too busy to accept additional connections.An error occurred during execution

Custom logos/template in Office Add-ins

2009-07-09T13:22:00.000-07:00

Default office excel report will be populated with oracle logos and footage, if you want to have customization as per your company, then here is a solution. All these information is stored in template files, which are located at C:\Program Files\Oracle\BIOfficeExcel\Template\ on disk with file names as OBIReport.xlt, OBIReport.xls modify these files by remove oracle logos, add your logos, header

Purge BI Server Cache from Dash Board

2009-07-08T15:10:00.000-07:00

One of colleague asked me, is it possible delete server cache from dash board? So started working on it, finally got solution how to do that. I have created a script using C# on top of obiee-webservices, built a web page and embedded it on Dashboard, as of now I have incorporated Purge All, Purge by Database and they are working cool.I have refered following resource,Thanks John, for a very good

All Resource files at one place

2009-07-07T16:54:00.000-07:00

Many times I have confused to use fmap :)For suppose I have placed html file in images folder (OracleBI\web\app\res\s_oracle10\images) and tried accessing using ‘fmap: images/help.html’ this was pointing me to wrong url http://localhost/analytics/Missing_images/help.html suppose to be http://localhost/analytics/images/help.html.Then I have realized each and every resource folder has specific

TODATE function's possible error

2009-07-07T10:31:00.000-07:00

I have observed todate function error couple of days back situation is like this. One of our report consist dashboard prompt on Quarter and other columns, default quarter is set to current quarter using repository variable, report does not have any date dimension columns to display, we have one measure in this report as QTD_Amount related column in RPD defined as “ifnull(ToDate(sum(ifnull(

Obiee Web Services – Using .net and C#

2009-07-06T23:40:00.000-07:00

From many days I was thinking to blog on Web Services using .net, today I could able to make it. If you want to see what are all available web services in Bi Server then just browse this url in any browser http:///analytics/saw.dll?WSDL you will be able to see all available services. Here is a very basic code (kind of hello world) in C# which will logon user to BI server and get the report

Funny Error: htmlreportgenerator

2009-07-06T13:09:00.000-07:00

I was writing Direct Database Query while doing this, I have come across following funny error"View Display Error Assertion failure: nFields > 0 at line 1214 of ./project/webreportgenerators/htmlreportgenerator.cpp Error Details Error Codes: OQ78YWIW"I have provided proper connectionpool name, proper query still i could see above error.Funny part is, in criteria I have provided all proper

Handy tools to analyse web page

2009-07-02T13:41:00.000-07:00

If you want to analyze which script files or which css files are being used while accessing Obiee Dash board pages then good to go with FireBug or if you want to analyse request response headers, time analysis among request responses,tcp connections, network latancy etc in detailed then go with HTTP Aanalyzer.

Case Statement (Bins) filter.

2009-07-01T15:18:00.000-07:00

If we have a requirement to have case statement on column and it has some filtering condition on it. Filtering cannot be achievable by make use of presentation case statements or Bins, but using repository it’s possible. Create a new logical column with required case statement in repository pull it on to Presentation, this will works fine with all filters. Just to demonstrate I have made a dash

On detail report - popup(new window) link

2009-06-30T12:02:00.000-07:00

Today I have a requirement to show popup link (new window) on detail page, tricky part is popup link has to appear on detail report but not on main report page.To achieve this,Use Static Text view along compound view of report with following Java Script and also enable Contains HTML Markup check box.[br/]<--script type="text/javascript">function newPopup(url) {popupWindow = window.open( url,'

Case Insensitive search

2009-06-28T00:57:00.000-07:00

Some times performing case insensitive search through connection pool(alter session set NLS_SORT=BINARY_CI, alter session set NLS_COMP=LINGUISTIC) is not a feasible way.Suppose in some report, user wants to have case sensitive search/filter, in this situation above solution is not feasible.In those cases following method will be useful.Make a filter using advanced sql option with reference

Obiee Developer Utility - Direct Log-on to Dashboard

2009-06-26T15:09:00.000-07:00

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 [DEFAULT]BASEURL= http://bi-server-name/analytics/saw.dll?Dashboard[InternetShortcut]URL= http:// bi-server-name/analytics/saw.dll?Dashboard?NQUser=Desire-User-Name&NQPassword=User-Password Hotkey=1612 Then save

Obiee Developer Utility

2009-06-26T12:26:00.000-07:00

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 detailed1) Download bat file from here 2) Place it any folder.3)

Oracle BI Answers Access Prohibited

2009-06-26T10:53:00.000-07:00

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

Step by Step to Bypass All Caches

2009-06-25T15:39:00.000-07:00

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 '

Advance SQL Query Prefix's

2009-06-25T12:24:00.000-07:00

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 DISABLE_CACHE_HIT DISABLE_CACHE_SEED LOGLEVEL QUERY_SRC_CD SAW_DASHBOARD SAW_SRC_PATH Sample usage: SET VARIABLE DISABLE_CACHE_HIT=1; SET VARIABLE LOGLEVEL=7;For multiple commands to set ? SET VARIABLE DISABLE_CACHE_HIT=1, DISABLE_CACHE_SEED=1;If you

Tool to FindOut Cache Creation Time

2009-06-23T11:15:00.000-07:00

Sample cache fileNQS_XYZ_733536_60898_00000071.TBLthese 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 Name733536 is Days elapsed since 12:00:00 midnight, January 1, 0001(millenium start date)40458 is Seconds passed since 00:00:00 Hours00000071 is Incremental

Step by Step to Connect Remote RPD from Local Machine

2009-06-22T14:01:00.000-07:00

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,

Obiee Error: Id 31 not Found

2009-06-12T14:37:00.000-07:00

Error: Id XX not FoundSome times when we try to select some function from "Edit Column Formula" this kind error will pops as "Id not found ".Solution:1)Say ok.2)Cacel Insert Function.3)Save your request(optional)4)Close the browser and re-open the request.Now column will allow you to insert functions.

Error : [nQSError: 46036] Internal Assertion

2009-06-08T15:00:00.000-07:00

Error DetailsError Codes: OPR4ONWY:U9IM8TAC:OI2DL65PState: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 46036] Internal Assertion: Condition listNode.GetGroupBy() == NULL, file .\Src\SQOIGeneratorBuiltIn.cpp, line 1497. (HY000)As per my understanding this error happens due to corrpution in report file on disk.Solution:Try to change

Non Existing Value as Default Value in Controls

2009-06-05T11:05:00.000-07:00

Requirement: How to populate non existing value in obiee controls(Dropdown, Multiselect or Edit Box) and point this Non Existing Value as Default Value of Control?Solution:Step1: Select Required column in Prompts.Step2: In "Default To" Drop Down Select "SQL Result" place query like followingIf column is string typeSELECT Max(ColumnName)||SomeNonExistingLongStringWhichEverOne FROM SubjectAreaIf

Dropdown Reports

2009-06-02T22:29:00.000-07:00

Today afternoon I got an idea of "Drop Down Reports"There might be a better solution:), my thought process working on it.To get start withProblem:Want to display report based on report selection from Drop Down control in OBIEE.Solution:Step0: Have a logical column("Report Name" in my example)with all reports to display.Step1: Create a request with only one Report Name logical column.Step2: Add 2