Skip Headers
Oracle® Business Intelligence Suite Enterprise Edition Release Notes
Release 10.1.3.4.2

Part Number E10404-34
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Feedback page
Contact Us

Go to previous page
Previous
View PDF

4 Oracle BI Add-In for Microsoft Office Release Notes

This chapter provides release notes for Oracle Business Intelligence Add-In for Microsoft Office.

4.1 Oracle Business Intelligence Add-in for Microsoft Office

This section provides release notes for the Oracle BI Add-in for Microsoft Office. It contains the following topics:

4.1.1 Installation Issues

This section contains the following topics for installation:

4.1.1.1 Installing the Add-In on Microsoft Windows Vista

This issue applies to Versions 10.1.3.3, 10.1.3.3.1, 10.1.3.3.2, 10.1.3.3.3, 10.1.3.4, 10.1.3.4.1, and 10.1.3.4.2.

When installing the add-in on Vista, only the "Install for everyone" install option is supported. If you install the add-in using the "Only for me" install option, then the add-in might not display in Excel or PowerPoint.

4.1.1.2 Previous Installation of the Add-In Must Be Manually Uninstalled

This issue applies to Versions 10.1.3.3, 10.1.3.3.1, 10.1.3.3.2, 10.1.3.3.3, 10.1.3.4, 10.1.3.4.1, and 10.1.3.4.2.

The Oracle BI Add-in for Microsoft Office installer does not uninstall previous versions of the add-in. Therefore, you must manually uninstall any previous Oracle BI Add-in for Microsoft Office installations before installing a newer version of the add-in.

4.1.1.3 Installation Fails If Windows Script 5.6 Is Not Installed on the Client Computer

This issue applies to Versions 10.1.3.3, 10.1.3.3.1, 10.1.3.3.2, 10.1.3.3.3, 10.1.3.4, 10.1.3.4.1, and 10.1.3.4.2.

The Oracle BI Add-in for Microsoft Office client installation requires that Windows Script version 5.6 or later be installed and enabled on the client computer. If Windows Script is not installed, then the installer fails and you might see an error message similar to the following message:

"Error 1720: There is a problem with this Windows Installer package. A script required for this install to complete could not be run. Contact your support personnel or package vendor. Custom action [2] script error [3], [4]: [5] Line [6], Column [7],[8]".

You can download Windows Script version 5.6 from the Microsoft Web site.

4.1.1.4 .Net 2.0 Framework No Longer Ships with the Add-In

This issue applies to Versions 10.1.3.3.1, 10.1.3.3.2, 10.1.3.3.3, 10.1.3.4, 10.1.3.4.1, and 10.1.3.4.2.

The Oracle BI Add-in for Microsoft Office no longer ships with the Microsoft .Net 2.0 Framework installable. The add-in requires the .Net 2.0 Framework to be installed on a user's computer. If you do not have this installed, then the add-in installer prompts you to download .Net 2.0 Framework and install it on your computer.

4.1.1.5 Install a Language Pack for Non-English Languages

This issue applies to Versions 10.1.3.3, 10.1.3.3.1, 10.1.3.3.2, 10.1.3.3.3, 10.1.3.4, 10.1.3.4, 10.1.3.4.1, and 10.1.3.4.2.

To use the Oracle BI Add-in for Microsoft Office for a non-English language, you must install the appropriate language pack for Microsoft Office and set the regional language settings using the Control Panel.

Go to the following URL to download and install the appropriate language pack:

http://office.microsoft.com/en-us/downloads/office-language-interface-pack-lip-downloads-HA001113350.aspx

4.1.2 Office Client Unable to Start If OC4J Started with Proxy Parameters

This issue applies to Versions 10.1.3.3, 10.1.3.3.1, 10.1.3.3.2, 10.1.3.3.3, 10.1.3.4, 10.1.3.4, 10.1.3.4.1, and 10.1.3.4.2.

