Adding In-db Data from Microsoft SQL Server Analysis Services

Follow the steps below to add a connection with in-database data to Microsoft SQL Server Analysis Services.

Procedure

Click Files and data .
In the Files and data flyout, click Connect to.
In the list of connectors, click Microsoft SQL Server Analysis Services.
In the Microsoft SQL Server Analysis Services flyout, click New connection.
In the Microsoft SQL Server Analysis Services Connection dialog, specify the Server you want to connect to.
Select the Authentication method you want to use, and if you selected Username and password, enter your credentials.
Click Connect.
Select the Database and Cube of interest.
Click OK.
The Data Selection in Connection dialog is opened.
Click to select data of interest in the panel to the left.
Click on the top level to select the entire cube.

Limit what is shown in the panel by selecting a single measure group, or by typing a search term in the search field.

Double-click on a collapsed item to expand it, or double-click on a leaf node to send it to the Data selection in connection list.
Click Add > to move the selected data to the Data selection in connection field.
Dimension columns and hierarchies can be further limited by clicking the selected column or hierarchy in the Data selection in connection list and then, in the Settings pane, clicking Limit....
This way, you can filter out certain values of the dimension to only include values of interest. For example, you can select data from a single country only. Note that it is not possible to limit measures, only dimensions, because the cube calculates the measures in the context of the selected dimensions.
If desired, you can specify that the data in this connection should be available as external data only. Right-click on the cube name and select Load Method and the desired option.
The final step, the Add data to analysis flyout, is a summary view of the data tables that will be added to your Spotfire analysis. Make sure that the data table that is added from your connection is configured as External, for in-database analysis.

Tip: To change the load method of a data table to External, click the data table in the summary view, and then use the drop-down menus to select External.
Click OK.