Functionality

Supported

Notes

Retrieve

x

Keep Only

x

Remove Only

x

Zoom In

x

Zoom Out

x

Pivot

x

Navigate Without Data

x

Sample Data

Linked Objects

Query Designer

Flashback

x

Implemented as Undo/Redo with multiple levels of undo and redo.

Options

x

Member Selection

x

Currency Report

Cascade

Retrieve & Lock

Locks are automatically applied upon the update request

Lock

Locks are automatically applied upon the update request

Unlock

Locks are automatically applied upon the update request

Send

x

Locks are automatically applied upon the update request

Calculation

x

Connect

x

Disconnect

x

Function

Supported

Notes

EssMenuVConnect

x

EssVConnect

x

EssMenuVDisconnect

x

EssVDisconnect

x

EssMenuVRetrieve

x

EssVRetrieve

x

EssMenuVZoomIn

x

EssVZoomIn

x

EssMenuVZoomOut

x

EssVZoomOut

x

EssMenuVKeepOnly

x

EssVKeepOnly

x

EssMenuVRemoveOnly

x

EssVRemoveOnly

x

EssMenuVPivot

x

EssVPivot

x

EssMenuVSend

x

EssVSendData

x

EssMenuVRetrieveLock

x

Retrieves only; does not lock cells

EssMenuVLock

x

Does not lock/unlock cells; always returns success

EssMenuVUnlock

x

Does not lock/unlock cells; always returns success

EssVUnlock

x

Does not lock/unlock cells; always returns success

EssVGetGlobalOption

x

"The following global options are not supported: 4 (Enable retain member selection information setting), 5 (Specify message level setting), 7 (Enable route messages to log setting), 8 (Enable purge log setting), 9 (Enable double-clicking to browse Linked Reporting Objects setting), and 10 (Display Member Select Save dialog box setting)."

EssVSetGlobalOption

x

"The following global options are not supported: 4 (Enable retain member selection information setting), 5 (Specify message level setting), 7 (Enable route messages to log setting), 8 (Enable purge log setting), 9 (Enable double-clicking to browse Linked Reporting Objects setting), and 10 (Display Member Select Save dialog box setting)."

EssMenuVOptions

x

EssVGetSheetOption

x

"The following sheet options are not supported: 15 (template retrieve mode), 16 (free form mode), 17 (auto sort rows), 18 (use styles), 20 (not supported in classic add-in), 21 (retain on keep only/remove only), 22 (retain on zoom), 23 (formula fill), 26 (query designer), 30 (metadata sampling), 31 (not supported in classic add-in), 32 (metadata sampling percentage), 33 (non-unique qualified name in cell comment), and 34 (non-unique qualified name in spreadsheet)"

EssVSetSheetOption

x

"The following sheet options are not supported: 15 (template retrieve mode), 16 (free form mode), 17 (auto sort rows), 18 (use styles), 20 (not supported in classic add-in), 21 (retain on keep only/remove only), 22 (retain on zoom), 23 (formula fill), 26 (query designer), 30 (metadata sampling), 31 (not supported in classic add-in), 32 (metadata sampling percentage), 33 (non-unique qualified name in cell comment), and 34 (non-unique qualified name in spreadsheet)"

EssMenuVCalculation

x

EssVCalculate

x

EssVCancelCalc

EssMenuVCascade

EssVCascade

EssVCell

x

EssMenuVFlashBack

EssVFlashBack

EssVGetDataPoint

x

EssVFreeDataPoint

x

Always returns success due to architecture

EssVGetMemberInfo

x

EssVFreeMemberInfo

x

Always returns success due to architecture

EssMenuVMemberSelection

x

EssMenuVDatalessNav

x

EssMenuVCurrencyReport

EssVGetCurrency

EssVSetCurrency

EssVGetStyle

EssVSetStyle

EssVGetHctxFromSheet

EssVLoginSetPassword

EssVSetMenu

EssVSetSKUMouse

EssMenuVLaunchTableau

EssMenuVLinkedObjects

EssMenuVQueryDesigner

EssMenuVWizard