Helpful Smart View Row Limit Settings

With many companies now updating to Office 365, we are seeing some Essbase clients needing to finally move away from the old Excel Add-in to Smart View.  At the same time we are seeing that the size of Essbase cubes are also increasing due the need for more detailed analysis. With these two evolutions of…

Read More

Valid Intersections in Hyperion Planning (PBCS)

Valid Intersections, only available in Planning and Budgeting Cloud Service (PBCS), allows for cross dimensional security in Planning. While this feature has been available for years in Essbase it is not until PBCS that this functionally is available in Planning applications. This feature can be extremely helpful when creating your security model and designing web…

Read More

MDX Series Pt 1: Your First Essbase MDX Query

Post #1: Connect to Sample.Basic and execute two basic queries Post #2: Introduce functions using a single dimension Post #3: Introduce multiple dimensions and CrossJoin Post #4: Define sets and tuples to add a deeper understanding of how MDX works Post #5: Discuss how to avoid almost all frustration using MDX in Smart View Post…

Read More

Oracle Financial Reporting Web Studio

In the last few months, Oracle has released a web version of the classic Financial Reporting Studio.  I am going to walk you through the new feature and show you how it compares to the desktop version that so many people have used for the last decade. This is great for people that want a…

Read More

Oracle’s PBCS and the Sandbox Feature

In this post, I will explore one of Oracle’s latest updates to their Planning and Budgeting Cloud Service (PBCS) offering, Sandboxes. With Sandboxes, you can enable multiple dynamically created versions that the planners can alter within the context of the form they are viewing. If they like what they see, they can then publish those…

Read More