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

 

 

 

 

 

 

 

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.