1. Getting permissions to open the data cube

Before accessing the SSAS Stock Evolution data cube you need to make sure your account has been granted with necessary access rights. To do this you can proceed as follows>

Go to the IT service catalog

https://keminind.sharepoint.com/sites/ServiceCatalog

click on Submit a Request

Then select the Access Request link

This will bring you to the Kemin IT Access request form

Enter your data in the upper section, then select the SSAS Data Access and PowerBI App Access (1) option from the Access Request Type  menu and tick the Stock Evolution box (2)

Click Save button, this will trigger an automatic process. You’ll be notified via an help desk ticket when your account has been provisioned with necessary access rights.

2. Opening the Stock Evolution report with Excel

Open Excel, the go to Data (1) -> Get Data (2) -> From Database (3) -> From Analysis Services

Enter the database name ssas.kemin.com, then click on next

Select the StockEvolution database (1), then select the StockEvolution cube (2) and click on Finish (3).

Import the data to a Pivot Table report

The data cube contains one Fact table called Stock Evolution Data

And 4 dimension tables.

For instance, if you configure the pivot table as showed on the left, you’ll get the pivot table showed on the right here below.