Connecting to your Cube in Centage Analytics

Centage Analytics is Centage's plug-in to Excel, where you can analyze your Centage data (actuals, budget, and any what-if scenarios you have created). You can export your data from Centage to Centage Analytics by deploying a Cube.

After you deploy a Cube from Centage Analytics, you can connect to that Cube in Centage Analytics and use it to run reports.

This document shows you, a Centage Analytics user, how to connect to your Cube from Centage for the first time.

Step 1: Launch Excel and click on the Analytics Maestro tab at the top. On the Analytics Maestro ribbon, click on Report Designer.

Step 2: In the Report Designer, click on the drop-down menu at the top and select New Data Source.

Step 3: A Data Source Setup window opens. Click on the HTTP Server tab and enter the following information in the fields provided:

1.HTTP Server Name: Located in Centage Settings (with Centage Administrator access)

2.User Name: Provided by Centage Support in your Welcome email

3.Password: Provided by Centage Support in your Welcome email

Step 4: Click Connect to Server.

Step 5: The name of your Cube appears in the Existing Databases, Existing Cubes, and Data Source Name fields. Click OK.

 Please Note: If you do not see a Cube, you may be experiencing a security issue. Please contact Centage Support.

Step 6: The Report Layout tab reopens. The name of your Cube appears in the dropdown menu. Click Connect.

Dimensions and Hierarchies from your Planning Maestro account appear on the left, under Cube Dimensions.

You have now connected to your Cube from Planning Maestro. Click and drag Dimensions from the Cube Dimensions section to the Dimension Layout section to begin building your report.

Example: Click and drag your Account Number Hierarchies to Rows to start building a report which displays rows of Account Numbers.

For more instructions about setting up a report, see Setting up Reports in Analytics Maestro.