Oracle Smart View for Office 11.1.2.5.810

• New Version of Oracle Smart View for Office: Oracle Smart View for Office 11.1.2.5.810 will be available in November 2018. This version includes new features such as:
• Drill-Through to Excel Sheets from EPM Cloud
• Attaching Files to Cells in Forms and Ad Hoc Grids
• Additional Information Added to Health Check
• Support for Oracle Sales Planning Cloud

This release also fixes a number of defects.

The Smart View 11.1.2.5.810 Readme, available on the Help Center, will contain a complete list of features and defects addressed in this version. You must install this version to ensure access to the new functionalities.

Administering Oracle Financial Consolidation and Close Cloud

Running a Consolidation Report

Report Overview

You can run a Consolidation report that provides a detailed audit trail of the consolidation process. The report is available in HTML, PDF, or XLS format.

https://docs.oracle.com/en/cloud/saas/financial-consolidation-cloud/agfcc/consolidation_report.html

Hyperion EPM Automate Utility - Oct 2018 update

https://www.oracle.com/webfolder/technetwork/tutorials/tutorial/cloud/fccs/2018-fccs-wn.htm#F5423

Hyperion Calculation Manager Performance Issue

Expanding Planning/Essbase node takes 3-5 minutes and then error "Server was unable to process request" is displayed

Verify that the Calc Manager service is not HUNG and/or Running.  The service can consume CPU/Memory, so ensure your Java Heap Size Min/Max is properly setup in your windows registry for Calc Manager

Smart View Performance with Hyperion Planning Applications

Below are some of the the tuning parameters to improve Smartview communication with Hyperion Planning, when using Webforms:

1. Add the following Windows registry settings on the client machine where Smartview is deployed:
   [HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet Settings] 
   "ReceiveTimeout"=dword:001b7740
   "KeepAliveTimeout"=dword:001b7740
   "ServerInfoTimeout"=dword:001b7740
2. Change Smartview Options to improve performance on large retrievals:
   • in Formatting: Select the option to Use Excel Formatting. Without this option, Smart View will reformat each cell based on the grid operations you perform. It will also mark cells as “dirty” each time you change data values. These activities add system overhead to all Refreshes, making them take longer.
   • in Advance -> Compatibility: Select the option Improve Metadata Storage
   • In Data Options: Select Suppress No Data/Missing, Zero
3. In Excel -> Tools -> Save tab, disable the 'Save Auto-recover info every' which can have a negative impact on large queries that take time to render.

Hyperion Smartview and Outlook's slow response

Recently we had some users enabled Smartview for Outlook....this caused their Outlook to slow down or crash.

To fix this, we disabled the flag for displaying Smartview in Outlook.
Open Smartview in Excel
Goto Options
Then Advanced option on the right side
Then click on Disable Smartview in Outlook
Restart Outlook

Oracle Hyperion Cloud - Videos, Documents and other items

https://blogs.oracle.com/proactivesupportepm/epmcloud_documentation