The EPM Week In Review: Week Ending May 28, 2016
Clearly people are finishing up their KScope content, because this was a pretty busy week. Patches and Updates: FCM 11.1.2.4.103 has been released. The June update to PBCS appears to have been delayed until July. <Insert Angry Face Here> More on this as it becomes available. New Blog Posts: I finally got a blog post in! Not only that, but I’ll probably have another one next week! This week began the months-in-the-making Essbase Performance Series! You might be able to tell by the number of exclamation points used that I am excited about this series… Jason shows us how to create drillable columns in Drillbridge. Great post…that was totally on my list to blog about! Granted, that list is a mile long and growing. Amit shows us how to use FDMEE, Oracle EBS, and multiple Accounting Entity Groups. This makes for a cool combination. Robert has a great post on FDMEE and Hybrid Cloud. I’ll be referencing this on occasion. Celvin has a post about his new OTN article on configuring AD security with PBCS.
Essbase Performance Series: Part 1 – Introduction
Welcome to the first in a likely never-ending series about Essbase performance. To be specific, this series will be designed to help understand how the choices we make in Essbase hardware selection affect Essbase performance. We will attempt to answer questions like Hyper-Threading or not, SSD’s or SAN, Physical or Virtual. Some of these things we can control, some of them we can’t. The other benefit of this series will be the ability to justify changes in your organization and environment. If you have performance issues and IT want’s to know how to fix it, you will have hard facts to give them. As I started down the path of preparing this series, I wondered why there was so little information on the internet in the way of Essbase benchmarks. I knew that part of this was that every application is different and has significantly different performance characteristics. But as I began to build out my supporting environment, I realized something else. This is a time consuming and very expensive process. For instance, comparing Physical
The EPM Week In Review: Week Ending May 21, 2016
This week was a little slow, much like last week. Unfortunately, Oracle didn’t have any new product releases to keep things interesting. Patches and Updates: None! New Blog Posts: This week I STILL didn’t manage to get a post in. I promise that will change next week…i have one ready to go, I just want to add one more thing to it. Vijay shows us how to use Dynamic SQL in ODI. I don’t know that anything in ODI is simple, as he suggests. Opal has a quick tip for Oracle cloud users. Everything you ever wanted to know about changing your password. Cameron gives us the last in his 15 part series on PBCS. This one covers batch automation and compares PBCS to on-prem. Jason shows off a feature in Dodeca that we all hope one days makes it to Planning. Dependent Selectors! Come on Oracle, catch up to Tim Tow! Gary shows us some screenshots of what he thinks might be a next iteration of EAS. I’ve heard rumors that we will see
The EPM Week In Review: Week Ending May 14, 2016
This week we are a bit more timely! It does however seem that everyone is preparing their 1st drafts for Kscope, as it was a really slow blogging week. Luckily, Oracle offset that slowness with the release of two new products in the cloud. Patches and Updates: Oracle has finally released Enterprise Planning Cloud (formerly ePBCS). This is PBCS with all of the modules that we’ve had on-prem for a long time. Except…it isn’t. They have taken all of our modules and attempted to wizardize them. More on this soon. Oracle also released Financial Consolidation and Close Cloud (formerly FCCS). This is not HFM in the cloud, but an entirely new tool, based on Essbase that can be used for consolidations. New Blog Posts: I didn’t manage to get a post in this week as I’ve been heads down on both a metric ton of client work, and laying the foundation for a new blog series. More on this next week… Gary has a pair of posts this week. First, a post on using VBA
The EPM Week In Review: Week Ending May 7, 2016
Welcome to a very late edition of the EPM Week in Review. Plenty of great stuff this week…sorry for the delay! Patches and Updates: FR 11.1.2.4.701 has been released! It brings with it features from the cloud like the Web Reporting Studio and charts that don’t look like they came from Lotus 1-2-3. I’m excited to get this one installed next week HFM 11.1.2.4.201 has been released. While not as exciting as the FR patch, it does fix a lot of bugs and the security issues…if you follow the instructions very, very carefully. Neither of these updates has made it to the Proactive Support blog. This is why everyone in our space should have a Twitter account. New Blog Posts: This week I posted about Drill-Through in PBCS and Hyperion Planning Without FDMEE. Gary covers the topic of limiting users in Smart View. He covers the different products and their own governors beyond just the APS governors for Smart View. Amit gives us his summary of the upcoming June PBCS update. This monster of an update
Drill-Through in PBCS and Hyperion Planning Without FDMEE
While recently debugging an issue with FDMEE, I needed to test drill-through in Hyperion Planning without using FDMEE. But wait…can you even do that? I had always planned on showing how to use Drillbridge with Hyperion Planning, but as I was talking with Jason, he mentioned we could even get it working in PBCS. So how does this work? Let’s start easy with Hyperion Planning. If you happen to read Francisco’s blog, you may have already read this post about FDMEE drill-through. It actually tells us that FDMEE just uses the Essbase drill-through definitions. This happens to be the exact functionality that Drillbridge uses. As it happens, if we set up drill-through on an Essbase cube that supports Planning, it just works. See…easy. But let’s try it with the Vision cube: I’ll spare all of the details of the Drillbridge setup, but we’ll cover a few specifics. First we’ll set up a test deployment specification: So you can use all of your regular functions here, but I wanted to keep it super simple for testing purposes.