TABLE 3: Common Properties Available in the XMLA Provider for Analysis Services
PropertyDefaultDescription
AxisFormat TupleFormatThe format for the MDDataSet Axis element. The format can be either TupleFormat or ClusterFormat.
BeginRange -1 (all cells)An integer value that restricts the data set a command returns to start at a specific cell.
Catalog Empty stringThe database on the Analysis Server to connect to.
DataSourceInfo Empty stringA string containing the information needed to connect to the data source.
EndRange -1 (all data)An integer value that restricts the data set a command returns to end at a specific cell.
Password Empty stringA string containing password information for the connection.
ProviderName Empty stringThe XML for Analysis Provider name.
Timeout UndefinedA numeric timeout that specifies in seconds the amount of time to wait for a connection to be successful.
UserName Empty stringA string containing username information for the connection.