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 ...
AnalysisServices.Database(server as text, database as text, optional options as nullable record) as table
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.