Year-to-date report? Try the FR Match function!

Viewing current period vs. quarter-to-date vs. year-to-date is a common layout used in financial reports.   Often this layout is managed using substitution variables that automatically pass in the current period / QTD / YTD members.   Or you could use range functions with hidden columns to retrieve additional periods and then sum them up for presentation…

Read More

Planning Form Design Consideration: Dense and Sparse in rows

We all know that traditional BSO-based Hyperion planning forms have the best performance when you can keep your sparse dimensions in the Page and Point of View, and use dense dimensions in rows and columns.  Particularly if you're using relationship functions in the row or column expansion, such as Descendants or Children.   But there may be times…

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

Hybrid Essbase Technology: Food for Thought

With several hybrid Essbase implementations under our belt at eCap, we thought we’d share some general info, tips, and tuning thoughts for using hybrid applications successfully. Hybrid Essbase General Info As of version 11.1.2.3.500, hybrid can be enabled on any Essbase or planning application by assigning ASODYNAMICAGGINBSO APPNAME [DBNAME] NONE|PARTIAL|FULL in the essbase config. Turning…

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