Essbase Act! Excel Ribbon

Download Essbase WorkFlow Ribbon Excel v10.1 

installation   process

How to change XLAM VBA project

Quick Connect. Storing connection credentials in the Excel page, automatically log on if it needed








Adhoc functions and option in one place




Query Designer, Execute  MDX, Calculation,Manage Substitution Variable




Execute MDX: Can use variables, Auto Connect (if needed ), Run all query from the current Excel file.










Substitution Variables: view and edit










Calculation: Run external HTA VBScript program to unlock Excel during execution









Outline- Automatically open “OTL” page

CopySheet – Copy current page to new. It is used for quick analyse some details with avoiding destroy source retrieve

Data Comments – link to LRO objects for input data notes.