If you deploy the BI Office server on an OC4J instance that has been started using proxy server parameters, then any client using a connection that points to this server cannot connect. You should deploy the BI Office server to an OC4J instance that has not been started with proxy server parameters.

4.1.3 Issue Logging into BI Office with NTLM Enabled in an SSO Environment

This issue applies to Versions 10.1.3.4 and 10.1.3.4.1.

If Oracle BI EE is configured to authenticate against the same Active Directory server that a user's Windows client operating system authenticates against, then users using the Oracle BI Add-in for Microsoft Excel or Microsoft PowerPoint cannot log in to Oracle BI EE.

4.1.4 Oracle BI Option Disappears from the Excel Menu

This issue applies to Versions 10.1.3.3, 10.1.3.3.1, 10.1.3.3.2, 10.1.3.3.3, 10.1.3.4, 10.1.3.4.1, and 10.1.3.4.2.

If the Oracle BI menu disappears from the Excel 2003 or Excel 2007 menu bar, then try the following steps to restore it:

  • For Excel 2003: Select Help, About Microsoft Excel, then Disabled Items.

  • For Excel 2007: Select Excel Options, then Add-ins.

    If the Oracle BI Add-in for Microsoft Office is listed as a disabled item, then you can enable it in the Disabled Items dialog by selecting the item and clicking Enable.

4.1.5 Changing a Region to a Range in Microsoft Excel

This issue applies to Versions 10.1.3.3, 10.1.3.3.1, 10.1.3.3.2, 10.1.3.3.3, 10.1.3.4, 10.1.3.4.1, and 10.1.3.4.2.

Flat Data Views are inserted into Excel worksheets as Excel regions. If you change one of these regions to a range by selecting the region, right-clicking, and selecting the List\Convert to range, then you might get unexpected results when refreshing the worksheet. Avoid changing a region to a range.

4.1.6 Cancel Option Does Not Work with Test Connection

This issue applies to Versions 10.1.3.3, 10.1.3.3.1, 10.1.3.3.2, 10.1.3.3.3, 10.1.3.4, 10.1.3.4.1, and 10.1.3.4.2.

In the Connections window of the Oracle BI Add-in for Microsoft Office, if you click Cancel after clicking the Test Connection button, then the processing continues and a success or error message is displayed. The Cancel operation does not take effect.

4.1.7 Empty Chart Inserted When No Data Is Returned

This issue applies to Versions 10.1.3.3, 10.1.3.3.1, 10.1.3.3.2, 10.1.3.3.3, 10.1.3.4, 10.1.3.4.1, and 10.1.3.4.2.

If you insert a Chart view inside Excel or PowerPoint that does not return any rows of data, then a blank chart is inserted.

4.1.8 Using the Customize Option to Remove the Oracle BI Toolbar

This issue applies to Versions 10.1.3.3, 10.1.3.3.1, 10.1.3.3.2, 10.1.3.3.3, 10.1.3.4, 10.1.3.4.1, and 10.1.3.4.2.

If you delete the Oracle BI toolbar from the Excel or PowerPoint application using the Customize option, then you might need to re-install the Oracle BI Add-in for Microsoft Office to view the Oracle BI Presentation Catalog again. Oracle recommends that you do not use the Customize option to delete the Oracle BI toolbar. Instead, you can choose to hide it by using the Customize option and then unchecking the Oracle BI toolbar entry.

4.1.9 New Connections Not Saved When Editing Concurrently in Excel and PowerPoint

This issue applies to Versions 10.1.3.3, 10.1.3.3.1, 10.1.3.3.2, 10.1.3.3.3, 10.1.3.4, 10.1.3.4.1, and 10.1.3.4.2.

When adding or editing BI connections using both Excel and PowerPoint concurrently, the list of connections saved depends on which application you close last. If you make changes to your connections in Excel (that is, from the Excel menu select Oracle BI, click Preferences, and select the Connections tab), then go to PowerPoint and make more changes to your connections, exit PowerPoint, and then exit Excel, then the list of connections saved includes the ones that existed in Excel.

