SAC 1 (SAP)

1. In the New Query for OData Services window, create a Query Name (for example, Sales_TeamA) for the Sales model you are going to select, and click Next.
2. In the Build OData Services Query window, double click the Sales model icon in the left planal to select all Data items, then select “Classic Model” and click Create.
3. In the Draft Data window, select your query after the game data is drafted into the Sales model.
4. In the Modeler | New Model screen, select the Card View icon under Layout.
5. Using the information hereActions to modify the Data Type of some variables from Measure to Dimension (Generic) or vice versa. Click on the card view of a variable you need to modify. Click on the drop-down menu of Type to select the correct data type.
6. When you finish the modification, click on Create Model, and click Create again.
7. In the Save Model window, double-click the “YourRed#” folder. Then create your own subfolder by clicking the folder icon . Double-click your subfolder just created, and save your model in a “Data” folder (you need to create it) there.

Follow the instructions above to set up Financial Postings, Inventory, Production, and Market data models for your assignments.

The following steps show you how to create a visualization to identify the best seller by rounds. Make sure you save your own visualizations under the following convention: Red#_FileName where Red# is your Red ID number so that we can easily find your story/work.

1. Click the home screen icon to go to the welcome screen.

1. In the welcome screen, choose the Stories icon at the left side of your screen.
2. Create a new story by clicking on the Canvas icon.
3. Click on “Chart” on the right side of the screen.
4. Select a model you created in the previous steps.

6. Let’s start with the Sales model so that you can walk through an example.

7. Select the Sales data model you created and click OK. If you are asked to log in, then use your credentials in the game.

8. Now, you connect SAP Cloud Analytics to a specific data model. You can create a visualization (e.g., a chart) by selecting “Story” at the left of your screen.

9. In the next screen, you will find a charting area on the left side of the screen and a “Builder” window on the right side. In the “Builder” window, you will see the current Data Source: SALES.

10. There are many helpful tools available for SAP Cloud Analytics. Please spend time exploring the functionality available to you. The following steps will show you how to create the “Best Seller by Rounds.”

11. Under Measures

[1]

add “Net Value.”

12. Under Dimensions

[2]

, click on + to add Dimension.

13. Select “Simulation Round”. Notice the total “Net Value” is broken down by rounds.

14. Now, let’s add another dimension “Materials Description”. Then, under Color, click on + to add Dimension, and select “Materials Description” from the drop-down list.

15. Notice the icons to the right of the chart. Find the one for sorting and sort the closing balance from highest to lowest.

16. Change the color of your dimension by selecting the down-pointing arrow to the right of the color palate under +Add Dimension.

17. Under Chart Structure, change Chart Orientation to Vertical.

18. Then insert a text box to write a brief description/analysis (50 to 100 words) of your chart.

19. Save your story/file using the naming convention in the SAC Assignment folder. If you want to create other stories for your practice, please save them in a “Work” folder in “My Files” for better file management.

Now create visualizations to identify and analyze the best sellers by area (sorted from lowest revenue to highest revenue) in the ERPSim by clicking on the Insert chart icon on the ribbon at the top of your screen. Or you can create visualizations to explore different data cubes that are available.

1. To submit the assignment to Canvas, you will need to export it as a PDF file. On the File tab of the ribbon, click on Save. Choose Save, then Export. Click Export one more time. You should be able to find your file in the download folder.

Then upload both charts and the description/analysis to Canvas by the due date.

[1] Measures are cost objects in Cost Accounting. Cost object is anything/fact for which a cost measurement (quantity) is collected about business operation. Measures are the cells of a logical cube. They are organized by dimensions. See the lecture notes for Multi-dimensional database for more details.

[2] Dimensions contain a set of unique values that identify and categorize data. They form the edges of a logical cube, and thus of the measures within the cube. Because measures are typically multidimensional, a single value in a measure must be qualified by a member of each dimension to be meaningful. For example, the Sales measure can have four dimensions: Time, Customer, Product, and Channel.