Blog Details Page

  • Date: October 21, 2016
  • Article by: Robert Barrett

When bad things happen and you have to start troubleshooting, it is important to know what version of software you are using.  Whether you or someone else is doing the work, knowing what version or even the patch level of your system, will be required.  Below we have listed a few programs and how to find their versions.

Microsoft Excel

First, go to your “Start” menu and open your Microsoft Excel program.

 

png1

 

Second, select the “File” tab and  choose “Help.”  You will find the versioning information to the right.

png2

 

If you are using Smart View the information you will need is under the SmartView tab.

First, from Excel select your Smart View tab.

Second, Choose the “Help” option and then go to “About(z)…”

png3

 

The Smart View version will then  be displayed for you.

png4

 

To find your Operating System information go to your “Start” menu and select “Computer.”

png5

 

Second, right click on your “Computer” and choose “Properties.”

png6

 

Here you will find which operating system you are running on as well as your computer’s name and other vital information.

png7

 

In order to see what version your various Hyperion products are at, you will need to log into Workspace.

Second, click on the “Tools” option and choose “About Oracle Enterprise Performance Management System Workspace, Fusion Edition.”

png8

 

Third, select “Show Details.”

png9

 

You will be able to scroll through the various Hyperion products and their given patch levels.

png10

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.0, 11.1.2.1, 11.1.2.2, 11.1.2.3, 11.1.2.4

Share me

Oracle Cloud Infrastructure Foundations 2020 Certified Associate Issued to Joe Malewicki, Jr.

  • Date: Jul 07, 2020
  • Article by: Elysha Daly
Read More

Oracle EPM 11.2.2 Dropped

  • Date: Jun 30, 2020
  • Article by: Joe Malewicki
Read More

Blog Details Page

  • Date: October 10, 2016
  • Article by: Robert Barrett

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 Cloud Infrastructure Foundations 2020 Certified Associate Issued to Joe Malewicki, Jr.

  • Date: Jul 07, 2020
  • Article by: Elysha Daly
Read More

Oracle EPM 11.2.2 Dropped

  • Date: Jun 30, 2020
  • Article by: Joe Malewicki
Read More