Configure the Official CloudShell ElastiCube

To integrate with the Insight ElastiCube:

  1. Extract the BI solution pack to the BI Server.
  2. From the Windows Start menu, select All Programs > SiSense > SiSense ElastiCube Manager.
  3. In the Quick Start area, click Open File and open the extracted folder's \CloudShell Insight\ElasticCube\QS_ElastiCube.ecube file for editing.

    The elastic cube holds the Insight database structure, as depicted in the following figure.

  4. Connect the elastic cube to your Insight database by changing the connectivity settings. Select the Change Connectivity Settings option from the main menu.

  5. To change the default connectivity settings, select ElastiCube > Build Settings > Change Connectivity Settings Options.

  6. Click Change source database .

  7. Specify the database server location and authentication method.

  8. Click Connect to Server and select the appropriate CloudShell Insight database from the Select Database dropdown list. By default, the database name is "QualiInsight".

    Tip: If connection fails, perform MSDTC Security Configuration.

  9. Click OK.

    If any of the tables failed to build, manually load them and rebuild, as explained in ElastiCube Table Build Error: "key already exists in the collection".