Sunday 23 February 2014

Overview For EPM 11.1.2.3 Features




While waiting for the release of the upcoming EPM version I thought I would publish my notes from the Oracle webcast covering new features in EPM 11.1.2.3. If you want to find out more details about each product I recommend you to reserve two and a half hours and listen through the entire webcast as it contains nice presentations from each of the EPM product teams. The recording is available via the Oracle BI&EPM EMEA Partner Community blog.

In the Top Gun conference we also received lots of interesting information about the changes that 11.1.2.3 will bring to EPM infrastructure. Unfortunately Oracle does not want to share this information until the new release is made publicly available so you will have to wait patiently for the juicy technical bits until then...


All the information extracted from the webcast is naturally covered by the Oracle Safe Harbor statement which means that it's all subject to change until the new release has gone gold.
General Improvements (all EPM products)
  • Better support for ODL logging and addition of ECID information to make troubleshooting across several product components easier 
  • Backwards compatibility to LCM - importing artifacts from release 11.1.1.3 and up supported in 11.1.2.3

Hyperion Financial Management 11.1.2.3

Web form and grid usability enhancements:
  • Save more POV settings in form definitions (show or hide dimensions and reorder them)
  • Save POV members as favorites for easier access (no need to open the POV Member Selector panel every time)
  • Support for dynamic POV memberlists
  • Support for on-demand rules launched per form
Other new HFM features:
  • General UI improvements (POV and Member Selector settings persist across HFM modules)
  • Security user access UI implemented in ADF
  • HFM modules that are not used (for example Process Control and IC Transactions) can be disabled and thus hidden from the menus by administrators via the Module Configuration panel
  • Audit log for differences after loading metadata
  • LCM supports additional HFM artifacts: application, data, audit, process management, Extended Analytics templates


Hyperion Planning 11.1.2.3

  • Support for ASO databases in Planning applications
  • Support for flexible custom dimensions that may differ in each plan type
  • Ability for end users to create dimension members on the fly (only in separate modules such as Project Financial Planning). This feature can be enabled or disabled per hierarchy.
  • Outline Load Utility implemented in the web interface: allows metadata to be imported and exported from the Planning UI
  • Access to Planning metadata in Smart View (add or update members, build hierarchies)
  • Export/import Planning metadata and data to/from a relational database
  • Task list visualizations for easier tracking (by task status, type, users etc.)
  • Planning Cloud Service: Service to be released later this year. Based on Planning 11.1.2.3.

Financial Data Quality Management (FDM) 11.1.2.3 and beyond

  • FDM rebranded as Financial Data Quality Management, Enterprise Edition (FDMEE)
  • FDMEE combines classic FDM and ERP Integrator into a single product built on the ERPI platform (ODI installed and configured automatically)
  • 11.1.2.3 will be the terminal release for classic FDM - new customers may only buy FDMEE
  • FDMEE will be released in phases (11.1.2.3 GA, 11.1.2.3 Patch Set 1 and Patch Set 2)
  • Core FDM features present in GA version but features like full HFM adapter functionality will follow later in PS1 and 2.
  • Some functions to be introduced in PS1 and PS2:
    • Scripting in Jython
    • Integration with DRM
    • Data synchronization between all EPM application types
    • HSF adapter
  • FDMEE UI is integrated in EPM Workspace

Financial Reporting 11.1.2.3
  • Old dog learns new tricks - FR reports and books to be supported on mobile devices via native browsers on each platform:
    • iPhone and iPad (iOS5 and 6)
    • Android phones and tablets (Android 3.x and 4.x)
  • Mobile support allows read-only access with POV selection, prompts etc. but no authoring or scheduling features.
  • Improved Smart View support (full FR formatting available when using Function Grids in Word and Excel)
  • Create a cover page before TOC in report books 

Smart View

Upcoming SV features (some already present in 11.1.2.2.310):
  • OBIEE functionality added (view created content, program OBIEE objects in VB etc.)
  • Performance improvements
  • Improved ad-hoc functionality: change POV on the grid, perform operations on multiple cells etc.
  • Expanded VBA toolkit

Hyperion Strategic Finance 11.1.2.3
  • Smart View functionality greatly extended to provide full MS Office integration (complements the HSF Windows client)

Disclosure Management 11.1.2.2.300

Note: Release already available.
  • New publishing options: PDF generation, EDGAR-ready HTML output
  • Variables for automating common text and TOC items
  • Several UI improvements in Report Manager

Financial Close Management 11.1.2.3

Lots of new features in ARM (Account Reconciliation Manager):
  • Advanced user assignments (backup assignments, team/group assignments etc.)
  • Extended Auto Reconciliation module
  • Improved data load functions
  • UI improvements

Hyperion Profitability And Cost Management (HPCM) 11.1.2.3
  • Addition of Calculation Rules for combining existing model artifacts, assignment rules and drivers into a single function
  • Simplifies definition of assignment logic for groups of sources
  • HPCM is certified on Exalytics since 11.1.2.2.350
  • Smart View integration for drill-through links and custom queries to Excel

