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

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

MDX Series Pt 5: Smart View Does More Than You Think

MDX Series This is post number five in a six-post series. A brief overview of the series: 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…

Read More

Error Handling in Smart View Queries

I often hear new Smart View users concerned about properly formatting their queries or ensuring the member names are correct.  In this post, I will discuss the “Enhanced Comment Handling” feature in the Smart View options.  When selected, this option prompts the user to resolve errors whenever an ad-hoc refresh has invalid members in the…

Read More

Custom Styles on Hyperion Planning Forms

Planning web-forms through the Smart View Planning connection often have better formatting than an Essbase ad-hoc connection. Planning web-forms have the blue-shaded metadata, the grey-shaded non-writable data cells, and the yellow-shaded writeable data input cells. In addition, the form layout (POV, Page, Row, and Column members) generally focuses on a business requirement. But there are…

Read More