The Planning Repository: HSP_ACCOUNT

Not to sound like a broken record, but…a few disclaimers: This is the fun stuff…that voids your warranty.  Not that you have to tell Oracle that you poke around here, but if you do, they will blame anything and everything that’s wrong on you for being in there. The content here has been tested and…

The EPM Week In Review: Week Ending April 16, 2016

This was a shorter week for me (vacation), so I may have missed some things.  If so, let me know so that I can update this post! Patches and Updates: The 11.1.2.4.102 Tax Governance Patch has arrived.  This one is totally out of my wheelhouse, so good luck! Speaking of things out of my wheelhouse,…

The EPM Week In Review: Week Ending April 9, 2016

This was a big week for patch releases and as always, a lot of a great blogging. Patches and Updates: The Essbase 11.1.2.4.008 patch finally hit the Proactive Support blog along.  Last week we were missing EAS, Studio, and APS.  This week we have them!  Sadly, this patch does not fix my client’s issue.  Oracle…

Parallel SQL Server Data Loads with ASO Essbase

If you have a ASO cube where timing is everything or a cube with multiple large data sets, waiting for data loads to process in series can waste valuable time. Luckily, Essbase supports parallel data loads! Sadly…while the documentation for this isn’t bad, it is inaccurate.  I’m sure it was accurate a few (or many)…

The EPM Week In Review: Week Ending April 2, 2016

The EPM community never seems to slow down with providing great content. Patches and Updates: Essbase 11.1.2.4.008 has been released.  It has not yet hit the Proactive Support Blog.  So here it is: Essbase Server 11.1.2.4.008 PSU 22674292 Essbase RTC 11.1.2.4.008 PSU 22674308 Essbase Client 11.1.2.4.008 PSU 22674304 Essbase Client MSI 11.1.2.4.008 PSU 22814465 It says this:…

Drillbridge: Enabling Upper Level Drill-through

In our last post about Drillbridge, we did the basic introduction and then ran through the steps to get it up and running. But, in the interest of simplicity, we kept it simple. Now we are ready to get a little more complex. For today, a little more complex will be upper level drill-through.  This…

PBCS April 2016 Update: FDMEE On-Premise Is Here, Kinda…

Another month…another update to PBCS.  This month we have a few very interesting items.  First, we have a new version of the EPM Automate Utility with a few new commands: copysnapshotfrominstance – This command can essentially replicate one instance to another.  This could make migrations a bit faster and more streamlined and possible less error…

The EPM Week In Review: Week Ending March 26, 2016

Because this is a 3-day weekend for many, I’m posting this a day early.  Also, today is the last day for early bird registration for KScope16.  So what’s new this week? Patches and Updates: DRM 11.1.2.4.330 has been released.  This includes a ton of new features and patches.  This patch as previously been released, but…

Hyperion and PowerShell: Executing Remotely

In our last PowerShell post, we covered using the Outline Load Utility with Hyperion Planning from PowerShell.  But, now we have MaxL scripts doing data loads and Outline Load Utility scripts doing meta-data loads and they are happening on two different servers. We need a nice way to join all of this together in a…

The EPM Week In Review: Week Ending March 19, 2016

This was a bit of a slow week…until it wasn’t.  Things picked up late this week. Patches and Updates: DRM 11.1.2.4.322 has been released.  Fixes a few bugs. Disclosure Management 11.1.2.4.200 has been released.  There appear to be quite a few bug fixes. The FDM to FDMEE Migration Utility V1.1 has been released.  Seems to…