SmartView_INtegration: OBIEE 11.1.1.7 Access OBIEE reports from MS Office (Excel)

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,

Raghu Nagadasari

Advertisements

About raghunagadasari

Working with a MNC on BI Applications 7.9.6x, OBIA 11.1.1.7.1. Having work exp on EBS, Oracle Apps, ODI, Informatica, OBIEE, Pl/sql,
This entry was posted in OBIEE. Bookmark the permalink.

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 )

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