How I studied for and passed the Oracle Cloud Infrastructure (OCI) Architect Associate certification exam 1Z0-932 (the first time).

By | Certifications, Infrastructure as a Service, Oracle Cloud Infrastructure (OCI), Tips and Tricks | No Comments

Since I recently lived through the fun of getting myself Oracle Cloud Infrastructure (OCI) Architect Associate certified, I wanted to share a little information on how I prepared for the exam.  Please note, the opinions, words and views expressed in this article are ONLY a brain dump from my little techy head and there’s no guarantee that if you follow my…

Read More

What version of Oracle EPM/Hyperion am I running?

By | Best Practices, Tips and Tricks, Tips and Tricks, Troubleshooting, Uncategorized | No Comments

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…

Read More

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

By | Best Practices, Tips and Tricks, Blogs We Love, EPM System Installation and Configuration, Hyperion Financial Management, Oracle Hyperion Enterprise Performance Management - EPM, Pre-requisites, Tips and Tricks | No Comments

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…

Read More

Oracle Smart View Error After Applying Analytic Provider Services (APS) Patch

By | Best Practices, Tips and Tricks, Error Messages, Essbase Errors, Oracle Hyperion Enterprise Performance Management - EPM, Patching, Smart View Errors, Tips and Tricks, Troubleshooting, Uncategorized | No Comments

After applying Analytics Provider Services Patch Set Update (PSU) 11.1.2.4.006 we can no longer perform an adhoc analysis to an Essbase application.  The following error is thrown inside of Microsoft Excel with the Smart View add-in: Error: ————————— Oracle Smart View for Office ————————— com/essbase/services/olap/grid/EssGGridOption.setOptionSingleMbrPov(Ljava/lang/Boolean;)V ————————— OK ————————— Screen Shot of Error:   To confirm if there is an issue with the…

Read More

How To Create Microsoft Windows EPM/Hyperion Start and Stop Scripts

By | Best Practices, Tips and Tricks, Blogs We Love, EPM Presentations, EPM System Installation and Configuration, Oracle Hyperion Enterprise Performance Management - EPM, Tips and Tricks, Troubleshooting, Uncategorized, Utilities | No Comments

People to tend to think that creating a master start/stop script, which can span multiple servers, is a difficult task.  Some Hyperion consulting firms out there even like to charge for such a beast.  They also try to convince you that you need to purchase their “specialized custom scripts” or “compiled start/stop programs” to do the job.  This just isn’t so!  Remember…

Read More

Time for some Hyperion Spring Cleaning?

By | Best Practices, Tips and Tricks, EPM Hyperion Technical Infrastructure Services, EPM Presentations, New Releases, Patching, Press Releases, Tips and Tricks, Troubleshooting, Uncategorized | No Comments

  Well the first day of Spring has come and that means one thing, time for Spring cleaning! Not only do we need to do this in our personal lives, but professional too.  Now is the time to take a good look at your Hyperion Infrastructure and see if there are some potential problems brewing or maybe a way to…

Read More

How to use the Smart View Diagnostics tool

By | Best Practices, Tips and Tricks, Smart View Errors, Tips and Tricks, Troubleshooting, Utilities | No Comments

The Smart View Diagnostic tool is an invaluable piece of your troubleshooting abilities.  It allows the end user the ability to easily gather the necessary technical information to assist in solving difficult Smart View issues which might arise.  Once the information is obtained, it can then be sent to Oracle Technical Support for further analysis and hopefully lead to quick response and solution….

Read More