Oracle Hyperion Enterprise Performance Management (EPM) System 11.2: On-Premise isn't dead after all!

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

Throwback Thursday – EPM Clouds Are Rolling In Fast!

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

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

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

Flashback Friday

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

The month of milestones…

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

Oracle has released 11.1.2.4 Patch Set Updates!

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

Giving Back: iArch Solutions is a proud sponsor of the Masuk Robotics Team

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

iArch Solutions LLC, a premier EPM Infrastructure Solutions company, is a proud sponsor of the Masuk Robotics team. The Masuk Robotics team is made up of 2 middle and 9 high school teams from Monroe, Connecticut.  This is the 8th season for the Robotics team, who work up to 12 hours a week outside of school on this endeavor.
“The children are being challenged to learn about robotics and related engineering topics by engaging them in higher order problem solving activities.”  Led by Mr. Bill McDonough, who was elected the Vex Robotics Connecticut Teacher of the Year in 2014, both of the middle school teams and 4 high school teams qualified for the Vex World Championships in Louisville, Kentucky this year.  The Masuk Robotics team is the only program in all of New England to qualify 2 middle school teams for the World Championships.
The 2016-2017 year program will have an estimated 90 High School members and potential another 80-90 Middle School members!  Hats off to the students and staff of this wonderful program!
 
Check out the link below on Vex Robotics and this coming year’s new competition:
 

 
To follow this great program, here is the link to their official social media pages:
Facebook: https://www.facebook.com/MasukHighSchoolRobotics
Twitter:  https://twitter.com/MasukRobotics
Interested in supporting America’s future?  Here is the sponsorship link for this great program!  100% of the proceeds go to the non-profit organization: https://drive.google.com/a/monroeps.net/file/d/0B9GxAdypu_b-eC05YzRqeDFUR28/view?usp=sharing
 
 

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

Essbase Studio Deployment Workaround

  • Date: May 16, 2016
  • Article by: Elysha Daly

When recently trying to deploy Essbase Studio, I ran into an issue where it would not create the Windows service because the password for the Windows Services install account contained one or more unacceptable characters.
Here are the steps I performed to work around this issue.
Start by re-launching the Configuration tool on the Essbase server.  This time be sure to choose “Configure Common Settings.”  Then click “Next.”
Pic1a
Deselect the “Run Windows Services as non-local system account” option. Then click “Next.”
Pic1
Now follow through the rest of the process of configuring Essbase Studio.  As you have already tried to configure Essbase Studio once, you will encounter the option to either “Drop and re-create Tables” or “Reuse existing database.”  I would choose to “Reuse the existing database.”  Click “OK” and then “Next.”
Pic2
Now continue with your configuration.  When you have completed the process, if you look at your deployed services, you will find that Essbase Studio has been deployed.  Please note, that it has configured to run as the “local system” account.
Pic3
It is important to go back to you services screen now and change the Essbase Studio settings manually.  So, right click on Essbase Studio and click on “Properties.”
Pic8
Select the “Log on” tab.  Input the correct windows account information and select “Apply.”  When you go back to your services screen, you will find that the Essbase Studio Service is no longer a local system service.  It will now be the windows service account that you previously input.
Pic6
The next step is to run the configuration tool again, this time, only select “Configure Common Settings.”
Pic4
Select to “Run Windows Services as non-local system account.”  Input the right domainusername and Password.  Then click “Next.”
Pic5
And now finish the rest of the steps in the configuration process.
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.

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