Configuring a Cube Hierarchy to be Loaded on Request

These steps describe how a cube hierarchy can be configured to be loaded on request, so that large OLAP hierarchies can be handled in Spotfire.

Note: This configuration must be done separately for each large hierarchy in the cube data connection.

In this example, an embedded data connection to a Microsoft SQL Server Analysis Services cube is used as an example, but you can use the same steps to configure hierarchies from any cube data source.

Procedure

  1. Select File > Add Data Tables.
  2. Click Add > Connection To > Microsoft SQL Server Analysis Services.
  3. Specify the Server you want to connect to.
  4. Click Connect.
  5. Select the Cube of interest.
  6. Click OK.
  7. In the Data Selection in Connection dialog, click on the object of interest in the left pane, then click Add >.
  8. In the Data selection in connection list, locate the large hierarchy that you want to load on request and right-click on it.
  9. From the pop-up menu, select Load Values on Request.
  10. Repeat steps 8 and 9 for all hierarchies that you want to load on request.
  11. When you are done with the data connection configuration, click OK.
    The connection is added to the Data tables list in the Add Data Tables dialog.
  12. Make sure Keep data external is selected under Load method.
  13. Click OK in the Add Data Tables dialog.

Result

When creating a filter for the hierarchy, the values in the filter will be loaded on request.
Tip: You can edit a previously created embedded data connection by selecting Edit > Data Connection Properties, clicking Settings and then clicking Edit. A data connection saved in the library is edited by selecting Tools > Manage Data Connections, browsing to the connection in the library and clicking Edit.