Both the Data Source name and the Catalog properties depend on your XML for Analysis provider configuration. You configure the provider by modifying the datasources.xml file in the configuration directory of the XML for Analysis SDK (in our case located in the C:/Program Files/Microsoft XML for Analysis SDK/Config directory). Here is how our datasources.xml file looks like:
In our case we have defined both a multidimensional and relational data source. Data source that we will use in the tutorial is the Local Analysis Server data source. This data source is using the sample OLAP cube : Foodmart (or Foodmart 2000) that comes with the SQL Server 7.0 and 2000. The provider is MSOLAP and the data source is local. Set the DataSourceName to the data source name that you defined in the datasources.xml (in our case - "Local Analysis Server") and the Catalogue to the catalogue of your choosing on your Analysis Server (in our case Foodmart).
Note that for the XMLA 1.1 SDK you will need to specify an additional property if you wish to use http as opposed to https through the AllowInsecureTransport element such as this:
- <DataSources UnnamedSessionsTimeout="300" NamedSessionsTimeout="3600" AllowInsecureTransport="1">
Since our data source is an OLAP data source we can set the Query Type to MDX, however, that is the default anyhow, so you do not have to change anything.
Copyright © 2004 Intellimerce Inc. All rights reserved.