How to enable the 'export' option in OBIEE 11g/12c.

We can enable the ‘export’ option at each report level, each page level and at entire dashboard level also. 

Please find below the detailed steps on how to enable the export option at these 3  levels.

    1.  Export option Enable @ Dashboard level:

Step1 : Open any dashboard page and then

Step2: Go to   Top right corner Page optionsà Edit Dashbaord

Step3: Go to   Toolsà Click on “Dashboard properties”  to enable the Export option at dashboard level (i.e. applies to all pages, Reports in the dashboard)

             Click on the “Page report links” to enable the Export option at current page level ( i.e.applies to particular page only and all Reports in that page dashboard)

Step4: Click on Dashboard propertiesà Dashboard properties window will popup.  --> Go to Dashboard Report Links (Edit icon)—Click on the symbol again Report Links—Report links   popup should be open up to choose the options.   We can enable the required options and Save  the changes. Verify the dashboard for results.

Here we can also see   copy/print/analyze/etc other options other than Export.

This will enable the 'export' option at each page level  under the dashboard and at all report level also under the dashboard/pages.

Note: Click on SAVE  icon and ensure the changes are saved  before we check the results.

   2.   Export option Enable @ Page level:

 Step1 : Open any dashboard page and then

 Step2: Go to   Top right corner Page optionsà Edit Dashbaord

 Step3: Click on the “Page report links” to enable the Export option at current page level ( i.e. applies to particular page only and all Reports in that page dashboard)

 Step4:  Click on “Page report links” —Report links popup should be open up to choose the options.We can enable the required options and Save the changes.   Verify the dashboard for results.

  Here we can also see   copy/print/analyze/ etc.  Other options other than Export.

This will enable the 'export' option at particular page level only and at each report level under that page.

Note: Click on SAVE  icon and ensure the changes are saved  before we check the results.

    3.   Export option Enable @ Report level:

Step1 : Open any dashboard page and then

Step2: Go to   Top right corner Page optionsà Edit Dashbaord

Step3: Right click on the Properties(XYZ symbol on top right corner of any Section) à  Click on  “Report links” —Report links popup should be open up to choose the options.We can enable  the   required options and Save  the changes. Verify the dashboard for results.

   Here we can also see   copy/print/analyze/  etc..  Other options other than Export.

This will enable the 'export' option at the bottom of a particular report  only .

Note: Click on SAVE  icon and ensure the changes are saved  before we check the results.

OBIEE 10g/11g Hierarchy Drill Down or/and Drill Through or/and Drill Chaining

OBIEE 10g supports level based hierarchy, with OBIEE 11g enhancements it supports level based as well as value based hierarchies with some additional configurations. The natural drill down is supported and can be configured to support drill through also. 

What id drill chaining? Does OBIEE support drill chaining?  Drill Chaining is a ability of analyze to jump from a level of one dimension hierarchy (product level in product hierarchy) to a level in another dimension hierarchy (Region level in Market hierarchy). This blog is an attempt to demonstrate on how to configure drill chaining and how it works in OBIEE 10g.  I don’t see any specific reason why it can be done in OBIEE 11g.

Drill Chaining Scenario

A scenario where user would like to start with a simple report for product and revenue, then jump from product level in product hierarchy to Region Level in Market dimensional hierarchy , and then, drilling down the whole Market hierarchy to jump to Manager level in Employee dimension and finally drill down to customer.

The analysis steps are as follows..

Define a simple query Product and Revenue from Sales Subject area

The result show revenue broken down by product

Click on any product and see jump from Product level in product hierarchy, to “Region Level” in Market dimensional hierarchy…

Then, drilling down the whole Market hierarchy to jump to Manager level in Employee dimension

Then from employee hierarchy, jumping to Customer, then orders details

Repository Configuration 

For Detailed Level in Product hierarchy, choose the tab “Preferred Drill Path”, and set “Total level” for “Market hierarchy” as next drill.

Similarly, for Detailed level in Market Hierarchy, choose tab “Preferred Drill Path”, and set  “Total level” for “Employee hierarchy” as defined as next drill….

These simple configurations in repository can set the drill chaining and achieve the result discussed earlier.

Note : Referred from the following blog http://bidirect.blogspot.com/2013/09/obiee-10g11g-hierarchy-drill-down-orand.html