Open Excel 2016 on your computer

• Select Get Data,  From Database, then From Analysis Services

• Enter Server Name: ssas.kemin.com, then click Next 

• On Select Database and Table window, click the arrow on the right and select the appropriate database.

You’ll have 3 different options:

- SSAS_KMN: retrieves data from M3 KMN environment

- SSAS_Nexa: retrieves data from Nexa

- SSAS_StockEvolution: supports stock evolution analysis, uses M3 as data source

- SSAS_Training: Training data

• Select Sales Perspective

• Click Next

• Click Finish

  In order to view the data in a pivot table, just click on OK

The system will display a new pivot table

·      You can use the field list panel on the right to search for the columns and data you want to include in your pivot.