AnalysisServices.Database

This function retrieves a table of multidimensional cubes or tabular models from the Analysis Services database on a specified server. An optional parameter called "options" can be used to customize ...

Syntax

AnalysisServices.Database(server as text, database as text, optional options as nullable record) as table

About

This function retrieves a table of multidimensional cubes or tabular models from the Analysis Services database on a specified server. An optional parameter called "options" can be used to customize the query behavior: - Query: Input a native MDX query to fetch data. - TypedMeasureColumns: Choose whether to use the data types specified in the model for measure columns. Setting this to false will default all measure columns to "number". - Culture: Specify the culture for the data using a culture name. - CommandTimeout: Set the duration for how long a query can run before being canceled. Default value varies based on the driver. - ConnectionTimeout: Determine how long to wait before abandoning a connection attempt to the server. Default value varies based on the driver. - SubQueries: Adjust the value of the "SubQueries" property in the connection string to control the behavior of calculated members on subselects or subcubes. Default value is 2.