Getting Query on Daily basis are there any shortcuts for smartview except writing Macros – so thought of writing this blog.
Oracle has several extensions and utilities to make your Hyperion Smart View navigation simple and more efficient. There are a variety of Power Pack downloads that can be used to enhance or extend Smart View to save time and make navigation more manageable.
Download and launch the msi installation on a Windows machine with Hyperion Smart View 11.1.2 or above installed along with Office 2003, Office 2007 and Office 2010.
Once installed, each extension can be enabled or disabled:
Note to Install unzip the file and copy and paste all dll files to your smartview installation folder – C:\Oracle\SmartView\Bin or respective Installation path depending upon environment.
To access the extensions, go to the Hyperion Smart View Panel Home dropdown, select the extension to use:
Power Pack Adjust Data Extension
Simple data adjustment panel for use with Hyperion Smart View. This allows the user to select multiple cells and do simple addition, subtraction, multiplication, division. In addition, it allows for increasing or decreasing cells by a percentage. All data adjustment features work in cells whether the Smart View connection is active or not. Compatible with Smart View 11.1.2 and above.
Power Pack Quick Options Extension
This will allows the user to quickly change the most common options for Hyperion Smart View rather than launching the options dialog. Default options can be set or restored at any time. Compatible with Smart View 11.1.2 and above.
Power Pack Table of Contents Extension
Displays open workbooks and worksheets organized by connection type. Sheets can be sorted by sheet name, book name, or connection. This will also allow users to see if workbooks or worksheets are connected. Compatible with Hyperion Smart View 11.1.2 and above.
Power Pack MDX Script Library Extension
This allows users to view and launch MDX scripts stored on their local machine. Run MDX scripts and use them as a starting point for new queries. Results can be used for a starting point for new Essbase queries. Compatible with Hyperion Smart View 11.1.2 and above.
Power Pack Substitution Variables Extension
List and use Essbase substitution variables in ad-hoc operations. Compatible with Hyperion Smart
Power Pack Member Search Extension
Search for Essbase members in the Smart View panel without the need to open a dialog. Displays basic member information. Compatible with Hyperion Smart View 126.96.36.199 and above.
Power Pack Smart Chart Extension
Link native Excel chart to ad-hoc grids. The chart will update as you zoom or pivot. Compatible with Hyperion Smart View 188.8.131.52 and above.
Power Pack Grid Themes Extension
Format ad-hoc grids with pre-defined themes. Compatible with Hyperion Smart View 184.108.40.206 and above.
Smart View VBA Conversion Tool
Tool that will assist in the conversion of Legacy (Classic) Add-In VBA code to equivalent Hyperion Smart View VBA Code.
Please revert in case of any queries.