get Oracle SmartView plugin
I have started a new OpenSource project for creating Excel C# Addin to simplify user access to ODBC. Now this project has limited functionality but it is already useful for Excel data analytics.
- reduce level for involving analytics for creating SQL query
- remove middlemen between SQL data and Excel (use 3d part application with exporting data to CSV )
- real-time update data without steps in different tools
This plugin needs to use for Oracle Hyperion Cloud clients because it is simplified actions with removing unnecessary menu and buttons. All tools on one pane.
For installing , please , unpack and place file in2planning.xlam in the folder %userprofile%\appdata\roaming\Microsoft\AddIns. After that register plugin in Excel options.
Oracle SmartView also must be installed before setting up this plugin.
Unpack archive to the folder
If you use Essbase.Act ribbon and need to customise static MDX report with some parameters you need to create “TextBoks” named “MDXVaribales” and place it to a page with the report or to “OTL” sheet.