ODTUG + NTxHUG @ Topgolf Tomorrow!

It’s time for a meet-up!  Tomorrow, December 1, 2016, join the ODTUG North Texas EPM/BI Meet-Up group as we co-host an event with the North Texas Hyperion User Group at Topgolf in The Colony.  We’ll get started at 3 PM and the first two bays will be sponsored by ODTUG!  You will have to buy your own drinks and food, but we’ll cover the bays until 6 PM.  Come enjoy the company of your local EPM and BI professionals as we play Golf poorly!


Date: Thursday, December 1, 2016
Time: 3:00-6:00pm (drop in anytime and look for our bays)

Location: Topgolf
3760 Blair Oaks Drive
The Colony, TX 75056

Here’s the meet-up info:



Hyperion EPM Week In Review? November 26, 2016

Welcome to the Hyperion EPM Week in Review!  And look at that…it has only been a week!
Hyperion EPM Week In Review

Hyperion EPM Patches and Updates:

Essbase has been released.  This is a nearly complete patch for the suite with everything getting a patch but EAS.

The December 2016 cloud updates are about to drop:

ARCS looks to have a few new features, including Transaction Matching.

EPRCS also gets an update in December.

FCCS will be getting another update as well.  This update includes new alternate hierarchy functionality in the Entity dimension among other things.

PBCS gets an update as well with a lot of new features around sandboxing and a new web-based version of predictive planning.  Also of note…workspace has an official date of death…December 2017.

PCMCS gets a few minor updates as well.

Hyperion EPM Blog Posts:

Opal has another post in his ODTUG Member Series.  This time she focuses on the former ODTUG Marketing guru, Lori Lorusso.

Sibin has a five-part series on using ODI to load data from a flat file into an Oracle table.  Check out part 1, part 2, part 3, part 4, and part 5.  He follows that series up with another ODI post on handling NULL values in ODI.

Peter has an extremely detailed post on conditional FIX statements in Essbase.  Love the details and explanation.

Jason hosted a webinar this week on the Dodeca Excel Add-In.  This is a pretty cool tool for all of you out there that either refuse to make the move to Smart View or have VBA code preventing the move.  Jason also has an update on his Thriller MDX over JDBC driver.

Cameron has a great post on migrating an Essbase database to the cloud using PBCS.

Keith has an update to the FDMEE framework that he has been working on.  He has updated the logging functionality to be in line with PEP 8.

Tim tells us Happy Thanksgiving along with some kind words from a Dodeca Excel Add-In user.

Glenn gives us a few highlights from the Essbase patch that was just released.  Sounds like we should all get patched up…

Rodrigo has an ODI post as well this week.  He continues his series on Dimensions and Cubes in ODI 12c with part 3 on Settings for Surrogate Keys.

Hyperion EPM Month In Review? November 18, 2016

Welcome to the Hyperion EPM Week Month in Review!  I can’t believe it has been almost a month since my last post.  With the holidays upon us, I can’t say for sure that I’ll keep up with the weekly posts going forward, but I’m certainly going to give it a shot.  Here we go!
Hyperion EPM Week In Review

Hyperion EPM Patches and Updates:

Hyperion Financial Clost Management has been released.  They removed reduced the reliance on SOA in this release.  I guess its a step in the right direction, but a long way from where we all hoped it would be.

Hyperion Disclosure Management has been released.  That’s about all I know about that…

The November 2016 Update for ARCS has been released.  More here.

The November 2016 Update for FCCS has been released.  More here.

The November 2016 Update for EPRCS has been release.  More here.

The November 2016 Update for PBCS has been released.  More here.  The dropping of support for the desktop FR studio is of particular interest.  Really?  Ugh…

The November 2016 Update has been released for PCMCS.  More here.

Hyperion EPM Blog Posts:

Cameron shows us how to work around a bug that’s been around for a long time.  FIX statements and shared members.

Tim shows us that query logging can really cause performance problems.  Beware!

Keith has a few posts.  He covers JConsole with ODI and some OutOfMemoryError’s.  He also announced JunkieFramework.  A framework for FDMEE development…interesting stuff.  He then asked for everyone to help collaborate with the framework.  All of these tools are only better with the community being more involved…so get involved!

Pete has a post on subvars and using them to hack data forms.  I hadn’t noticed some of the improvements to the PBCS side of things as it relates to subvars.  Good read.

Sibin kept busy while I was backlogged in my posting.  Here’s a quick re-cap:

Dmitry continues his datamining series.

Jason has a few posts.  He covers custom landing pages in Dodeca.  He keeps with  the Dodeca theme and covers multiple applications.  Did I mention Dodeca?  Jason did…this time covering Tenants.

John Goodwin shows us a way to run FDMEE data load rules from inside of a task list.  Groovy!

Another Tim laments the fact that Essbase feature adds are few and far between right now.

Francisco has been busy too.  He has a post about extracting YTD balances.  Next up…a pair of code snippets: logging fdmContext values and script code based on EPM environment.

Dayalan starts off a series about the EPM Automate Utility.

Sarah has completed another Ironman.

Ludovic has a pair of EPBCS posts:  Part 1 and Part 2.

Vijay shows us how to filter exports to remove duplicates in DRM.

Doug shows off the new functionality in FDMEE in FCCS for Multi-Column data files.

Opal has a few posts from the cloud.  Or is it about the cloud?  First she has a quick tip on EPBCS/EPC and how you should always log out.  She also covers PBCS administrator settings.  Last, but certainly not least, she covers the notable updates in the Oracle EPM cloud for November.

Other Stuff

In other news, thanks largly in part to my amazing blog post his qualifications, Jake Turrell has been elected to the ODTUG board of directors!  Congrats Jake!