Thursday 13 February 2014

Oracle Hyperion Essbase and 64 Bit Master Note Documents

The purpose of this document is to serve as a quick reference for Essbase and 64 bit.

ODBC and 64 Bit Drivers:



  • Document 1268756.1 Troubleshooting Problems with Essbase SQL Interface and SQL / ODBC Data Sources
  • Document 834837.1 Error "The setup routines for the ODBC driver could not be loaded due to system error code 193" Unable To Create Datasource
  • Document 1269027.1 Error "(1012695) DataExport can not do batch insert to relational table. The ODBC driver and/or RDBMS doesn't support batch insert." When Exporting Data Using DATAEXPORTENABLEBATCHINSERT.
  • Document 764192.1 Does EIS 9.3.1 Support 64 bit ODBC drivers and 64 bit DB2 Instances For Control Databases?
  • Document 783782.1 Implications of Registering ODBC Merant Drivers on 64-Bit Windows

API and 64 Bit:


  • Document 947299.1 Can a 64-bit API Client Connection be Made to a Windows Essbase 32-bit Server
  • Document 788491.1 C API EssListUsers Returning Different Results in 9.3.1 64 bit Version
  • Document 1322496.1 Running a 32-bit VB API on a 64-bit Essbase Server Fails With "ERROR: Essbase Initialization Failed, StatusCode = 1030803"
  • Document 1062167.1 SIGSEGV Error or C++ Crash in Essbase 11.1.1.3 C API on Linux Redhat 5.2 64 bit
  • Document 1391664.1 Essbase C API Program Environment Variables for 64-BIT Windows Machine with 64 Bit Runtime Client 


Installation Issues:


  • Document 1116801.1 Installation of Essbase 11.1.2 Spreadsheet Add-in on 64-bit Server Failing With Error
  • Document 1311028.1 Oracle EPM 32-bit Install on 64-bit Windows Server Error "Windows cannot find "%dirname%\jre\winamd64\1.6.0\bin\java""
  • Document 1339305.1 Essbase Excel Add-In Client Installation on MS Windows 7 (64 Bit) Fails 
  • Document 851012.1 "The image file E:\TEMP\Setup.exe is valid. But is for a machine type other than the current machine". When Installing Essbase Administration Services (EAS) 64-bit.


Outline Issues:


  • Document 1223357.1 Migrating an Aggregate Storage (ASO) Outline Crashes the Essbase Administration Services Server (EAS) When Using 64 bit Installation
  • Document 800076.1 Error Updating ASO Outline "Hierarchy [DimensionName] is too complex: maximal width member number exceeds 64 bits. See application log for details."

Connection Issues:
  • Document 888704.1 Unable to Connect to EAS 11.1.1.2 After EAS is Installed on Windows 64 bit Server
  • Document 958183.1 SmartView Connection Screen Box is Blank in Excel 2007 on Windows 64 bit


SmartView Issues:


  • Document 1293184.1 Smart View Connection Screen Box Is Blank In Excel 2007 On Windows 64-Bit After Applying Patch
  • Document 958183.1 SmartView Connection Screen Box is Blank in Excel 2007 on Windows 64 bit


Perl and 64 bit:


  • Document 964517.1  Is there a 64-bit Essbase Perl Module for Windows 64-bit Servers?
  • Document 1385486.1 PERL Module is Truncated When Using Essbase v11.1.2.1.102 on Solaris 64-Bit Server


32 bit or 64 bit:


  • Document 985384.1 How To Determine if Essbase is the 32 or 64-Bit Version on a 64-Bit Windows Platform


Miscellaneous Errors:


  • Document 1062167.1  SIGSEGV Error in ESSBASE 11.1.1.3 C API on Linux Redhat 5.2 64 bit
  • Document 1086979.1 "Error -1: Contact your AIS administrator because the Java runtime environment may not be set appropriately on the server machine..." EIS XML Import /Export Fails on Unix 
  • Document 966036.1  Error: "Cannot load IA 32-bit .dll on a AMD 64-bit platform" when Running Configtool 
  • Document 1301800.1 Unable to Connect to 64-bit Teradata From 64-bit Essbase v11.1.2 SQL Interface
  • Document 848673.1 "Can't load AMD 64-bit .dll on a IA 32-bit platform" When Starting Essbase Administration Services (EAS)
  • Document 1344089.1 Running 11.1.2.1 MaxL or Esscmd Fails With Error: "Failed To Initialize" on 64-bit Operating System
  • Document 1342578.1 Essbase 11.1.2.1 Does Not Start on AIX 64-Bit Error: Could not load module libclntsh.so
  • Document 1382589.1 Error "essmsh.exe has stopped working" with MAXL Deploy Script Generated from Essbase Studio on Windows 64-bit
  • Document 1512580.1 Cannot Login Essbase Administration Services (EAS) 11.1.2.2 Installed on IBM AIX (7.1 TL1) (64-bit) with Websphere 7.0.0.23
  • Document 1502036.1 Essbase Runtime Client Patch 13009684 on 64-bit Systems Does Not Include the 32-bit RTC Files
  • Document 1496305.1 Unable To Apply 11.1.2.1.103 Patches For Essbase Server, Client, EAS on Solaris SPARC 64-bit Receive "CheckPatchApplicableOnCurrentPlatform" Failed