4.1.10 Default Title Views or Default Data Formatting Not Imported into Excel and PowerPoint

This issue applies to Versions 10.1.3.3, 10.1.3.3.1, 10.1.3.3.2, 10.1.3.3.3, 10.1.3.4, 10.1.3.4.1, and 10.1.3.4.2.

Default title views or data formatting might not be imported successfully into Excel or PowerPoint.

In case of data formatting, this happens especially when the default data formatting is saved using Save as the system-wide default for <column> or Save as the system-wide default for this datatype in the Column Properties dialog in Oracle BI EE.

The workaround for both title views and data formatting is to clear the default box and specify the required data formatting or contents for the title views explicitly

4.1.11 Data Mismatch Might Occur Between Oracle BI EE and the Same View Imported into Excel or PowerPoint

This issue applies to Versions 10.1.3.3, 10.1.3.3.1, 10.1.3.3.2, 10.1.3.3.3, 10.1.3.4, 10.1.3.4.1, and 10.1.3.4.2.

Data mismatch might occur between results displayed in Oracle BI EE and the same view imported into Excel or PowerPoint. The mismatch might fall into one or more of the following categories:

  • The views imported into Excel or PowerPoint use a different sort order compared to the ones displayed in Oracle BI EE.

  • When filters and prompts are applied, subtotals and grand totals are calculated using report-based totals.

  • When filters and prompts are applied on measures, and one or more columns are unselected while inserting the view in Excel or PowerPoint, the view displayed might not match the one that is displayed in Oracle BI EE. This mismatch happens due to the change in the granularity of the analysis because of omitting columns, forcing aggregation of measures and applying the filter and prompts next, thus resulting in a different view of the same data.

The workaround is as follows:

  • In the case of a graph view, insert the view as an image or a Flash object. Flash is supported only in Oracle BI Add-in for Microsoft PowerPoint.

  • Ensure that there are no excluded columns in the view definition as compared to the criteria definition.

4.1.12 Inserting a View With a Grand Total Column or Row into Microsoft Office Might Cause Issues

This issue applies to Versions 10.1.3.3.1, 10.1.3.3.2, 10.1.3.3.3, 10.1.3.4, 10.1.3.4.1, and 10.1.3.4.2.

Views that use the "before" location to show row-level grand totals overwrite values in the first column of the analysis when they are inserted into Microsoft Excel. Views that use the "before" location to show column-level grand totals return errors when they are inserted into Microsoft PowerPoint. The workaround is to use the "after" location instead.

4.1.13 Dimension Level Numeric Data Treated as Measures

This issue applies to Version 10.1.3.3. It is fixed in Version 10.1.3.3.1.

When inserting table views, there is a known issue where all numeric columns are treated as measures. Therefore, if there is a dimension level that contains numeric values (for example, Day of Week), the columns are moved to the measures section.

4.1.14 Measure Column Labels Might Display Incorrectly when Inserted into Microsoft Excel

This issue applies to Versions 10.1.3.3.1, 10.1.3.3.2, 10.1.3.3.3, 10.1.3.4, 10.1.3.4.1, and 10.1.3.4.2.

Measure column labels in the section edge or the page edge (also called table prompt in table views and the pivot prompt in pivot table views) of table and pivot table views might display incorrectly when inserted into Microsoft Excel.

The workaround is to not use measure columns in the section edge or page edge.

4.1.15 Data Using Nondefault Aggregation Incorrect in Excel

This issue applies to Versions 10.1.3.3, 10.1.3.3.1, 10.1.3.3.2, 10.1.3.3.3, 10.1.3.4, 10.1.3.4.1, and 10.1.3.4.2.

If a view is inserted using the Oracle BI Add-in for Microsoft Office where nondefault aggregation is used for the numeric data, then the data is aggregated using the default aggregation method (usually Sum).

4.1.16 Refresh After Clicking Secure Oracle BI Data Changes Page Filter Value

This issue applies to Versions 10.1.3.3, 10.1.3.3.1, 10.1.3.3.2, 10.1.3.3.3, 10.1.3.4, 10.1.3.4.1, and 10.1.3.4.2.

