When you secure the data, the BI data is removed from the document. In both cases, an Office pane is available for browsing the Oracle BI Presentation Catalog and for selecting views to insert inside Office documents.Ībility to secure BI data in BI views inserted inside Excel spreadsheets or PowerPoint presentations - This feature enables you to secure inserted BI tables and graphs so that users must present credentials to view the Oracle BI data. When installed on Excel or PowerPoint 2003, the Oracle BI Add-in for Microsoft Office-in's functionality is made available through a menu and a toolbar. Office access - When installed on Excel or PowerPoint 2007 or later, the Oracle BI Add-in for Microsoft Office functionality is made available through a native Office ribbon interface. Oracle BI for Microsoft Office provides the following general features: Compound views are pasted into Microsoft Office documents as native Office tables and for graphs as Office native charts, as images, or as Flash objects (for PowerPoint). You can copy compound views from the Analysis editor and dashboard pages. You can customize native Office objects, but you cannot customize images. Title views cannot be refreshed so that user customizations are maintained. Prompt selections are preserved and can be changed subsequently in Microsoft Office documents.Īll views pasted from the Oracle BI Add-in for Microsoft Office are refreshable, even views pasted as images or as Flash objects. When you refresh the Oracle BI EE views inside the Office document, the data is refreshed and displayed based on this state of the request. Use the Copy link, if available for that view, to copy this state and paste it into a Microsoft Office document using the Oracle BI Add-in for Microsoft Office.

The term 'state' includes criteria such as drilling in columns, values for prompt selections, and selections on the page edge.įor example, you can drill on a graph from year to quarter, then drill from region to the district level. You can use the Copy link for an analysis on a dashboard page to copy the analyses definition and current state as applicable of Oracle BI EE views on dashboard pages and paste the view objects into Microsoft Office documents.

You can copy views from the Analysis editor and from dashboard pages and paste them into Microsoft Excel and PowerPoint documents. The following general guidelines apply to copying and pasting all supported views: General Guidelines for Copying Views and Analyses

Microsoft office powerpoint 2003.exe