The Open Office extension for BI Server is also available on other platforms including the mac. You can add multiple such reports into single spreadsheet and add your own calculations to the mix.Īpart form adding calculations, you can also add conditional formatting and column text formatting on columns using Open Office styles and formatting tools. The resultant pivot can be pivoted freely using drag-drop methods or by using the context menu. Inserting the complete request data as a pivot invokes the DataPilot where you can chose the columns that make up the rows, columns and parameters of the pivot. Double clicking on any object adds it to the spreadsheet. You will notice the Table view and Pivot table objects are now visible from the presentation catalog. The Open Office extension for OO Calc has the ability to import tables and pivot tables apart from the charts. It features exactly the same functionality as with OO Impress. The Open Office extension however works with OO Writer as well. You might recall the BI Plug-in for Ms Office was only applicable to Excel and Powerpoint. You might need to reimport the chart using the Edit Prompts and Levels menu option if your source report has changed in structure. The Refresh option under the Oracle BI menu allows you to keep the Impress Presentation up to date with the latest data from the BI system. The Open Office extension has a modify link that will let you modify the report from a web browser if needed. One can change the chart types and formatting using the standard chart options. Unlike the Excel Add-in this extension does not feature the ability to insert BI chart as images containing the default Answers formatting. Select Presentation Catalog from the Oracle BI menu to look at the reports at your disposal.ĭouble clicking any chart on the list will insert it with the default Open Office formatting. Once this is done, use the Oracle BI menu to Login and presto! The web catalog is available at your disposal. You can setup access to all your Oracle BI instances, by adding them in the extension options. Once the extension is added, a new menu for Oracle BI is now visible across the tools. Click Add and select the Oracle BI extension (Available under oracle-openoffice-3_3_0-enterprise-tools-ent-kit\extensions\oracle-office-bi-server as a part of the Open Office Enterprise Tools download). After walking through the simple Open Office Install, open up any Open Office tool. Installing the BI extension is very simple. OO Writer and OO Impress only support embedding of charts into the documents. OO Calc supports the ability to embed entire reports including tabular views, pivot tables and charts. This extension gives us the ability to embed information from BI EE 10g into Open Office Calc, Writer and Impress documents (equivalents of Excel, Word and Powerpoint). Oracle released a new BI extension for Open Office with the latest Open Office release (v.
0 kommentar(er)
