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.
Borchuk Leonid :
We faced with quite a strange pattern in behavior of our essbase application. I have a special essbase monitoring MDX query that calculates a single value in a Hybrid mode. Here it is:
Continue reading “What is the best processor for Hybrid?”