[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:


  1. 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)

  2. BI1-M4-03 Enterprise Reporting with BEx Analyzer (use server 2 for this exercise). Practice using the following document: BI1-M1-06-CaseStudy02-Solution_A4.docx

        Open the Query “Spiros_OLAP_Global_Bike” and answer the following questions: 

    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)

  3. BI1-M4-04 Developing a Query with BEx Query Designer (use server 2 for this exercise). Practice using the following document: BI1-M4-05-CaseStudy02-Solution_A4.docx

    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 MU141R1000_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. 


Assignment 1.1: Create InfoObject Catalogs, InfoObjects, DataStore Object and InfoCube. Assignment2_BI4.docx

Assignment 1.2: ETL Master Data from Flat Files. Assignment2_Part2_BI4.docx, GBI20ProductV01.csv

Assignment 1.3: ETL Transaction Data from Flat Files. Assignment2_Part3_BI4.docx, SalesdataV01.csv


Assignment 3.1: Build a Query with BEx Query Designer

    Here are the assignment questions and answers: 

Assignment 3.2: Analyze data with BusinessObjects Explorer 4.0

    Here are the assignment questions and answers: 


4.1 BI2-M6-02 SAP BW Data Mining (Association Analysis)

  Here are the assignment questions, answers, and videos: 

4.2 BI3-M1-05 Report Design and Analysis Using Web Intelligence 

Here are the assignment questions and answers: