RSS

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:

SmartView_Integration_2

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..).

SmartView_Integration_3

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.

SmartView_Integration_4

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)

 SmartView_Integration_5

Thanks,
Shiva

Advertisements
 
3 Comments

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 11.1.2.5.210 installed, Oracle BI add-in 11.1.1.7.0
    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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

 
%d bloggers like this: