Classmill - Pivot your Cube

Pivot table introduction

We take a look at the basics of using Pivot...

Pivot tables and external data

This takes a look at connecting to external data.

Precognition data

In this module we look at field names.

Connecting to the Precognition Cube

View these steps to connect to the data.

Next steps

So you have mastered Pivot Tables and reporting and you...

Learning Discussion

MODULE

All modules

Connecting to the Precognition Cube

First create a new blank workbook. Go to Data - From Analysis Services.

Delete Drag

Enter the server name prasgbqsp001

Delete Drag

Choose Factory-EUAccounts

Delete Drag

Change the friendly name to UK Production

Delete Drag

You are now connected and next time you load up Excel you'll find the connection in the Existing Connections dialog. You'll be able to create Pivot table reports using this connection.

You are now connected and next time you load up...

Delete Drag

Next: Next steps