← Back to Access Data

Essbase.Cubes

This function retrieves a table showing cubes arranged by Essbase server from a specific Essbase instance located at the APS server URL. Users can specify additional options by including a record para...

Syntax

Essbase.Cubes(url as text, optional options as nullable record) as table.

About

This function retrieves a table showing cubes arranged by Essbase server from a specific Essbase instance located at the APS server URL. Users can specify additional options by including a record parameter called "options." One of the options available is "CommandTimeout," which determines the maximum duration for server-side queries before they are automatically terminated. By default, the CommandTimeout value is set to ten minutes.