Support for SQL Server Analysis Services

Step 3. Using the New Gadget

Login

Login using your Google account.

Note that at any point, if you would like to sign-out of the gadget, you can do so by clicking the ‘sign out’ link on the bottom of the gadget. Logging off will not erase any of your cube files.

 

Cube Management

After logging in, you will be presented with a wizard that allows you to manage your existing cubes or add new ones.

1. Select the  sign to add a new cube.

2. You can then enter or browse for the CUB file. Once entered or found, select OK and allow the file to be uploaded to the hosted environment. Note that this process can take time, depending on your connection upload speed and size of file. Please note that it is recommended to use ZIP files as they reduce file sizes significantly.

3. Once the cube is done uploading, you can select it from the list and hit next.

 

4. If your CUB file includes more than one catalog or cube, you will be presented with the following dialog. allowing you to select a catalog and cube.

 

Setting the Initial Layout for your Analysis

At this point, you are almost ready to start your analysis. All that is left is to set the initial layout of your grid.

To structure your view, select any of the fields on the left, and then add it to the rows or columns. You can have multiple fields on each axis.

Alternatively, you can skip this stage by clicking the ‘Finish’ button and the system will automatically select a layout for you.

 

Start Your Analysis!

You have completed your preparations and can now perform your data navigation.

 

<-Previous Step Next Step->

SaaS BI

Spreadsheet Analysis

Corporate Data Analysis

Analytics for Salesforce

 

Tutorial

Download our step-by-step instructions for setting up your Pivot Table for Local Cube Files.

Download Tutorial in PDF

Pivot Table Updates

Register here to get updates and the latest news about Pivot Tables for CUB files and Google Docs.