It’s that time again…the EPM Month in Review. February was just as active as January with another 44 contributions from our great community.
Gary tells us about a new feature in Smart View 11.1.2.5.620. He also has an in-depth look at the Query Designer in Smart View.
Cameron has the results of his Smart View Survey. He also has a tip on installing just Excel 2016 instead of the entire 2016 suite of Office products. Cameron also brings us a great post on backing up your on-premises applications. Finally, he suckered Chris Rothermel into providing us with a great guide on backing up your cloud-based applications.
The DEV EPM crew tells us about the newly release Oracle Data Integrator Cloud Service (ODICS). I can’t be the only one saying that acronym out-loud right?
Neha provides public service announcement regarding a bug in Planning 11.1.2.4.005. Amit shows us a cool was to pass run-time prompts from Planning to a MaxL command rebuilding a partition.
Summer has a quick tip on the possibility that a cube refresh could fix issues in PBCS.
Eric tells us about the HFM 11.1.2.4.204 patch that was recently released. He also shows us how to view metadata properties inside of HFM (but not Smart View).
Sibin gives us a lengthy series on installing the Hyperion EPM stack in a distributed environment:
Sibin also continues his journey with the Essbase application logs. He finished off the month with another installation related post relating to a failure.
Glenn has an interesting post about FCCS and issues relating to data storage. This particular issue is not unique to just FCCS. I’ve had this exact issue occur one time before on a PBCS implementation as well.
I had a post on Parallel Data Loads in Essbase BSO cubes.
Jason asks if we’ve ever wondered what the difference is between JDBC and JNDI connections is? He has another post as well on advanced Essbase features in Dodeca.
John continues his series on the FDMEE Hybrid Update. He also has a post on loading Planning meta-data using FDMEE.
Celvin takes a break from Groovy to talk about PBCS and hierarchy driven Smartlists. He then continues his Groovy series with Part III and Part IV.
Sarah shows us how to get past an issues with the BICS Data Sync configuration.
Henri tells us about end of days for the FR Desktop Studio. Mid-2017 is coming up quick!
Ludovic gives us a run-down of the updates in February 2017 PBCS release.
Eric takes a deep dive into the new ODICS offering from Oracle.
Vijay has a pair of posts. First he covers DRM Pivots. He sticks with DRM as a topic showing how to execute the DRM Batch Client from remote servers…without anything fancy. Pretty cool…
Pete shows us how to execute shell commands in MaxL using the CalcMgrExecuteMaxLScript CDF. He also shows some of the differences between EAS and Calc Manager as it relates to validating code.
Tim gives the Dodeca support team an e-high-five.
Tony walks us through the process of enabling dynamic member creation in PBCS and Planning.
Opal gives us a recap of the RMOUG Training Days 2017 event in Denver. She also has a post about John Wick 2? Ok, so there may be something about EPM in there too…but mostly John Wick 2.
Brian Marshall
March 3, 2017
Welcome to the second installment of the Hyperion EPM Month in Review. This month was pretty busy with 44 contributions by the community (45 if you include this post).
Gary has a quick update letting us know that the Smart View 11.1.2.5.620 has been released.
Cameron has a pair of posts this month. First he held Chris Rothermel hostage until he created a post that shows us how to delete multiple files with EPM Automate. Next up, he shows us around the new EPM Cloud Documentation Portal.
The DEV EPM crew starts off 2017 with a post covering 2016. They also tell us that they will be at Kscope17! They also have an OTN article on Building a 100% Cloud Solution with Oracle Data Integrator.
Eric gives us a look at the new Oracle Data Visualization Cloud Service. On the other end of the spectrum, he has a post about locking entities. This is a functional and technical question all rolled into one.
Sibin had another busy month of blogging. I wish I had the time or energy to blog as much as he does! He starts off the year talking about text members in Hyperion Planning. He then runs us through his experience using SQL Data Load Rules in Essbase and the error he encountered with Oracle DB. He also takes a look at the backend repository for Shared Services. Sibin also put together a cool Essbase log parsing shell. He then covers FDMEE logic accounts…twice. Finally, he has a post on installing the Hyperion EPM stack on Linux.
Glenn has an interesting post about FCCS and issues relating to data storage. This particular issue is not unique to just FCCS. I’ve had this exact issue occur one time before on a PBCS implementation as well.
I started the year off with a few posts. First I wished everyone a very belated Happy New Year. Then I started the new EPM Month in Review series with the December 2016 update. I will also be at Kscope17! I also started a new series talking about what’s up in my lab. And lastly, and most importantly, the next NTxHUG Meeting has been announced for February 16th.
Jason clearly has too much time on his hands like Sibin, giving us five blog posts this month! First, he shows off some Dodeca skills by having multiple Essbase sources in a view. Next up, he talks about renegade members in Essbase. He also has an update to his Hyperion Parent Inferrer app. Chris clearly made an impact with his post on Cameron’s blog, as Jason had to go and do his very own post on the topic from another angle: deleting multiple files from PBCS using EPM Automate PBJ. He finishes off the month with a post on Drillbridge and query translation.
John continues his awesome content to start off the year the way he ended it. He has part two of his series on FDMEE and the REST API. He also started a new series on the FDMEE Hybrid update.
Francisco gives us part two of his series on the 11.1.2.4.210 patch for FDMEE. He has a three-part series on the UDA for SAP HANA: part 1, part 2, and part 3. He also has a great extension to John Goodwin’s series on FDMEE and the REST API. He shows us how to execute custom scripts with the REST API in FDMEE.
Dayalan has a post showing the new functionality added to the PBCS Access logs. Looks like you can now download daily logs. Cool advances in the cloud. He also tells us a little about the 17.02 patch for PBCS that his this Friday (in test).
Celvin has a new multi-part series this month on Groovy in PBCS and On-Prem Planning. Here are part 1 and part 2.
Sarah takes a look at a cool new Oracle tool named Synopsis. She gives us part one her on-going series showing off this new mobile tool for analyzing CSV and Excel files on the go. She also takes a look at the new Quadrant Visualization plug-in for ODV.
Eric gives us the heads up on a variet of upcoming events and webinars.
Tim tells us that the Oracle Essbase Cloud Service (EssCS) webinar is now available. Apparently the soon part of coming soon is getting sooner…
What if the world is a prototype?
Christian has released a new version of his Tools-EPM utility for Linux and Unix! Previously this was only available for Windows.
Opal has a pair of posts this week. First she has a quick tip on Financial Reports that don’t appear after migration. She also has a big thank you to the 2016 ODTUG Marketing Committee. We all appreciate the efforts of all of the committees that make ODTUG a great community with many great events and contributions.
Brian Marshall
January 31, 2017
The Hyperion EPM Week in Review has clearly become more than I can manage on a weekly basis. So, I’ve decided to do a monthly update for the time being. If things slow down, I’ll get back to a weekly update. So, welcome to 2017 and the review of Hyperion EPM in December of 2016!
As part of this change I’ll also be structuring the posts a little different. Because over the course of a month many of us post more than once, I’ll be adding sub-heading for each of the contributing blogs along with a link to their main site. I welcome any feedback everyone has.
Garry had three posts last month. First he announced that he was selected to present at KScope17. Congrats Gary! He also lets us know about the new 11.1.2.4.704 patch for Financial Reporting. This is a particularly important update given that Oracle will no longer support the desktop client soon. While he’s updating us on patches, he also has a post about the new 11.1.2.4.210 patch for FDMEE. This includes a whole host of new features including text-based data loads.
Cameron gives us the update on the most resent Boston meetup. It looks like a lot of fun was had!
The DEV EPM crew continues their series on Dimension and Cubes in ODI 12c. The topic of the day is loading data using surrogate keys.
Keith has a post on extracting UDA’s…using Python.
Eric, much like Gary, as a post on the 11.1.2.4.704 patch for Financial Reports. This seems to be a popular topic.
Sibin had another busy month of blogging. He starts off by taking a peak at the backend tables of Shared Services. He then moves on to showing us how to create a relational data source for an Essbase rules file…on Linux. Speaking of Linux, he also has a guide on installing HFM on Oracle Linux. I’m pretty sure this is only supported on Exalytics…but hey, cool guide.
Jason has a re-cap of his most popular blog posts of 2016 to finish out the year.
John continues his awesome content to finish off the year. He has a post on loading data to multiple years and periods with FDMEE. He also has part one of his series on FDMEE and the REST API.
Francisco has a post on the 11.1.2.4.210 patch for FDMEE at a glance. He the digs deeper into the patch.
Dayalan has a post on loading data into PBCS using the HsSetValue and HsGetValue functions.
Celvin, who I had the privaledge of hanging out with over the holidays, has a number of posts in December. He has an amazing family and it was great to spend some time away from Kscope with some fellow Oracle nerds.
First he has a tip on ADFS Federation and Signing Certificate issues. Next up he has a quick tip on deleting members and shared members more rapidly in PBCS. Finally, he has a post on adding a time value to a webform.
Sarah has a post on error 10058 in Data Visualization Desktop (DVD). While on the topic of DVD, she also covers plug-ins.
Eric has a great post showing off the new and hopefully eventually released Essbase Cloud Service.
Opal has a post on opening up more than one instance of the Oracle EPM Cloud.
Brian Marshall
January 17, 2017