Liberate your data

Intelligence is all about knowledge. This website is dedicated sharing expertise on Oracle BI. More ยป

 

Business Analytics Monthly Index – November 2017

Welcome to the Monthly Index posting for November 2017

The following provides quick links to recent Proactive Support Blog postings from over the month just past.

#maintable td.white {color:#ffffff;} #maintable td.black {color:#000000;} General Summary Link Business Analytics Monthly Index - October 2017 View

 

Business Intelligence (BI) Summary Link There were no posts this month.  

 

Business Intelligence (BI) Cloud Summary Link Oracle BI Applications (OBIA) on Cloud Services – Whitepaper on Deployment Options View

 

Enterprise Performance Management (EPM) Summary Link EPM Patch Set Updates - October 2017 View Hyperion Planning Patch Set Update 11.1.2.4.007 is Available View Oracle Hyperion Financial Management 11.1.2.4.206 is available View

 

Enterprise Performance Management (EPM) Cloud Summary Link Oracle Account Reconciliation Cloud (ARCS) - December 2017 Updates View Oracle Enterprise Performance Reporting Cloud (EPRCS) - December 2017 Updates View Oracle Financial Consolidation and Close Cloud (FCCS) - December 2017 Updates View Oracle Planning and Budgeting Cloud (PBCS) - December 2017 Updates View Oracle Profitability and Cost Management Cloud (PCMCS) - December 2017 Updates View Oracle Tax Reporting Cloud (TRCS) - December 2017 Updates View Frequently Asked Questions About EPM Cloud Data Size View Top 10 Videos on the Oracle EPM Cloud YouTube Channel View

 

Advisor Webcasts Link There were no webcasts posted this month  

 

Note: To review Archived Recordings and to Register for future Advisor Webcasts, visit Doc ID 1456233.1

EPM Patch Set Updates – November 2017

The following are the Enterprise Performance Management (EPM) Patch Set Updates (PSU) released last month (November 2017).

The "Patch" ID links will access the patch directly for download from "My Oracle Support" (login required).

Hyperion Planning Patch Link Hyperion Planning 11.1.2.4.007 Patch 27027776

 

Hyperion Financial Management Patch Link Hyperion Financial Management 11.1.2.4.206 Patch 26760297

 

Oracle Smart View for Office Patch Link No patch this month  

 

Note:

  • Some patches listed may have been released a few days outside of the stated month.
  • Be sure to review the related Readme files available per Patch Set Update.
  • For the latest Enterprise Performance Management Patch Set Updates visit Oracle Hyperion EPM Products [ Doc ID 1400559.1 ]

To view the patches released over previous months visit the earlier Blog posts:

Hyperion Financial Close Management and Tax Governance 11.1.2.4.250 is Available

The following Patch Set Update (PSU) has been released for Hyperion Financial Close Management (FCM) 11.1.2.4.x.

This PSU download is available from the  My Oracle Support > Patches & Updates section.

Hyperion Financial Close Management and Tax Governance PSU 11.1.2.4.250
 Patch 26503587

 

NOTE:  11.1.2.4.250 PSU for Financial Close Management and Tax Governance are the same patch but have different readme steps. See notes below:

  • If you have Tax Governance and Financial Close Management installed on same environment, please follow the readme steps from FCM 11.1.2.4.250 instead.
  • If you have Tax Governance and Financial Close Management installed on same environment and have applied FCM 11.1.2.4.250 PSU (26503587), you need not apply this patch on that environment.

 

Important:

Prior to proceeding with this PSU implementation refer to the Readme file for important information. In addition to the details of new features and full list of the defects fixed, the Readme file contains important support information that includes prerequisites, install details for applying patch, post-installation instructions, and tips & troubleshooting information.

It is important to verify that the requirements and support paths for this patch are met as outlined within the Readme file.

The Readme file is available from the Patches & Updates download screen.

Supported Paths to this Patch

You can apply this patch to the following releases:

  • 11.1.2.4.000
  • 11.1.2.4.100 PSU
  • 11.1.2.4.101 PSU
  • 11.1.2.4.102 PSU
  • 11.1.2.4.103 PSU
  • 11.1.2.4.200 PSU
  • 11.1.2.4.201 PSU
  New Features in 11.1.2.4.250

