RetrieveDimensions (Method)

Applies To:

OLAPCatalog object, OLAPCatalogNew (CubeQuery) object

Description:

Refreshes the dimension values in the Catalog pane. If a query is disconnected, this method attempts to connect silently to the database if the query is disconnected. The password used for the connection in this case must be set using SetPassword or a connection error will occur and an exception thrown. This method serves no useful purpose in the new OLAP section due to differences in how the new section handles the catalog.

Syntax:

Expression.RetrieveDimensions()

Expression Required:

An expression that returns a Dimensions object

Example:

This example shows how to change all columns in a result set to best fit the data:

ActiveDocument.Sections["OLAPQuery"].Catalog.Dimensions.RetrieveDimensions()