5.1 Configuring a Multidimensional Database Data Source
To configure an OLAP data source, follow the steps below:
1. Click the 'New' button in the Style Studio toolbar. This opens the 'New Asset' dialog box.
2. In the left panel, select the 'Data Source' node. In the right 'Type' panel, select 'XMLA' and click 'OK'.

This opens the 'XMLA Data Source Wizard' dialog box.
3. In the 'XMLA Data Source Wizard' dialog box, click the General tab and enter the data source 'Name' and 'Description'.
4. Click the Driver tab and enter the 'XMLA URL'.

XMLA is used to communicate with the OLAP server. The URL is the path to the XMLA service; for example, the URL for SQL Server is the file msxisapi.dll, which is in the Isapi directory of the XMLA installation.
5. Click on 'Browse Catalogs' button and select the database catalog name from the menu. Click 'OK'.

6. Click on 'Retrieve Metadata' to load the schema. This button can be used to update the schema if it changes.

7. (Optional) For a date dimension, select a desired level of the date dimension in the tree, and enable the 'As Date' option. In the 'Parse Pattern' field, enter the date format corresponding to the date values stored in the data source.

The 'As Date' option allows the date field to be displayed in Charts, Crosstabs, and Selection Lists with normal date-sorting features, and allows the date field to be filtered by a Range Slider component (but not by a Calendar component).
8. Press the 'View Sample Data' button to verify that the dates are being parsed correctly.


9. 'Save' the data source.
10. The 'Keep Original Order' option for a dimension determines the sorting order when it is displayed in a chart or a cross-tab. If checked it will display values in the order it retrieves them from the data source.
See Also
Appendix Appendix B:, OLAP Server Setup, for details about specific databases.
| << 5 Multidimensional Databases | © 1996-2013 InetSoft Technology Corporation (v11.5) | 6 Non-Relational Data Sources >> |