Financial Close Management

  • Imports Allow Choice of File Delimiter (Comma or Tab)  
  • Date Calculations

Supplemental Data Manager

  • Ability to Use Negative Start Date Offset in Forms
  • Configurable Column Width in Forms 
  • Load Viewer Access to Forms
  • Advanced User Assignments by Enabling Teams

Close Manager

  • Support for Close Manager Smart View Extensions
  • Add an Attachment to Multiple Tasks
  • Archive and Purge in Close Manager

Account Reconciliation Manager

  • Support for Variance Analysis Reconciliation Method 
  • Bulk Actions Available on Reconciliations or Transactions
  • Add an Attachment to Multiple Reconciliations or Transactions
  • Archive and Purge in Account Reconciliation Manager

Tax Governance

  • Imports Allow Choice of File Delimiter (Comma or Tab)   
  • Date Calculations

Tax Supplemental Schedules

  • Ability to Use Negative Start Date Offset in Forms
  • Configurable Column Width in Forms
  • Load Viewer Access to Forms
  • Advanced User Assignments by Enabling Teams

Tax Operations

  • Support for Tax Operation Smart View Extensions   
  • Add an Attachment to Multiple Tasks
  • Archive and Purge in Tax Operation

 

To share your experience about installing this patch ...

  • In the MOS > Patches & Updates screen for FCM  Patch 26503587, click the "Start a Discussion" or "Reply to Discussion" and submit your review.
  • The patch install reviews and other patch related information is available within the My Oracle Support Communities. Visit the Oracle Hyperion EPM sub-space -  Hyperion Patch Reviews

Have a question for FCM specifically ....

To locate the latest Patch Sets and Patch Set Updates for the EPM products visit the My Oracle Support (MOS) Knowledge Article Oracle Hyperion Enterprise Performance Management Products Doc ID 1400559.1

 

Patch Set Update: Oracle Smart View for Office 11.1.2.5.720

Hyperion Product Management recently advised the release of a Patch Set Update (PSU) for Oracle Smart View for Office 11.1.2.5.x

Patch Set Update: 11.1.2.5.720 Oracle Smart View for Office Patch 26783864

 

This PSU download is available from the  My Oracle Support | Patches & Updates section.

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.

The Readme file is available from the Patches & Updates download screen.

 

New Features in this Release:

  • Improved MDX and Smart Query Management
  • Cascade from Multiple Dimensions
  • Business Rule Template Support
  • New and Enhanced VBA Functions
  • HsGetValue Accepts Additional Data Types
  • Streamlined Extension Update Process
  • New Option for Displaying or Suppressing Floating Toolbar in Forms
  • Updated Look and Feel for User Preferences Dialog Box
  • New Essbase Option for Preserving Comments and Unknown Members

 

Information about system requirements and supported platforms for EPM System products is available in spreadsheet format in the Oracle Enterprise Performance Management System Certification Matrix. This matrix is posted on the Oracle Fusion Middleware Supported System Configurations page on Oracle Technology Network (OTN):

Note: Smart View 11.1.2.5.720 follows the platform requirements which are stated in the 11.1.2.x version of the Oracle Enterprise Performance Management System Certification Matrix.

 

More Information:

  • Tips and troubleshooting topics are listed in the Oracle Smart View Installation and Configuration Guide. This guide is available in the Smart View 11.1.2.5.720 library on the Oracle Help Center:
  • 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)

 

Rittman Mead at UKOUG 2017

For those of you attending the UKOUG this year, we are giving three presentations on OBIEE and Data Visualisation.

Francesco Tisiot has two on Monday:

  • 14.25 // Enabling Self-Service Analytics With Analytic Views & Data Visualization From Cloud to Desktop - Hall 7a
  • 17:55 // OBIEE: Going Down the Rabbit Hole - Hall 7a

Federico Venturin is giving his culinary advice on Wednesday:

  • 11:25 // Visualising Data Like a Top Chef - Hall 6a

And Mike Vickers is diving into BI Publisher, also on Wednesday

  • 15:15 // BI Publisher: Teaching Old Dogs Some New Tricks - Hall 6a

In addition, Sam Jeremiah and I are also around, so if anyone wants to catch up, grab us for a coffee or a beer.