Oracle® Business Intelligence New Features Guide Release 10.1.3.4.2 Part Number E10416-07 |
|
|
View PDF |
Oracle BI EE Release 10.1.3.4.2 introduces the following new features for Oracle BI for Microsoft Office:
Features for views:
The Re-insert if the view changes on server option has been added to the General tab of the Preferences dialog.
Filter views are displayed as check boxes in the Insert View dialog in Office documents. Filter views are inserted with the request into Office documents and are refreshed from the Oracle BI Server.
Title views are displayed as check boxes in the Insert View dialog in Office documents. Title views are inserted with the request into Office documents and are excluded from subsequent refreshes from the BI Server.
The option to paste a chart as an image is available in Excel and as an image or Flash format object in PowerPoint documents.
The default chart sub-type that you specify in Answers is applied when charts are inserted into Office documents.
The Line-Bar Combo chart is displayed in Office documents in the same way as it is in a request. For example, if you see two bars and two lines on a Line-Bar Combo chart in Answers, then you see the same bars and lines in the chart in Excel.
Features for the Oracle BI Add-in for Excel:
The Always insert Pivot Table fully expanded option in the General tab of the Preferences dialog is selected by default.
In Excel documents, pivot table views support subtotals and table views support subtotals and grand totals.
Features for the Oracle BI Add-in for PowerPoint:
A pivot table view is inserted as a simple crosstab in PowerPoint documents.
The initial display formatting for a pivot table is imported from the BI Server.
After you insert a table or pivot table into a PowerPoint document, you can apply formatting to it. This custom formatting is preserved if you refresh the view from the BI Server.
In PowerPoint documents, pivot table views and table views support subtotals and grand totals.