If a user changes the default page item value for a pivot table view that is inserted inside an Excel worksheet and secures the data by clicking the Secure Oracle BI Data button, upon refreshing the worksheet, the page item value reverts to the default page item value.

4.1.17 Presentation Catalog Collapses Folder List Under Full Screen Mode in Excel

This issue applies to Versions 10.1.3.3, 10.1.3.3.1, 10.1.3.3.2, 10.1.3.3.3, 10.1.3.4, 10.1.3.4.1, and 10.1.3.4.2.

If you have the Oracle BI Presentation Catalog open in Excel and you select View, then Full Screen Mode, and then close the Full Screen mode, then the catalog collapses to the root level.

4.1.18 Flash ActiveX Control Required for Inserting Images as Flash in PowerPoint

This issue applies to Versions 10.1.3.3, 10.1.3.3.1, 10.1.3.3.2, 10.1.3.3.3, 10.1.3.4, 10.1.3.4.1, and 10.1.3.4.2.

Using Flash in PowerPoint requires the Flash ActiveX control to be installed on the computer that views the PowerPoint content. If you do not have the Flash ActiveX Control installed and registered with PowerPoint, then you cannot insert BI Chart views as Flash objects into PowerPoint slides using the Oracle BI Add-in for Microsoft Office. The operation fails with an error message such as "Failed to insert Oracle BI view." To resolve this problem, download and install the Shockwave Flash control from the Adobe Web site. For more help, contact your administrator or visit the Adobe Web site and view TechNote id tn_14235.

4.1.19 Using Oracle BI Publisher Analyzer for Excel if Oracle BI Add-In for Microsoft Office is also Installed

This issue applies to Versions 10.1.3.3, 10.1.3.3.1, 10.1.3.3.2, 10.1.3.3.3, 10.1.3.4, 10.1.3.4.1, and 10.1.3.4.2.

Under certain conditions, if you have the Oracle BI Add-in for Microsoft Office installed and you install Oracle BI Publisher Analyzer for Excel, then the installation might fail with the message "Installation did not complete successfully. You will not be able to modify report parameters or refresh report date." If this happens, uninstall the Analyzer for Excel and the Oracle BI Add-in for Microsoft Office from the Windows Control Panel's Add-Remove Programs utility. Then re-install the Analyzer for Excel, followed by the Oracle BI Add-in for Microsoft Office.

4.1.20 Inappropriate Error Message When Accessing an Unsupported Report

This issue applies to Versions 10.1.3.3, 10.1.3.3.1, 10.1.3.3.2, 10.1.3.3.3, 10.1.3.4, 10.1.3.4.1, and 10.1.3.4.2.

You cannot view the properties or insert a view based on a request that combines criteria from multiple subject areas using SET operations. The request appears in the Oracle BI Presentation Catalog task pane in Microsoft Office, but you cannot expand that request to list the views for the request. For more information on how to create such requests, see Oracle Business Intelligence Answers, Delivers, and Interactive Dashboards User Guide.

4.1.21 Limitation on the Number of Rows in Excel 2007

This issue applies to Versions 10.1.3.3, 10.1.3.3.1, 10.1.3.3.2, and 10.1.3.3.3. It is fixed in version 10.1.3.4.

In Excel 2007, users cannot insert views that have more than 65536 rows. This is because the Oracle BI Add-in for Microsoft Office uses an Excel 2003 based template, which has a limit of 65536 rows per sheet.

4.1.22 Lack of Privileges Causes Inappropriate Error Message When Accessing a Folder

This issue applies to Versions 10.1.3.3, 10.1.3.3.1, 10.1.3.3.2, 10.1.3.3.3, 10.1.3.4, 10.1.3.4.1, and 10.1.3.4.2.

From the Oracle BI Presentation Catalog in Excel or PowerPoint, users might see a request listed that they do not have access to. Clicking that request results in an "Insufficient privileges" error message being displayed in the request properties section of the catalog. When trying to access a folder that the user does not have access to, the following message might be displayed:

