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

Hyperion Smart View – Essbase Shared Connection Changing or Vanishing

We have seen a few instances lately where some odd Smart View Essbase Shared Connection behavior has been popping up in version 11.1.2.1. In short, most administrators prefer that there be one Essbase server linked to the Essbase connections in a Smartview Shared Connection. However, an issue has been experienced where other servers in related environments…

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