PSA HFM 11.2.4 and 11.2.5 SmartView Bug (BUG# 32692920)

  • Date: May 27, 2021
  • Article by: Jeff Henkel

For those customers using Hyperion Financial Management who have upgraded recently, are in the process of upgrading, or are considering upgrading, this is a public service announcement.

It has come to our attention here at iArch Solutions that there is a bug in the HFM SmartView connection for both 11.2.4 and 11.2.5 that renders Row Suppression for No Data / Missing and Zero to be unusable when performing Ad-Hoc retrieves.  

These values are set in the SmartView Data Options (shown below).  In the case of the ‘Zero’ value, the product doesn’t actually suppress the data.  In the case of using the No Data /Misssing suppression you get the error “An Unknown Error has Occurred”.

Here is a data grid from the HFM Sample Application COMMA, with no suppression enabled.  You will note we have one Dimension in rows (Account) and one in the columns (Year):

Now enable Suppression by Suppress Rows:

Refresh with suppression and here are the results, with the data suppressed as expected and everything seems to be working.

However, this issue will escape basic validation because if you do a simple ad-hoc query with a single dimension in the columns and rows, the data will suppress as expected, but if you add an additional dimension to rows or columns, and refresh you get the following error:

This happens when simply trying to drag a new member in the grid hierarchy from the POV selector, when suppression is enabled.  But let’s assume you had a pre-existing sheet with multiple dimensions already in the columns/rows, and you choose to refresh that.

In the case below, we have the same dimensions from above, but we’ve also added ‘Customer’ to the Columns and refreshed.  Then you are greeted with the below error:

The above issue was encountered by one of our clients and Oracle has confirmed this is an unpublished Bug #3262920.  Oracle has stated that the fix for this will be included in the forthcoming 11.2.6 maintenance release, but there is a backward compatibility patch available from Oracle support if you open an SR.  The patch requires the latest HFM public release patch for 11.2.4 (Patch Number 32592115) and also a one-off patch that is comprised of one file, but is locked so you’ll need the password to access (32804571).

As a final note, this is a pretty key piece of basic functionality (which performs as expected for Planning/Essbase) and may be a cause of concern for HFM customers, and we recommend clients going through the proper channels to acquire the patch if needed. 

Share me

Oracle Security Alert for CVE-2021-44228: Part Four

  • Date: Dec 16, 2021
  • Article by: Mike Turner
Read More

Oracle Security Alert for CVE-2021-44228: Part Three

  • Date: Dec 15, 2021
  • Article by: Jeff Henkel
Read More

Kscope 17

  • Date: November 22, 2016
  • Article by: Joe Malewicki

untitled
iArch Solutions is proud to announce that we will be an exhibitor at Kscope 17 in San Antonio, Texas (June 2017).
Having presented in year’s past, we are excited to share our ideas at one of the top conferences on Oracle products.  Thinking about attending the conference?  Use our special discount code IARCH and save $100 on the registration!!
Come swing by our booth, check us out and enter yourself a chance in winning one of our great giveaways!  Stay tuned for more updates coming soon.  We look forward to seeing you in Texas!
http://www.kscope17.com/vendors

Share me

Oracle Security Alert for CVE-2021-44228: Part Four

  • Date: Dec 16, 2021
  • Article by: Mike Turner
Read More

Oracle Security Alert for CVE-2021-44228: Part Three

  • Date: Dec 15, 2021
  • Article by: Jeff Henkel
Read More

Financial Management (HFM) Performance Problems When Using SQL Server Database

  • Date: October 10, 2016
  • Article by: Elysha Daly

Is your Hyperion Financial Management System running “slow?”  That’s good, because now you have a chance to “catch it” and maybe speed it up!!  If you have more than one HFM application server running against a Microsoft SQL Server backend for your database, then please follow these steps to either fix the issue or confirm that this is not causing the issue.
The standard procedure when using Microsoft SQL Server database as a repository for any Oracle Hyperion product is to run the following SQL query for all databases prior to configuring your software:

Set READ_COMMITTED_SNAPSHOT = ON
Set ALLOW_SNAPSHOT_ISOLATION = ON

This pre-requisite requirement can be found in the Oracle Enterprise Performance Management System Installation and Configuration Guide.
However, it has been recently discovered, that this database setting has potential negative performance impact on certain HFM Application tasks, such as consolidations.
Run the following SQL query against all existing HFM databases within your environment(s) to confirm the state of the current database setting.  If your results display a “1” or “on” then please proceed to our offered solution below.

select name, is_read_committed_snapshot_on, snapshot_isolation_state_desc from sys.databases

 
epm_hfm_pics
Solution:
First, confirm that all Oracle EPM Service Software has been stopped.
Second, if possible, perform a restart of the Microsoft SQL Server Windows service to clear any orphaned processes.
Third, perform a cold back up of your HFM database.  ***This is a critical step***
Last, you will run the following SQL query against the HFM database.

alter database <HFM_DB>
set allow_snapshot_isolation off;
alter database <HFM_DB>
set read_committed_snapshot off;

 
In our example we changed the <HFM_DB> within the SQL query to EPM_FM, the name of our Financial Management database.
pic03
Now you can go back and run this query again to confirm the change has taken hold:

select name, is_read_committed_snapshot_on, snapshot_isolation_state_desc from sys.databases

 
Please note the change in the EPM_FM state to “0” and “off.”
pic04
 
When this process is complete, please go ahead and restart your Oracle EPM Service Software.  We always suggest you perform your standard validation to confirm that your environment is still functioning properly.  While there is no guarantee of the amount of performance improvement, through our own testing, we were able to see a client’s Financial Management consolidation process reduced from over 2 hours to approximately 15 minutes.
We at iArch Solutions hope you found this blog helpful. Is there a question you want answered in a blog?  Send us your questions, comments and feedback.
APPLICABLE VERSIONS: 11.1.2.4

Share me

Oracle Security Alert for CVE-2021-44228: Part Four

  • Date: Dec 16, 2021
  • Article by: Mike Turner
Read More

Oracle Security Alert for CVE-2021-44228: Part Three

  • Date: Dec 15, 2021
  • Article by: Jeff Henkel
Read More