REFRENCE

Oracle Hyperion Essbase and 64 Bit Master Note (Doc ID 1090635.1)

Oracle Hyperion Planning and Technical Issues


Featured Articles:
  • Hyperion Planning 11.1.2.1.000 Patch Set Exception (PSE): 12432741 Document 1323946.1
  • Information Center: Oracle Hyperion Planning Document 1349181.2
  • Upgrade Advisor: Enterprise Performance Management (EPM) System Upgrade from 11.1.1.3 to 11.1.2.1 Document 324.1
The following articles are general information for troubleshooting known issues in Planning. 

Public Sector Budgeting

  • Document 1399983.1 Oracle Hyperion Planning Public Sector Budgeting (PSB) Technical Information


Business Rules:
  • Document 1173313.1 Troubleshooting the Business Rules Command Line Launcher (CmdLnLauncher)
  • Document 966683.1 How to Delete Business Rules Jobs with Status "Processing" in Planning Web
  • Document 763345.1 Troubleshooting Hyperion Business Rules Issues
  • Document 873606.1 Planning Times out with Error "StuckThreadMaxTime" While Running Business Rules
  • Document 855821.1 Improving the Performance of Business Rules and Calculation Scripts
  • Document 755406.1 Business Rules That Take More Than Five Minutes to Execute Are Re-launched Repeatedly


Essbase:
  • Document 797362.1 Essbase Tuning Guide For Planning Applications
  • Document 1304213.1 Error Connecting to Essbase Server When Attempting to Validate Business Rules
  • Document 1332650.1 Invalid Member Formulas Cause Essbase Application To Crash and Generates *.xcp Files During Planning Database Refresh Process


Forms:
  • Document 779502.1 Hyperion Planning Data Form Design Considerations
  • Document 1269428.1 11.1.2 Planning forms are very slow and may hang Internet Explorer (IE).
  • Document 789267.1 Error When Opening Large Planning Form: 'No backend server available for connection...'
  • Document 950164.1 Planning Form Error: "Request timed out. Contact System Admin to increase NetRetryCount and NetRetryInterval"
  • Document 972825.1 Migrated using LCM Some Forms Give an Error: "The Data Form is invalid. Check Log For Details"


Install/Configuration:
  • Document 1162975.1 How to Disable UAC in Windows Server 2008
  • Document 1376363.1 Error "Your session has timed out or was terminated by the application owner or an administrator" After Adding a Second Planning Web Application Node in Oracle EPM 11.1.2.1 Environment


LCM:
  • Document 1072301.1 Frequently Asked Questions Regarding the General Use and Functionality of the Lifecycle Management Utility (LMC)
  • Document 1202463.1 How to Migrate and EPMA Planning Applications Using LCM
  • Document 1072301.1 Frequently Asked Questions Regarding the General Use and Functionality of the Lifecycle Management Utility
  • Document 972825.1 Migrated using LCM Some Forms Give an Error: "The Data Form is invalid. Check Log For Details"


Planning Web:


General:
  • Document 822467.1 Consequences Of Changing Administrator User Passwords
  • Document 1127664.1 Hyperion Planning Error: "Failed to sync with user provisioning. Check planning log for details."
  • Document 988576.1 Troubleshooting Email Notifications In Hyperion Planning
  • Document 1327171.1 Hyperion Planning System Properties
  • Document 1226783.1 Hyperion Planning Process Management Features explained By Example
  • Document 1097051.1 How to Troubleshoot Planning Hanging Due to "java.lang.OutOfMemory Error"
  • Document 1311548.1 Error Message In Planning Log File: "Cannot Parse POST Parameters of Request"
  • Document 744805.1 How do I Change the Java Options and Heap settings for Planning on Weblogic or Tomcat
  • Document 1315954.1 Error Logging Into Planning "An Error Occurred While Processing This Page. Check The Log For Details. Please Close The Current Tab and Open Application Again..."


Patch Issues:
  • Document 1066214.1 When applying Planning 11.1.1.3.01 SF with Websphere 6.1 Error: "An Error Occurred" When Logging into Planning Web
  • Document 1152573.1 Error: "OPatch failed with error code 73" when trying to install a patch using OPatch
  • Document 1123053.1 Opatch Error: "oracle.opatch.PrereqFailedException: Prerequisite check "CheckApplicable" failed."
  • Document 859857.1 "OPatchSession cannot load inventory for the given Oracle Home" When Applying Patch
  • Document 1357748.1 OPatch "no-op patch" Error Is Not Resolved By Running createinventory Script


Performance:


Utilities:


Reference:


The Oracle EPM and BI Support Newsletter Current Edition (Document 1347131.1) is available; 


REFERENCES

Oracle Hyperion Planning and Technical Issues (Doc ID 1076868.1)