Blog Details Page

  • Date: June 19, 2019
  • Article by: Joe Malewicki

Rumors gossip and software envy for al those “new vendors” claiming that on-premise Hyperion is dead!!!… news flash, Oracle isn’t killing off On-Premise Oracle Hyperion Enterprise Performance Management (EPM) System 11.2 folks!

Here’s a glimpse of what’s to come with the newly announced Oracle Hyperion Enterprise Performance Management (EPM) System 11.2 roadmap! They’re shifting Oracle Hyperion Enterprise Performance Management (EPM) System family of tools and applications under the “Oracle Applications Unlimited” structure and have announcement details on release cycles as well as product support roadmap.

Oracle Application Unlimited Announcement for Oracle Hyperion Enterprise Performance Management (EPM) System 11.2:

https://www.oracle.com/a/ocom/docs/support/hyperion-epm-announcement.pdf

Oracle Hyperion Enterprise Performance Management (EPM) System 11.2 “Continuous Innovation” announcement:

http://www.oracle.com/us/products/applications/applications-unlimited-1970561.pdf

If you have questions about the direction of Oracle Hyperion Enterprise Performance Management (EPM) System 11.2 or if you are interested in discussing how this coming update will impact your organization’s “Path To The Cloud” please let us know! I’ll be happy to chat!!

Joe Malewicki

President – Certified Oracle Cloud Architect, Cloud Infrastructure OCI and Platform Specialist at iArch Solutions, LLC

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: May 30, 2018
  • Article by: Joe Malewicki

Back by popular demand (or the workings of our founder Joe Malewicki and his insatiable quest to out-do last year’s booth!) we are proud to announce that iArch Solutions will be returning in all it’s glory to the annual ODTUG conference Kscope18 hosted this year at the Walt Disney World Resort Dolphin Hotel.

Planning on attending Kscope 18, use the discount code IARCH and save $100 off your registration.  While you are there, come check out our new booth, chat about your current and or future Cloud Migration needs or maybe just try to win some of our show stopping new bling!

We hope to see you in Orlando in June!

So with Kscope 18 just around the corner, we thought we would do a Throwback Thursday to Kscope 17 when Joe presented his “Best Speaker Award” winning presentation to a standing room only crowd only in San Antonio, Texas:

 “The EPM Clouds are Rolling in Fast! Is It Really Worth Upgrading My On-Premise System Now?”

The EPM Clouds are Rolling in Fast! Is It Really Worth Upgrading My On-Premise System Now?

Listen to the full presentation on our new iArch Solutions YouTube Channel:

 

 

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: May 30, 2017
  • Article by: Joe Malewicki

Join us today May 30th, 2017 at 3:00pm EST for a Sneak peak preview of our Kscope17 Session:

“The EPM Clouds are Rolling in Fast! Is It Really Worth Upgrading My On-Prem System Now?”

Presented by our own Joe Malewicki.

Register Today!

Taste of Kscope17: The EPM Clouds are Rolling in Fast! Is It Really Worth Upgrading My On-Prem System Now?

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: May 30, 2017
  • Article by: Joe Malewicki

Join us today May 30th, 2017 at 3:00pm EST for a Sneak peak preview of our Kscope17 Session:

“The EPM Clouds are Rolling in Fast! Is It Really Worth Upgrading My On-Prem System Now?”

Presented by our own Joe Malewicki.

Register Today!

Taste of Kscope17: The EPM Clouds are Rolling in Fast! Is It Really Worth Upgrading My On-Prem System Now?

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: March 3, 2017
  • Article by: Joe Malewicki

Did you hear the latest on Kscope 17?  Not only will iArch Solutions have their first ever booth, our own Joe Malewicki will be presenting at the conference.  Planning on attending Kscope 17, use the discount code IARCH and save $100 off your registration.  While you are there, come check out his presentation, “The EPM Clouds are Rolling in Fast! Is It Really Worth Upgrading My On-Prem System Now?”

We hope to see you in San Antonio in June!

So with Kscope 17 just around the corner, we thought we would do a Flashback Friday to Kscope 15 when Joe presented the following to a standing crowd only in Hollywood, Florida:

 “How Healthy Is Your Oracle EPM/Hyperion System Environment? (a.k.a. Is the Check-Engine Light On?)”

Kscope15-CoverSlide

Listen to the full presentation on our new iArch Solutions YouTube Channel:

 

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: January 17, 2017
  • Article by: Joe Malewicki

untitled     iArch Solutions is happy to welcome 2017 with lots of exciting news.  January marks the 20th anniversary of Joe Malewicki working within the Oracle EPM/Hyperion software space.  It is this long-standing knowledge that gives clients the confidence, in both Joe and iArch Solutions, to tend to their Hyperion infrastructure architecture needs.  January also marks the 4th anniversary of  iArch Solutions.  Joe Malewicki, Principal owner, took a leap of faith 4 years ago, and has continued to service clients with the utmost knowledge and attention to their needs.  It is this combination of strengths that keeps clients coming back for our work.  As we continue to add the most experienced technical staff year after year, we strive to consistantly provide the best infrastructure services to our current and future clients.

As we previously mentioned, iArch Solutions is very excited to be hosting a booth at this year’s Kscope 17 conference. Well, we recently found out that our founder, Joe Malewicki will also be a presenter at Kscope 17 in June.  We are now less than 6 months away from Kscope 17, and there is lots to do to get ready for our exhibit… we think it will be the best at the conference!  Thinking about heading to San Antonio for the conference, use our discount code IARCH and receive $100 off your registration.

Looking forward to seeing you in June!

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: 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 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

Blog Details Page

  • Date: June 24, 2016
  • Article by: Joe Malewicki

Over the last few weeks Oracle has announced the release of three Patch Set Updates for multiple products.  There was one for Oracle Hyperion Calculation Manager 11.1.2.4.006, one for Hyperion Profitability and Cost Management 11.1.2.4.121 and one for Hyperion Essbase 11.1.2.4.010.

iArch Solutions is offering you a FREE, no obligation (yes we said FREE) Patch Analysis of your mission critical Oracle EPM/Hyperion Financial System of software.

So what are you waiting for?  Let’s jump on a quick web conference and we will perform an analysis of your system.  We will let you know which patches are missing and should be considered for application so that your Oracle EPM system is able to be the most stable, secure and best performing environment possible.  You have nothing to lose, so give us a call (203-880-4268) and schedule your free Patch Analysis today!

Check out the link below to see the prerequisites and additional information about theses PSUs.

https://blogs.oracle.com/proactivesupportEPM/entry/psu_essbase_11124010

 

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: June 24, 2016
  • Article by: Joe Malewicki

Over the last few weeks Oracle has announced the release of three Patch Set Updates for multiple products.  There was one for Oracle Hyperion Calculation Manager 11.1.2.4.006, one for Hyperion Profitability and Cost Management 11.1.2.4.121 and one for Hyperion Essbase 11.1.2.4.010.

iArch Solutions is offering you a FREE, no obligation (yes we said FREE) Patch Analysis of your mission critical Oracle EPM/Hyperion Financial System of software.

So what are you waiting for?  Let’s jump on a quick web conference and we will perform an analysis of your system.  We will let you know which patches are missing and should be considered for application so that your Oracle EPM system is able to be the most stable, secure and best performing environment possible.  You have nothing to lose, so give us a call (203-880-4268) and schedule your free Patch Analysis today!

Check out the link below to see the prerequisites and additional information about theses PSUs.

https://blogs.oracle.com/proactivesupportEPM/entry/psu_essbase_11124010

 

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