Assignments

ASSIGNMENTS

[Assignment 1[ [Assignment 2] [Assignment 3[ [Assignment 4]

The purpose of the homework assignment is to encourage further practice for the topics covered in our book but not covered in class (due to time constraints) and to give you the opportunity to work on more comprehensive exercises than those covered in the book. I will provide you with a comprehensive set of assignment exercises.

Assignment Submitting Standards:

All assignments are due at the beginning of the class period. Late assignments will NOT be accepted.
All assignments should be printed and stapled together with the cover letter statement (click for sample) on the top.
When presenting your analysis report please insert your SAP screens/documentation to demonstrate the completion of each task.

ASSIGNMENT 1 [top]

Multi-dimensional Reporting with PivotTables (look in BI1-M1-04-CaseStudy01-Solution_A4.docx for help).
1. Using the Microsoft Excel File BicycleForPivotV01.xls, answer the following questions:
  1. What were the Grand Total Sales for the Entire Organization? (documentation: text)
  2. What were the Internet Sales for Munich Bike Store Sales Organization and for City bike (CB) Material Group? (documentation: text)
  3. What were the Wholesale Sales for Munich Bike Store Sales Organization and for City bike (CB) Material Group, and for M6 Hardtrail 18" Material? (documentation: text)
  4. Show a report for Internet Sales, for City bike (CB) Material Group, only in 2007, and for the months of Jan, Feb, and March? (documentation: print screen)
  5. Show a report for Wholesales sales by Material Group, only in 2007, and for ALL months. In this report show the Revenues, Net Sales, Contribution Margin, and Margin Ratio. (documentation: print screen)
BI1-M4-03 Enterprise Reporting with BEx Analyzer
Option 1: Answer the questions in the following document: BI1-M1-06-CaseStudy02-Solution_A4.docx (provide 3 print screens)
Option 2: Open the Query “Spiros_OLAP_Global_Bike”.
1. What is the total sales quantity of the bike company? (documentation: text)
2. Slicing: Select a Filter to only display the Sales Organizations GER1, GER2 and GER3. What is the total revenue in Germany? (documentation: text)
3. Dicing: Further restrict your display by only looking at the distribution channel “Wholesale”. What is the total revenue for wholesale in Germany? (documentation: text)
4. Drill-down: Break down the display of the key figures by calendar months. Since you are only interested in the revenue, eliminate the display of the columns for discount and sales quantity. Limit the display to the months October, November, and December 2007. Display the monthly values in columns. (documentation: print screen)
5. Drill-across: Switch the display so that the revenues by months are displayed in the rows and the Sales Organizations are displayed in the columns. documentation: print screen)
6. Roll-up: Eliminate the breakdown by Sales Organization so that only one column is displayed for the revenues by month. (documentation: print screen)
7. Chart: Display the information as a bar chart. Delete the bar for the overall result, so that only one bar per month is displayed. (documentation: print screen)
BI1-M4-04 Developing a Query with BEx Query Designer
1. Start the BEx Query Designer. (documentation: none)
2. Create a new Query. In the first step select the InfoProvider “Bike Company Reporting 000” (Technical name: MU0R1000). (documentation: none)
3. Define a restriction for your query: The query shall be limited to evaluate only data from the year “2007” and only data for country “United States”. (documentation: print screen)
4. Display the key figures Revenue (Bike Company) and Discount (Bike Company) in the columns and the characteristic Sales Organization (Bike Company) and Material (Bike Company) in the rows. Define Distribution Channel as a free characteristic. (documentation: print screen)
5. Define a calculated local key figure as formula with the name “% Discount”, description “% Discount” which is calculated based on the formula: “Discount / Revenue * 100”. (documentation: print screen)
6. Define an “Exception 1” with the alert level “critical 3” for cases where the discount is higher than 8,6%. (documentation: print screen)
7. Use the “Save As” function to save your Query with the description and technical name MU120R1000_nn_Q1_Sales where (nnn = Student-ID). (documentation: text)
8. Execute your Query via the BEx Web. (documentation: none)
9. Display the “Information” about the executed query to display filters (documentation: none)
10. Modify the filter criteria so that only material MB-0012, MB-0013 and MB-0014 are displayed. (documentation: print screen but make sure that your Query Name appears, clearly, in the print screen). NOTE: If you have managed to answer all the questions in this exercise then, only provide the print screen for step 3.10 as documentation.