Skip to main content
insightsoftware Docs insightsoftware Docs
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Create a Jet Analytics Cubes data source with Jet Reports

This information applies to Jet Reports versions 2013 and higher

Overview

Once the Jet Data Manager has been installed and configured you can use Jet Reports to create a connection to your cubes and start creating valuable reports.

Before creating a connection to the cubes you will need to set permissions for your users .

How-to Videos

Intro to using Cube-based Pivot Tables Access Cubes in Azure Analysis Services

Process

  1. Open Excel.

  2. Navigate to the Jet tab and click Settings > Data Source Settings.

  3. Click Add. The New Data Source dialog will open.

  4. In the Name field, enter a friendly name for your cubes (in this example we choose the name Jet Cubes). In the Database Type drop down, select Cube . Click OK .

  5. On the Connection page, enter the name of the server where the cubes reside.  In the Database field select your OLAP database.  Click OK .

  6. Once the Jet tab, click the Pivot Table button to create a pivot table.

    pivot_table_button.png

    The Insert PivotTable dialog will open. Choose the cube you want to analyze. Click OK

  7. You will now see your Excel screen with your cube's Measures and Dimensions show in the PivotTable Fields panel on the right.

    pivot_table.png

    For detailed instructions on using cube-based pivot tables, see the videos at the top of this article.

    For more general information on using pivot tables, see the following Microsoft Office Support Articles:

Published:

Create a Jet Analytics Cubes data source with Jet Reports

This information applies to Jet Reports versions 2013 and higher

Overview

Once the Jet Data Manager has been installed and configured you can use Jet Reports to create a connection to your cubes and start creating valuable reports.

Before creating a connection to the cubes you will need to set permissions for your users .

How-to Videos

Intro to using Cube-based Pivot Tables Access Cubes in Azure Analysis Services

Process

  1. Open Excel.

  2. Navigate to the Jet tab and click Settings > Data Source Settings.

  3. Click Add. The New Data Source dialog will open.

  4. In the Name field, enter a friendly name for your cubes (in this example we choose the name Jet Cubes). In the Database Type drop down, select Cube . Click OK .

  5. On the Connection page, enter the name of the server where the cubes reside.  In the Database field select your OLAP database.  Click OK .

  6. Once the Jet tab, click the Pivot Table button to create a pivot table.

    pivot_table_button.png

    The Insert PivotTable dialog will open. Choose the cube you want to analyze. Click OK

  7. You will now see your Excel screen with your cube's Measures and Dimensions show in the PivotTable Fields panel on the right.

    pivot_table.png

    For detailed instructions on using cube-based pivot tables, see the videos at the top of this article.

    For more general information on using pivot tables, see the following Microsoft Office Support Articles:

For an optimal Community experience, Please view on Desktop