SSAS Tabular – Renaming A Cube

Standard

Lots of searching with no results on how to rename a SSAS Tabular cube! So here’s how:

1: In SSDT > DEBUG > <Database Name> Properties

RenameCube

Step 2: Change your cube name!

RenameCube2

Not the easiest place for it, but we get there in the end..

Advertisements

Connecting to Analysis Services through Excel

Standard

Just a quick one with some pretty pictures..

Step 1: Select a nice blank cell in Excel (B4 for instance)

ExcelConnect1

Step 2: From the Data tab on the ribbon, select From Other Sources > From Analysis Services

ExcelConnect2

Step 3: Enter the name of the server you want to connect to

ExcelConnect3

Step 4: Click Next and then select the name of the Cube to which you want to connect from the dropdown

ExcelConnect4

Step 5: Select the location of your new pivot table

ExcelConnect5

Step 6: click OK and Robert’s your Mother’s brother.