Tuesday Apr 30, 2013

How To Pass Presentation Variable To the Title View Using Dashboard Prompt?

Presentation variable does not pass correctly in title view when all values are selected in the dashboard prompt.

For eg, when all values are selected,the title is displayed as @{xxxxx}

When you select a value from the dashboard prompt , the title is reflected correctly with the selected value in dashboard prompt.

This issue can be reproduced at will using any version of OBIEE. The test case using OBIEE is demonstrated below:


Section 1: Create the report:

1.1.Create an analysis using sample sales lite rpd with following criteria:

  • Time: Per Name Year
  • Product: Brand
  • Offices: Department
  • Base Facts: Revenue

Add a Filter ->Product: Brand and make it 'Is prompted' (we will be making Brand as the presentation variable)

1.2.Click on Result and Edit the Title

1.3.In the 'subtitle' field , Enter the name of presentation variable, say @{Brand}

1.4.Save the report as 'Presentation var'

Section 2: Create the Dashboard prompt.
2.1 Create a New Dashboard Prompt (New->Dashboard Prompt)
2.2 Add a Column Prompt: Product ->Brand
2.3 Expand the Options and Set a variable to 'Presentation variable' and Enter 'Brand' in the field below.

2.4Save the dashboard prompt as 'PVprompt'

Section 3: Create the Dashboard Page

3.1 Create a new board and name it as :PVDashboard
3.2 Drag and drop the Dashboard Prompt created from Section 2 into the dashboard page
3.3 Drag and drop the report created from Section 1 to the dashboard page
3.4 Save the Dashboard page and run it.
3.5 When there is no value selected in the dashboard prompt, the subtitle is displayed as '@{Brand}'

3.6 When you select a value for Dashboard prompt : say 'BizTech', it is displayed correctly as BizTech as shown below:

To fix this issue, Do the following:

Edit the Title view from Results tab and add a default value for All selection for eg, 'All Brand' in this case: @{Brand}{All Brand}and Save the title.

Save the Dashboard PVDashboard,and Run it .Now the Presentation Variable is displayed correctly when you dont select any value for the Dashboard prompt.

Tuesday Apr 09, 2013

Exalytics:Is Oracle Business Intelligence Enterprise Edition (OBIEE) certified with Exalytics PS2 (, or any other Exalytics release?


Is Oracle Business Intelligence Enterprise Edition (OBIEE) certified with Exalytics PS2 (, or any other Exalytics release?


OBIEE is a full product release and is not currently certified with Exalytics.  It includes many product enhancements and the installation/upgrade procedures are significantly different from the install method for a minor patchset, such as OBIEE

The Oracle Exalytics Development team is actively working on certifying OBIEE  An announcement will be made when the certification process is complete.  Certification details are available in the Exalytics Certification matrix posted here.



Oracle Exalytics/OBIEE Support

OBIEE 11g:Excel Connectivity Using ODBC Drivers

This blog describe the method to connect Excel to BI Server using ODBC. 

For this you dont need to use the Analytics. You can use Excel to create the report by connecting to BI server using ODBC Datasource.

Two steps to achieve this are:

  1. Create a system DSN
  2. Create the report using Microsoft Query.

Step 1: Create  the system DSN

1.Go to Control Panel->Administrative Tools->Data Sources (ODBC)->System DSN

2. Select Oracle BI Server and Click Add

3.Click on Finish and enter a name for your DSN and enter the BIServer name and click finish

Now your BI Server DSN Configuration is done.

Step 2. Create the report using Microsoft Query.

1. Open the Excel and Click on Microsoft Excel->Data->From Data Sources->From Microsoft Query

2. Select the DSN name you created above and enter the credentials to log in to BI Server.

3. A new screen to choose column will appear.

4. Drill down on the dimensions and select the required tables as shown below:

5. If you get a message like below, click on OK

6. Clicking OK will take you to the screen shown below:

7. Click on Add Tables icon from the menu. This will allow you to select the tables that you want in your report.

 For example,

7.1. In this case we are using Sample Sales lite rpd and we will add the fact table Base Facts (click on Add)

7.2. Base fact will be added to Microsoft query. Drag Actual Unit Price from ‘query from …’ section to the Result pane header.

              (Note the difference in screenshot from step 6)

8. Close the window for ‘Microsoft Query’. Now ‘Import Data’ wizard will open.

9. Select the type of table you wanted. (In this example we have used the pivot table report)

        a.Drag Product to Drop Row Field Here
        b.Time to Drop columns Field Here
        c.Actual unit price to Drop Data Items here.
        d.The report will be generated in excel like below:

Exalytics: Steps To Upgrade JDK and JROCKIT

[Read More]

This Blog is for sharing the latest information regarding Exalytics and OBIEE


April 2013 »