get Oracle SmartView 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.
in this new version have added a lot of new functionality
link to separate calc script execution and MDX variable placed on a local file.
For running MDX on all Excel book pages place this command in the comment section on “OTL” sheet.
/* SELECT FROM ALL_SHEETS