get Oracle SmartView plugin
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
What to do if you stay alone with face to SmartView ?: