OLAPCatalog object, OLAPCatalogNew (CubeQuery) object
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.
Expression.RetrieveDimensions()
An expression that returns a Dimensions object
This example shows how to change all columns in a result set to best fit the data:
ActiveDocument.Sections["OLAPQuery"].Catalog.Dimensions.RetrieveDimensions()