If you use Smart View, you are familiar with the Smart View Shared Connection URL, which is unique to the environment that Smart View connects. That property is saved in a file on your computer and has the default URL, as well as all the saves URLs in the drop-down list.
If you are a fan of the HSGetValue and HSSetValue, you probably are using a private connection. As you know, anybody that uses the template has to either change the connection string to their own predefined private connection, or set up a private connection with the same name. When dealing with inexperience users, both methods can be problematic.
You may be surprised to know that the Get and Set Value functions can use a shared connection.
If you have ever used custom functions in Excel, depending on the complexity of them, you have probably run into an issue where the accuracy of the results was sporadic. There is a quick solution.
In Hyperion 220.127.116.11, there is a change in how security is deployed. If you are having an issue deploying Planning security with Essbase adhoc access, and the user can’t
- Access Essbase Adhoc
- Access FR reports using an Essbase connection
- Access Essbase directly
you are not alone.
The newest release of Smart View (Release 18.104.22.168.102) includes many helpful, long-awaited features sure to both enhance the end-user experience and increase productivity. Many of the new features are examined below while a complete list and their descriptions can be found here.
Ad Hoc Operations in Multiple Cells
Previous versions of Smart View limited users to cell level ad-hoc operations. For example; say you wanted to ‘Zoom In’ on a member, Smart View limited this action to a single cell (single member). The newest version allows users to select a range of cells before performing an action allowing for quicker answers. Multi-cell actions such as Zoom In, Zoom Out, Keep Only and Remove Only are now permitted.
What’s new in Essbase 11.1.2? ASO updates, error and exception handling, dynamic write-back, and more!
Essbase users, with a little effort, can significantly reduce the unnecessary growth of Essbase databases.
Change the number of allowable rows returnable in SmartView