![]() Now to save this report in OBIEE catalog, click on publish View button. The wizard will generate a report like this in Spreadsheet: And I am grouping the result set by year, so moved the Per Name Year in Section part. 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. The SmartView has variety of View types, for demonstration purpose I am using Pivot table. Expand the Subject Areas of your choice and drag the columns of analysis into the areas of report layout. The View Designer button will open the Oracle BI EE presentation services Subject Areas. ![]() To create a new analysis from SmartView, Open Excel and connect to Oracle BIEE.Īnd then click on “View Designer” button. To create an OBIEE report from excel, follow these steps. ![]() 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. Create an analysis in Excel using SmartView and save in OBIEE catalog
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |