The name defaults to "bioffice", but if you specified another name when you deployed the application, then enter that name in this field. This section describes the properties that you can configure in the bioffice. For file location see Section Following is a sample bioffice. The sample file is from Release 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.
The NTLM protocol authenticates the user and silently logs the authenticated user on to the system. This example uses the following components:. Deployment and configuration steps might differ if you choose different components for your system.
These requests are authenticated by the NTLM module. These components therefore cannot be accessed without passing HTTP server authentication. If you choose not to configure a single repository, then the Oracle Business Intelligence user repository must duplicate the Microsoft system user repository to achieve silent sign-on.
For example, Windows user AJones with password abc must be duplicated in the Oracle Business Intelligence user repository. Install a standalone instance of the Web server, deploy the Presentation Services Plug-in to this Web server, and configure as described below.
This component provides extensible scheduling for analyses to be delivered to users at specified times. Oracle BI Publisher has its own scheduler. These components distribute requests to the BI Server, ensuring requests are evenly load-balanced across all BI Server process instances in the BI domain. A JEE container that runs in a dedicated Java virtual machine that contains Java components for administering the system. A JEE container that runs in a dedicated Java virtual machine that provides the run-time environment for the Java-based services and applications within the system.
An Oracle BI domain contains one or more Managed Servers that are distributed across one or more host computers. Node Manager provides process management services for the Administration Server and Managed Server processes. System components are deployed as server processes and provide the core services that enable Oracle Business Intelligence.
The Oracle BI domain also contains all the necessary software, metadata, configuration files, RPD files, Oracle BI Presentation Catalog, connection and database configuration information that are required to run an Oracle Business Intelligence system. Oracle Business Intelligence can be installed and configured on multiple hosts. This component provides an enterprise reporting solution for authoring, managing, and delivering all types of highly formatted documents to employees, customers, and suppliers.
This component provides the integration between Oracle Business Intelligence and Microsoft Office products. These formatting changes are then preserved even during refreshes.
Furthermore, these formatting changes are applied to all cells with the same style. You can define Excel-specific conditional formats for data that was imported from BI views. Conditional formatting that you define using Excel's native conditional formatting features can be preserved during data refreshes. 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 This section describes the properties that you can configure in the bioffice. You can modify the contents of this file as needed. Before making any modifications, ensure that you make a backup copy of the file. After saving modifications to the file, ensure that you restart the BI Office Server.
Table B-1 Properties in the bioffice. Note that as the log level value increases, performance is impacted.
0コメント