If you are using a release before Note that as the log level value increases, performance is impacted. Therefore do not set this property to debug 5 unless you are troubleshooting an issue.
For information, see the appropriate topic for your system: Section For versions This property is turned on by default to compress the Answers result set on the BI Office Server before being sent to the add-in. Define the minimum file size that triggers the compression in the property "OfficeCompressResultMinSize". Guidelines for setting this property: If the results are expected to be large, more than 16KB or 32KB , then turn compression on. There is a performance overhead associated with compressing the result set on the server side, and then decompressing it on the client side.
The cost versus benefit can vary for your environment, therefore some trial and error may be required before achieving the optimal setting. If the property "OfficeCompressResult" is turned on, then enter the minimum size file in kilobytes that triggers compression. See the description for "OfficeCompressResult" for guidelines on setting these properties.
This example generates a keystore to reside in a file named mykeystore. In OC4J If you do not have a secure-web-site. You can start by copying content from default-web-site. To use the default of , you must be a super user. Use the keytool utility to import the mykeystore. In the Add-In, create a connection as follows:. However, the following options from the add-in's Insert menu are not supported:.
Depending on the SSO server type, the configuration might differ. On the same computer where the Presentation Services Plug-in has been deployed, deploy another Presentation Services Plug-in using the file analytics.
Make the same modifications to the web. For more information on updating the web. Set the value to "1". This setting suppresses the unsupported options from the client add-in insert menu. For more information on the configuration file, see Section You need this Impersonator user name and password to complete the configuration of the BI Office Server.
For example, you would specify:. For more information on the bioffice. As an alternative to deploying a second Presentation Services Plug-in, you can perform the following configuration steps:. Modify the web. Give a different servlet name and URL pattern to your duplicate entry. Follow the instructions in the Section Starting with Release Silent Sign-on -When accessing the add-in from an authorized computer, a user is not challenged for credentials.
This requires that the Oracle BI Add-in for Microsoft Office perform cell-level comparisons to preserve the formatting while updating the cell values with updated data, which is performance-intensive. You select the Preserve Conditional Formatting option in the General tab of the Preferences dialog to preserve formatting at the cost of performance.
If performance is more important then preserving conditional formatting, then deselect this option to remove the formats when the view is next refreshed. Formatting by customizing templates — You can customize the default appearance of Oracle BI EE table and pivot table views that are inserted in Excel worksheets using an Excel template that is installed during the client Oracle BI Add-in for Microsoft Office installation.
The template resides in the following location:. Crosstab — Pivot tables inserted in PowerPoint documents are displayed with a true crosstab look and feel. Customization — During data refreshes, tables and pivot tables retain most of the customizations that you make to the views inserted in PowerPoint documents.
Examples of customization include font properties such as font size, color, and bold or italic styles. If you try to paste into Oracle BI Add-in for Microsoft Office an analysis or view that uses any of these features, then you see a warning message that the paste cannot occur. It includes the following topics:. The configuration file for the BI Office Server is named bioffice. The following list describes the steps that are required to install and configure Oracle BI Add-in for Microsoft Office:.
If you have an existing version of the Oracle BI Add-in for Microsoft Office, then remove that version before you run the installation program to obtain the new version.
Microsoft recommends uninstalling all add-ins before upgrading to a new version of an Office product. With Office still installed, do one of the following:. Run the client OracleBIOffice. If the following prerequisite software does not exist on your computer, then you are prompted to install it. You might be prompted to restart the computer after installing the software.
You can find this software on the Microsoft web site:. Ensure that you are familiar with the "Important Notes" that are documented earlier in this section. In the Download dialog, specify a location to which you want to download the executable file with which you install Oracle BI Add-in for Microsoft Office.
When the file is downloaded, display Windows Explorer and double-click the file that you downloaded to run it. During the installation, you might be prompted to install prerequisite software. After installing the prerequisite software, you might be prompted to restart the computer. After restarting, navigate back to the location of the downloaded file and double-click it to reinitiate the install. After all components are installed, the Install Shield Wizard Complete dialog is displayed. Click Finish.
When the software is downloaded and installed, each user must enter the connection information in the Preferences dialog for Oracle BI Add-in for Microsoft Office on the client computer to enable communication with the BI Office Server. The connection information is shared, therefore you can enter it through either application and it is available to both. The name defaults to "bioffice", but if another name was specified during deployment, then enter that name in this field.
The default is A blank chart or a chart with default data is displayed. The issue also appears when attempting to paste Chart Views inside Excel and PowerPoint using the Paste button from the add-in. Insertion of Chart views as image or Flash objects is not affected by this issue. Users of the Oracle BI Add-in for Microsoft PowerPoint can now insert table views and flat data views that are larger than 25 rows and 25 columns in PowerPoint and larger than 75 rows and 75 columns in PowerPoint This is not generally recommended because larger tables are not suited for displaying data in PowerPoint.
Also, PowerPoint's performance can decrease considerably when a user inserts or refreshes large views. If "Display time to be shown in the title" is selected for a table or pivot table view, then the time shown in the title after the table or pivot is inserted into Microsoft Office might be incorrect. When running the Oracle BI Add-in for Microsoft Office in languages that have a right-to-left orientation, the following behaviors might be encountered:.
The following behavior might be encountered when using Oracle BI Add-in for Microsoft Office in languages that have a right-to-left orientation:. After launching Microsoft Excel, connecting to the Oracle BI Server, and inserting a table view, date data is incorrectly inserted. This behavior occurs with Excel and and for the Arabic, Thai, and Hebrew languages. When running the Oracle BI Add-in for Microsoft Office in languages that have a right-to-left orientation, some dialog boxes in the add-in still appear left-to-right.
In German or Arabic Versions of Microsoft Excel or , number formatting might be lost after table views that have been secured are refreshed. To work around this issue, you can insert the Chart View as an image by using the Insert As Image option from the add-in's Catalog browser.
Legends in bubble and scatter charts displayed in Microsoft Office do not include coordinate values on the horizontal axis. This means that the number of legends and the colors displayed for each data series may not match those displayed in Oracle BI EE. This issue has no workaround. For example,. However, on some non-English languages, users might see escape characters in the string after securing their BI views. Note that this does not result in any loss of functionality and the view has still been secured and can be refreshed using the add-in.
When you use the Oracle BI Add-in for Microsoft Office in languages other than English, you might encounter various issues with number and date formatting. When displaying data from Oracle BI EE in PowerPoint, you might notice that number formatting and date formatting are not applied correctly. When displaying data from Oracle BI EE in Excel, if you notice that the data formatting is not correct, then you can modify cell formatting or cell style formatting using Excel functionality to apply the correct data formatting related to numbers, dates, and so on.
Subsequent refreshes of the views retain the formatting that you apply. This issue has no workaround but is fixed in Release Help files in other supported languages are expected to be provided in a patch release. The following corrections are needed to the add-in's Help for Versions The corrections were made in the Help for Version Note: During an upgrade installation this file is used to retain the existing configuration settings.
The basic BIEE install option deploys the bioffice. Locate the bioffice. In the Note: For more information on modifying instanceconfig. If you are installing this version, you will be prompted to install Microsoft. Modify : Prompts you to select the specific Add-in you wish to install. Repair : Uses a cached copy of the original install. From the Oracle BI menu, select Preferences. On the Connections tab, select New.
Following is a sample bioffice. This property is set initially by the BIEE installer. Setting this option to "1" suppresses these options from the office add-in menu. Increase this setting in a multiple-user environment. When set to 0, the BI Office server inserts the hyperlink text as is. If your data does not include any hyperlink text, set this property to 0 for better performance.
If the user then formats the data as a percentage in Excel, the data will display correctly. If the property is set to 0, no percentage processing is done by the BI Office server.
Set this property to 1 to resubmit the query to refresh data. When set to 0, the data is read from the cache.
0コメント