Hyperion Product Management recently advised the release of a Patch Set Update (PSU) for Oracle Smart View for Office 11.1.2.5.x
You can download this new version from here :) PATCH 28120145.
This document includes important information about this release of Oracle Smart View for Office. Review the Readme thoroughly before installing Smart View.
New Features:
- New Essbase Expense Type Option.
- Display Varying Attributes in Ad Hoc Grids.
- Support for MDX Calculations for Aggregate Storage Databases.
- New View Properties Button in Oracle BI EE Ribbon.
- Enhanced Move Formatting Behavior.
- Perform a Health Check On Your System
README:
Refer to the Readme files for information pertaining to the above requirements. The Readme file should also be consulted prior proceeding with the PSU implementation. This document contains important information that includes supported paths, implementing and configuration steps, list of new features and defects fixed, along with additional support information.
It is important to ensure that the requirements and support paths to this patch are met as outlined within the Readme file.
More Information:
Available Patch Sets and Patch Set Updates for Oracle Hyperion Smart View for Office (Doc ID 2220997.1)
Smart View Support Matrix and Compatibility FAQ (Doc ID 1923582.1)
Supported Paths to this Release
You can upgrade to Oracle Smart View for Office Release 11.1.2.5.800 from the following FROM 11.1.2.x TO 11.1.2.5.800.
Note: When upgrading from release 11.1.1.3.x and earlier, Oracle recommends uninstalling Smart View before installing release 11.1.2.5.800.
Defects Fixed in This Release
About Defects Fixed in This Release
The topics in this section include defects fixed in Release 11.1.2.5.800. To review the list of defects fixed between earlier releases, use the Defects Fixed Finder This tool enables you to identify the products you own and your current implementation release. With a single click, the tool quickly produces a customized report of fixed-defect descriptions with their associated platforms and patch numbers. This tool is available here.
General
- 17215221 -- On Microsoft Surface Pro tablets, in the Task List pane, the text now displays correctly in the Action Panel and in Task Details. Items in these areas are no longer squeezed together vertically, and the fonts are not cut off at the bottom of each item.
- 26199400 -- The Member Selection dialog now displays correctly when launched from the French Canadian version of Oracle Smart View for Office.
- 27148137 -- After inserting several reporting objects into a PowerPoint presentation, then performing a Cascade Across and selecting members, and then attempting a Refresh All, entering slide show mode may cause the POV to disappear and PowerPoint to stop responding.
- 27679149 -- The Member Selection dialog box is now editable in 4K high-resolution displays.
Essbase
- Bug 27405835 - After inserting a chart and a POV into a PowerPoint slide, and then changing the POV, both objects are refreshed when performing a Refresh.
- 27431964, 28135613 -- In sheets with formulas, a refresh no longer removes formulas or changes the sheet composition.
- 27560276, 27730355 -- After a Refresh, member names defined by formulas are not moved or overwritten.
- 27875032 -- Formulas in an ad hoc grid are now not moved to other cells when the sheet is refreshed.
- 27566388 -- For MDX queries, you can now specify a non-default port number when required. In the Manage and Execute Queries dialog, click Modify Connection , and in the Edit Connection - Application and Cube page of the wizard, select the Advanced Setup check box. In Server, specify the server and non-default port number in this format:
<server_name>:<port_number>
Then specify the Application name and Cube/Database name, and click Finish. Toggle the Change View button in the Manage and Execute Queries to view the MDX queries sorted server and non-default port number. - 28119650 -- Oracle Analytics Cloud - Essbase only. Excel no longer stops working while executing a calculation containing runtime prompts.
Financial Management
- 25902276 -- In Excel worksheets, users are now able to scroll using the mouse wheel after connecting to Oracle Hyperion Financial Management and opening a new worksheet.
- 27450351 -- In an Oracle Managed Cloud Service environment, users will no longer see the message, 'The XML page cannot be displayed', in the login screen when opening a saved workbook and logging in to Financial Management from Oracle Smart View for Office.
- 27524993 -- In an SSO environment with Oracle Access Manager, after successfully signing in to Financial Management in Smart View using a private connection, the Login window no longer becomes blank.
- 27738748 -- When opening a saved workbook that uses a private connection to Financial Management, the error message, 'Failed to instantiate Planning Offline Provider -%x', is no longer displayed and users are able to connect.
Oracle Planning and Budgeting Cloud, Oracle Enterprise Planning and Budgeting Cloud
- 23265152 -- In an ad hoc grid that is based on a form that has Smart Lists, copying data cells and then pasting them no longer cause the pasted cell data to change from text to numeric.
- 25768064 -- In PowerPoint, the Document Content pane remains populated in the following scenario: Insert a chart and then, in the Document Contents pane, insert two reporting objects, a table and a POV. View the slide in slide show mode. Make a change to the POV and then exit slide show mode.
- 26885152 -- A Planning power user is now prompted when trying to save a Smart Form with the name of a form or Smart Form that already exists in Planning.
- 27272782 -- Formatting is no longer lost when refreshing an ad hoc sheet in a saved workbook.
- 27341510 -- In forms, after changing a member for the first time in the POV, the form and the POV retain the change.
- 27388571 -- In the Task list pane, rows no longer overlap.
- 27405666 -- After clearing the cell, you can now enter and submit the same value that was previously submitted.
- 27593442 - There is no longer a lengthy delay in transferring members from the Member Selection to the worksheet.
- 27608935 -- When the #NoData/Missing Label option is set to #NumericZero, "0" is being properly displayed and does not reset to #Missing when switching between sheets.
- 27678819 -- When cascading, the special character, "/", used in a member name is dropped from the name of resulting sheets while keeping the rest of the member name intact for each applicable sheet name.
- 27995997 -- Erroneous formulas and figures are no longer added to blank cells after performing a Refresh.
Supported Platforms
Oracle Smart View for Office 11.1.2.5.800 follows the platform requirements which are stated in the 11.1.2.x version of the Oracle Enterprise Performance Management System Certification Matrix. The topics in this section list platforms supported by Smart View that are in addition to those listed in the matrix, or platform support introduced in this release.
Microsoft Windows 10 Operating System Support
Oracle Smart View for Office 11.1.2.5.520 was the first Smart View release to be supported on Windows 10. Earlier versions of Smart View are not supported on Windows 10.
Fixing Smart View Display and Operations Issues in Windows 10
After a Windows update on some high-resolution displays, drag-and-drop may not work as expected, some controls may look blurry, and some operations may not work properly. For example, an "Invalid selection" error occurs when trying to drag and drop members from the POV.
To avoid the "Invalid selection" error and other display issues after a Windows update:
- Select the Windows 10 Start button, then Settings, then System, then Display, and then Advanced scaling settings.
- Under Fix scaling for apps, set Let Windows try to fix apps so they are not blurry to On.
- Restart Excel.
Drag-and-drop and other operations should work as expected, and the display of Smart View controls should be improved.
Microsoft .NET Framework Support
To install and use Oracle Smart View for Office release 11.1.2.5.600+, Microsoft .NET Framework 4.5 or higher is required.
Microsoft Office Support
Oracle Smart View for Office support for Microsoft Office 2016 began with the 11.1.2.5.520 release. Smart View versions earlier than 11.1.2.5.520 are not supported on Office 2016.
Smart View works on locally-installed Windows versions of Office applications, including Office 365 Pro Plus 2016 installed using Click-to-Run. For more information, see the Knowledge Article entitled Oracle Hyperion Smart View Support for Office 365 (Doc ID 1581197.1).
Windows, Office, and Smart View Locale Settings
18377748 -- On each Oracle Smart View for Office client machine, the following locale settings should match:
- Smart View language option.
- Microsoft Office language.
- Windows Regional Settings.
- Windows operating system
Running Smart View in a language other than the language of the machine's Windows operating system, system locale, or Office language, may result in incorrect data being returned. For example, if the Windows operating system, system locale, and Office language are English, and you run Smart View in Russian, reports or chart data may display incorrectly.
Browser Support
Mozilla Firefox
To use Oracle Smart View for Office 11.1.2.5.800 with Mozilla Firefox ESR 60 and later, you must install the Oracle Smart View for Office web extension for Firefox. You can get the extension by searching on "smartview" on the Firefox Add-ons download site or by going directly to this link. Click the + Add to Firefox button and follow the prompts to add the extension.
Google Chrome
Oracle Planning and Budgeting Cloud 17.06+ and Oracle Enterprise Planning and Budgeting Cloud 17.06+ support interoperability with Google Chrome and Oracle Smart View for Office 11.1.2.5.700+. In Oracle Planning and Budgeting Cloud or Oracle Enterprise Planning and Budgeting Cloud, you may select Open In Smart View to access the same data in Office. Conversely, you may launch Chrome from Smart View in order to access Oracle Planning and Budgeting Cloud or Oracle Enterprise Planning and Budgeting Cloud when performing drill-through operations.
To use Google Chrome with Smart View, install the Oracle Smart View for Office web extension from the Chrome Web Store. You can get the extension by searching on "smartview" in the Chrome Web Store or by going directly to this link. Click the + Add to Chrome button and follow the prompts to add the extension.
Mobile Device Support
Oracle Smart View for Office is supported on Microsoft Surface Pro tablets only. Smart View is not supported on any other tablet or smartphone.
Financial Management Journals Extension Support
The Oracle Journals for Financial Management extension works with Oracle Smart View for Office version 11.1.2.5.500 and later, and with Oracle Hyperion Financial Management 11.1.2.4.100 and later.
The Oracle Journals for Financial Management functionality introduced in Smart View 11.1.2.5.700 requires the following:
- Financial Management 11.1.2.4.204 with the 11.1.2.4.204 PSE 25575478
- Smart View 11.1.2.5.700+
- Oracle Journals for Financial Management extension 11.1.2.5.700+ (included with Smart View 11.1.2.5.700+)
Oracle Analytics Cloud Support
To use the Oracle Analytics Cloud-related features in Oracle Smart View for Office, you must have Oracle Analytics Cloud 17.3.2 or later.
Thank you.
Warm Regards,
SST.!
No comments:
Post a Comment