Hyperion EPM Week In Review: August 24, 2016

HyperionEPMWeekInReviewSo…it’s technically Wednesday.  Next week I’m totally shooting for Monday!

Hyperion EPM Patches and Updates:

No updates…

Hyperion EPM Blog Posts:


Tim has an extremely technical (and awesome) post on maintaining aggregate views after adding a dimension to an ASO cube.  This is great for those of you adding a dimension and ties in nicely with his last post.

Jason has a pair of posts this week.  His first novel post is about Dodeca’s dynamic grouping functionality with relational data.  And while he is on the topic of relational data, he has another post about his Virtual Essbase JDBC driver (Vess) and Dodeca for the purpose of subvar management.  Lot’s of great content.

Tim has a great post on using some of the often overlooked functionality of MDX.  He focuses on dimension properties and the PROPERTY_EXPR function.

Harry has a new version of his cubeSavvy tool…in Russian.  His post is also in Russian.  I had to translate the post to make sure it was what I was expecting…

Sibin has a pair of posts this week as well.  First he shows us how to install ODI 12c in standalone mode.  Then he covers a migration problem with LCM in PBCS related to FDMEE.  This is related to source systems not being created.

Kyle has a great set of slides about PBCS.  These are really cool info-graphics that I plan on stealing borrowing for my own use. 😉  Remember…Kyle is awesome, so always give him credit for his amazing contributions to the EPM Community.

Ricardo has his first part in a series on some of the new features in ODI 12c.  He’ starting off with Dimension and Cubes.

Summer has a great post on deleting orphaned users from the Planning Repository.  I’m actually working on an in-depth article on the topic of how security is stored in the Planning Repository, but her use is probably more widely useful than mine.

Opal, not to be outdone, also has a pair of posts this week.  First she covers her journey of going from the “check-in” to a “carry-on” bag.  I now know far too much about her toiletries…but otherwise a cool non-EPM topic.  She also has the final post in the year-long ODTUG Member Series.  So go find out about Jayson and his drones.

Cameron has the second part of his series on Dynamic Load Rules in Essbase.  And Glenn, we can never have too much content out there…even on Dynamic Load Rules.

Celvin has an update to his NUMSysCMDLauncher utility that adds some great functions around user security.  Clearly I need to get to know Celvin more so I can get him to add cool functions to his already cool tools for me.  Perhaps I can have him add a -ForBrian?  Just a thought Celvin!

John has a post for those of you running Essbase 12c.  Don’t stop reading yet!  This will eventually apply to, Oracle is just a little…behind on adding that into Provider Services.  The functionality in question?  Smart View and Runtime Subvars with Calc Scripts.

Jake has Groovy new post on using the REST API’s in PBCS with LCM.  As we have come to expect from a Jake, a very thorough and detailed post with a ton of great ready-to-steal content.  My question is…do I really need EPM Automate if I have mastered the REST API’s?  Also…I wonder if the REST API could let us clear ASO regions?  So many fun and interesting questions…so little time.  Oh, and don’t miss Jake at Oracle Open World this year!  He will be in the Moscone South, Room 303 on Sunday, September 18th at 1PM.  His presentation will cover Hybrid Essbase.  Chances are, after you attend you will be an expert.

Gary tells us how to disable annoying upgrade messages in Smart View when connecting to HFM  Note that this only applies to HFM, not Planning, Essbase, or any other Smart View connectable product.


Another quick shout out for the ODTUG GeekAThon.  For those of us real geeks out there, they have a competition worthy of the maker community.  You can find the announcement here.  You can find the competition website here.  And a quick re-cap:

GeekAThon Announcement

GeekAThon Competition Website

A few important dates for those of you interested:

You must register by August 15, 2016, at 11:59 PM Pacific Time.

You must submit your video entry by September 23, 2016, 11:59 PM Pacific Time.

You must submit your solution document by September 23, 2016, 11:59 PM Pacific Time.

And for those of you who need a visual to assist in your procrastination, the red are the days past as of this post.  The green is the day you should be ready for, but will likely need to work right up until 11:59 to meet. 😉




Now go build something awesome!

Hyperion EPM Week In Review: August 16, 2016
Hyperion EPM Week In Review: August 29, 2016

Leave a Reply

Your email address will not be published / Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.