The End of the Time Scale Debate

By Brady Marr Senior Director, TM1 Practice eCapital Advisors For as long as I have been working in cube-based (OLAP) software, there has been a long running debate about whether to build your cube with a single continuous time dimension, or rather to separate into a Month dimension and a Year dimension. To describe the…

Read More

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