Failed to get child items. The folder maybe empty.

4.1.23 Chart Inserted in PowerPoint 2003 Cannot Be Refreshed in PowerPoint 2007

This issue applies to Versions 10.1.3.3, 10.1.3.3.1, 10.1.3.3.2, 10.1.3.3.3, 10.1.3.4, 10.1.3.4.1, and 10.1.3.4.2.

If you insert a BI Chart View in PowerPoint 2003, then you might be unable to refresh it in PowerPoint 2007, and vice-versa. This issue is caused by differences in the way that Oracle BI metadata for charts is saved by PowerPoint 2003 and 2007. The issue is resolved if you install PowerPoint 2007 SP1.

4.1.24 Charts Might Be Displayed Differently After Insertion into Microsoft Office

This issue applies to Versions 10.1.3.3.1, 10.1.3.3.2, 10.1.3.3.3, 10.1.3.4, 10.1.3.4.1, and 10.1.3.4.2.

Charts that are inserted into Microsoft Office might be plotted differently in Microsoft Office than they are in Oracle BI EE. In horizontal bar charts, the horizontal-axis series might be displayed in reverse order. In stacked charts, the stack order might be reversed. This is caused by the Microsoft charting engine.

4.1.25 Scatter Charts with Lines Display as Default Scatter Charts in Excel and PowerPoint

This issue applies to Versions 10.1.3.3.1, 10.1.3.3.2, 10.1.3.3.3, 10.1.3.4, 10.1.3.4.1, and 10.1.3.4.2.

When you select the scatter chart with lines chart style to insert into Microsoft Excel or PowerPoint, the default scatter chart (without lines) is displayed instead. This happens because Microsoft Office does not support scatter charts with lines.

4.1.26 Stacked Charts Do Not Display Negative Values

This issue applies to Versions 10.1.3.3.1, 10.1.3.3.2, 10.1.3.3.3, 10.1.3.4, 10.1.3.4.1, and 10.1.3.4.2.

Stacked charts do not display negative values when they are inserted into Microsoft Excel or PowerPoint. This absence occurs because the default Microsoft charting engine, which governs these charts, does not display negative values.

4.1.27 Oracle BI Add-in for Microsoft Office Does Not Fully Support Localization

This issue applies to Versions 10.1.3.3, 10.1.3.3.1, 10.1.3.3.2, 10.1.3.3.3, 10.1.3.4, 10.1.3.4.1, and 10.1.3.4.2.

Oracle BI Add-in for Microsoft Office does not fully support localization. Therefore you might not be able to insert BI views into Excel or PowerPoint in languages other than English.

4.1.28 Chart Insertion Does Not Work If C:\Temp Folder Is Not Write-Enabled

This issue applies to Version 10.1.3.3. It is fixed in Version 10.1.3.3.1.

If a user does not have write-permissions on the C:\TEMP folder on his computer, then the Oracle BI Add-in for Microsoft Office cannot insert a Chart View as a native Office chart. 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.

4.1.29 Users Can Insert Tables in PowerPoint Larger Than 15x25 Rows/Columns

This issue applies to Versions 10.1.3.3.1, 10.1.3.3.2, 10.1.3.3.3, 10.1.3.4, 10.1.3.4.1, and 10.1.3.4.2.

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 2003 and larger than 75 rows and 75 columns in PowerPoint 2007.

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.

4.1.30 Time Displayed in Table or Pivot View Title Might Be Incorrect After Insertion

This issue applies to Versions 10.1.3.3.1, 10.1.3.3.2, 10.1.3.3.3, 10.1.3.4, and 10.1.3.4.1.

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.

4.1.31 Text Orientation Does Not Change in Right-to-Left Languages

