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

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