Wednesday 15 May 2013

martView – OBIEE 11G Integration: Create Reports from Excel and save in OBIEE catalog


Create an analysis in Excel using SmartView and save in OBIEE catalog
Using SmartView add-in, we can create OBIEE reports from Excel/Word and save in OBIEE catalog.And we can see those reports within OBI Presentation services and can use it for further analysis.
To create an OBIEE report from excel, follow these steps.
To create a new analysis from SmartView,  Open Excel and connect to Oracle BIEE.
Navigate to Oracle BI EE tab.
And then click on “View Designer” button.
SmartView_Integration_6
The View Designer button will open the Oracle BI EE presentation services Subject Areas. Expand the Subject Areas of your choice and drag the columns of analysis into the areas of report layout.
The SmartView has variety of View types, for demonstration purpose I am using Pivot table.
The Available Report View types are:
SmartView_Integration_7
In my example I am creating a pivot table, so dragged the Order type in Rows, Order Status in Columns, and Revenue in Measure block. And I am grouping the result set by year, so moved the Per Name Year in Section part.
SmartView_Integration_8
The wizard will generate a report like this in Spreadsheet:
SmartView_Integration_9
Now to save this report in OBIEE catalog, click on publish View button.
SmartView_Integration_10
It will open the OBIEE catalog folders. You can save the report into a folder of your choice that created in OBIEE catalog.
SmartView_Integration_11
Select the Folder in OBIEE catalog and give a name to report and click save.
SmartView_Integration_12
SmartView_Integration_13
Now the report is saved in OBIEE catalog like the analysis we normally save in OBIEE Catalog:
SmartView_Integration_14
See how the report is rendered in OBIEE Presentation services.
SmartView_Integration_15
There are many scenarios where we could use this powerful SmartView Add-in for a great flexible usage of OBIEE reports.

No comments:

Post a Comment