This issue applies to Versions 10.1.3.3.1, 10.1.3.3.2, 10.1.3.3.3, 10.1.3.4, 10.1.3.4.1, and 10.1.3.4.2.

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:

  • Many dialog boxes in Excel and PowerPoint retain a left-to-right orientation.

  • When you insert a flat/table view in Excel, the direction of the worksheet changes to left-to-right from right-to-left.

4.1.32 Date and Number Values Incorrectly Display When the Add-In in Languages that Have a Right-to-Left Orientation

This issue applies to Versions 10.1.3.3.1, 10.1.3.3.2, 10.1.3.3.3, 10.1.3.4, 10.1.3.4.1, and 10.1.3.4.2.

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 2003 and 2007 and for the Arabic, Thai, and Hebrew languages.

4.1.33 Dialog Box Text Appears Incorrectly for Right-to-Left Languages

This issue applies to Versions 10.1.3.3.1, 10.1.3.3.2, 10.1.3.3.3, 10.1.3.4, 10.1.3.4.1, and 10.1.3.4.2.

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.

4.1.34 Presentation Catalog List Is Not Displayed When Oracle BI Server Locale Is Arabic

This issue applies to Versions 10.1.3.3.1, 10.1.3.3.2, 10.1.3.3.3, 10.1.3.4, 10.1.3.4.1, and 10.1.3.4.2.

When using Oracle BI Add-in for Microsoft Office with the Oracle BI Server set to Arabic, the Oracle BI Presentation Catalog list does not display in the task pane when Excel or PowerPoint is launched.

4.1.35 Refreshing Table Views in Arabic or German Versions of Excel Result in Incorrect Data Values

This issue applies to Versions 10.1.3.3.1, 10.1.3.3.2, 10.1.3.3.3, 10.1.3.4, and 10.1.3.4.1.

In German or Arabic Versions of Microsoft Excel 2007 or 2010, number formatting might be lost after table views that have been secured are refreshed.

4.1.36 Line-Bar Chart Is Inserted Incorrectly

This issue applies to Versions 10.1.3.3.1, 10.1.3.3.2, 10.1.3.3.3, 10.1.3.4, 10.1.3.4.1, and 10.1.3.4.2.

When using the Oracle BI Add-in for Microsoft Office with non-English languages, some line-bar Chart Views created in Answers might not get inserted correctly in Excel or PowerPoint. This is because not all Oracle BI EE chart types have matching chart types in Excel (for example, the line-bar chart). 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.

4.1.37 Legends in Bubble and Scatter Charts May Display Differently After Insertion into Microsoft Office

This issue applies to Versions 10.1.3.3, 10.1.3.3.1, 10.1.3.3.2, 10.1.3.3.3, 10.1.3.4, 10.1.3.4.1, and 10.1.3.4.2.

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.

4.1.38 Untranslated Pages, Screens, and Menus for the Add-In

This issue applies to Versions 10.1.3.3.1, 10.1.3.3.2, 10.1.3.3.3, 10.1.3.4, 10.1.3.4.1, and 10.1.3.4.2.

Some pages, screens, menus, and text are not translated for the Oracle BI Add-in for Microsoft Office. For example,

  • "My Folder" is not translated.

  • "Access" and "Desc" are not translated.

  • "All" in insert dialog is not translated.

  • "Taskpane" is not translated.

4.1.39 Security String Is Incorrect in Excel Sheets

This issue applies to Versions 10.1.3.3.1, 10.1.3.3.2, 10.1.3.3.3, 10.1.3.4, 10.1.3.4.1, and 10.1.3.4.2.

The Secure Oracle BI Data feature enables you to secure inserted BI tables and charts so that users must present credentials to view the Oracle BI data. For tabular views including flat data views, table views, and pivot views, all dimensional data is replaced with a string "<secured>" while numeric data is replaced with a zero. 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.

4.1.40 Pasted Static Text View Can Appear with View Name "HTML View"

This issue applies to Versions 10.1.3.3.1, 10.1.3.3.2, 10.1.3.3.3, 10.1.3.4, 10.1.3.4.1, and 10.1.3.4.2.

