SmartView – OBIEE 11G integration: Access OBIEE reports from MS Office (Excel)

17 Apr

Connect to OBIEE from Excel spreadsheet with SmartView Add-in

This blog post explains how to connect to OBIEE11G Reports from Excel spreadsheet to analyze more with help of Excel native functionality.

I have a year-order Sales report in OBIEE catalog:


Connect to OBIEE from SmartView and insert this report in Excel spreadsheet. Once you imported the OBI Analysis view, you can use all native Excel features (e.g. Cell formatting, Text formatting, Excel functions like Sum,Avg, Min,Max and any other functions etc..).


If we apply any changes to OBI analysis in presentation services, the formats applied in spreadsheet retain same and just the data will be refreshed with respect to the OBI Analysis updates.

In following example I have applied a filter on year = 2008 in OBIEE presentation services.


Now in Excel, The formats are retained the same, but just data is limited to year 2008, since there is a filter in OBIEE Analysis. (If data is not changed immediately, just click the refresh button available in Excel toolbar ribbon)




Posted by on April 17, 2013 in BI Publisher, OBI EE, OBIEE 11g, Weblogic


Tags: , , , , , , , , , , ,

3 responses to “SmartView – OBIEE 11G integration: Access OBIEE reports from MS Office (Excel)

  1. Hitesh

    November 26, 2014 at 6:24 am

    Thanks for the amazing blog.
    I have one question.
    I have Smart view installed, Oracle BI add-in
    I am not able to create a report in excel using the view designer option.
    In fact I do not see that option until I load some report into the excel sheet.
    Also, I am getting the error : OBIEE:Oracle BI EE service provider failed.
    Can you please help on this


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: