Open Excel 2016 on your computer
- Select menu Data
- 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.