When using the Oracle BI Add-in for Microsoft Office to paste a static text view from Answers or Dashboards into Excel or PowerPoint, the message text might state that the pasted view's name is "HTML View." In this situation, "HTML View" and "Static Text" are synonymous.

4.1.41 Number and Date Formatting Issues in Non-English Versions of the Add-In

This issue applies to Version 10.1.3.4.2.

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. This issue has no workaround.

  • 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.

These issues are fixed in Release 11.1.1.5.0 and later.

4.1.42 Cannot See Oracle BI Icon Images in Non-English Versions of PowerPoint 2010 Ribbon

This issue applies to Version 10.1.3.4.2.

When you use the Oracle BI Add-in in PowerPoint 2010 for languages other than English, you cannot see icon images for Oracle BI in the add-in's ribbon. This issue has no workaround but is fixed in Release 11.1.1.5.0 and later.

4.1.43 Corrections for Add-In Help

Online help files for the Oracle BI Add-in for Microsoft Office are available only in the English language. 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 10.1.3.4 and 10.1.3.4.1. The corrections were made in the Help for Version 10.1.3.4.2.

  • The topic entitled "Editing Prompts and Levels" in the online Help for the add-in incorrectly states that editing of prompts and levels is not supported for views that are copied and pasted. Editing of prompts is supported even for views that have been pasted into Excel and PowerPoint document using the add-in.

  • The topics entitled "Refreshing the Presentation Catalog" and "Selecting Prompts from the Insert View Dialog" in the online Help for the add-in contain images of icons. Some of the icons that you see in the add-in might differ in appearance from those that are shown in the Help topics.

  • The topic entitled "Inserting a Funnel or Gauge View" in the online Help for the add-in states that when you insert a BI funnel or gauge view, you can resize the image in Excel. The topic should state that when you insert a chart, gauge, or funnel view as an image, you can resize that image in both Excel and PowerPoint.

  • The topic entitled "Setting Up Connections to Oracle BI Presentation Services" in the online Help for the add-in refers to the Oracle Business Intelligence Enterprise Edition New Features Guide for Release 10.1.3.3. The topic should instead refer to the Oracle Business Intelligence Enterprise Edition New Features Guide for Release 10.1.3.4.

4.1.44 Integration with Smart Space, Fusion Edition (11.1.1) Requires Update to JVM Parameter

This issue applies to Versions 10.1.3.4, 10.1.3.4.1, and 10.1.3.4.2.

Note:

This issue has been fixed in Smart Space, Fusion Edition 11.1.1.1.

To enable BI Publisher to work with Oracle Smart Space, Fusion Edition, you must force the BI Publisher Web service to appear as RPC-encoded. The solution for this issue is to set the JVM parameter described below.

Important:

Setting this parameter causes the Oracle BI Add-in for Microsoft Office to fail. You therefore cannot integrate BI Publisher with Smart Space if you also want to use the add-in.

To enable BI Publisher to integrate with Smart Space, modify the Java command that starts the J2EE application server that runs BI Publisher to include the following parameter:

-Daxis.ServerConfigFile=server-rpc-config.wsdd

For example, if you are using the default oc4j.cmd, then change this line:

set JVMARGS=-Djava.library.path=C:\oracle\bise1\bi\server\Bin;C:\oracle\bise1\bi\web\bin -DSAROOTDIR=C:\oracle\bise1\bi -DSADATADIR=C:\oracle\bise1\bidata -XX:MaxPermSize=128m -Xmx512m %OC4J_JVM_ARGS%

to this:

set JVMARGS=-Djava.library.path=C:\oracle\bise1\bi\server\Bin;C:\oracle\bise1\bi\web\bin -DSAROOTDIR=C:\oracle\bise1\bi -DSADATADIR=C:\oracle\bise1\bidata -Daxis.ServerConfigFile=server-rpc-config.wsdd -XX:MaxPermSize=128m -Xmx512m %OC4J_JVM_ARGS%

If you are not integrating BI Publisher with Oracle Smart Space, then this command is unnecessary.