There is the new version of Essbase Act ribbon released.
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
NOASK
MEMBER_NAME*/