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

Hyperion and Windows 10 Compatibility

Since Windows 7 and 8.0 have both reached the end of mainstream support and the rest of Windows 8.x is slated to reach end of support January 2018, many IT departments are starting to evaluate Windows 10 as a new Enterprise standard.  With Windows 10 comes Microsoft’s newest version of Internet Explorer, Microsoft Edge.  While Microsoft…

Read More

Oracle PBCS Monthly Update – December 2016

The Oracle team at eCapital hosted another installment in the Oracle PBCS Monthly Update series on December 14th. As part of this series, our panelists highlighted the newest features within Planning and Budgeting Cloud Service (PBCS & EPBCS) that Oracle is releasing to the cloud.  For the December 2016 update, eCapital experts reviewed and tested…

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