Download Essbase WorkFlow Ribbon Excel v11.5
How to change XLAM VBA project
How to implement SmartView VBA API
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.
Calculation Manager:
1) External HTA VBScript program used to unlock Excel during execution
2) Chose cube for current calculation
3) Change Substitution variables for current database
4) Create Calculation sequence for recalculating scripts between databases
Other:
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.