Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Updated screenshots and text changing the server name from trainman to borneo. Also added Excel from Office 365 instructions and screenshot.

The following article provides detailed instruction on how to connect to the EIS cubes. 

...

Office 365

Open Excel > Data tab >  Get Data > From Database > From Analysis Services

Image Added


Excel 2016

1. Open Excel > Data tab >  Get External Data


2. Choose From Other Sources


3. Choose From Analysis Services


4

...

Image Removed

...

. Enter Borneo.forest.usf.edu in the Server name text box

Image Added

5. Choose which Analysis Services domain you want to use.

In this case you can select any domain with the “EIS” prefix. These are the SmartBI domains. 

Do not use any of the cubes without the EIS prefix.Image Removed

Image Added

6. Select the cube you want to use

Example click : Click on the “Enrollments” cube in the box and click the “Next” button in the above screenshot.

...

Give it an appropriate name as convenient.

Image RemovedImage Added

8. Choose how to view the result,

Typically you want a PivotTable.

Image RemovedImage Added

9. Now you have a pivot table interface

...