Exploring Jaspersoft OLAP Activity

 

 

 

Step

Action

1. 

Log into JasperReports Server as Username: jasperadmin  Password: jasperadmin

2. 

Enter Foodmart Sample Analysis View into the search field in the upper-right corner and click the search button.

3. 

Begin by opening an OLAP view.

Click the Foodmart Sample Analysis View link to execute the view.

4. 

Note: The OLAP view opens for inspection.

5. 

Note: Unit Sales, Store Cost, and Store Sales are measures: numeric information made available in an OLAP view.

6. 

Note: Promotion Media and Product are dimensions. They categorize and help you drill down to analyze the numeric information.

7. 

Expand a dimension to view its levels.

Expand All Media to display the types of media in this view.

8. 

Note: All Media is expanded to display over a dozen kinds of media.

9. 

Note: The measures automatically segment so you see the information for each media type.

10. 

Expand the top All Products adjacent to All Media to view total sales and cost figures broken out by media type.

11. 

Note: All Products drills down to three sublevels, or categories of products: Drink, Food, and Non-Consumable.

12. 

Note: Notice at the right that the sales and cost figures also break out to display aggregate totals for the three product levels. Expand a product level to view different categories and kinds of products and their associated sales and cost figures.

13. 

Under All Products, expand Non-Consumable to view them.

14. 

Expand Periodicals to see categories of periodicals.

15. 

Note: In this OLAP report, magazines are the only type of periodical.

16. 

Expand Magazines.

17. 

Expand Computer Magazines.

18. 

Click the scroll bar if necessary to view the computer magazines, as well as their sales and cost figures.

19. 

Note: Computer magazines and their sales and cost information scroll into view.

20. 

Expand Excel to view computer magazines published by that company.

21. 

Note: Excel produces one computer magazine, called Excel Monthly Computer Magazine.

22. 

Note: The sales and cost values indicate that stores sold 134 of the magazines, at a cost of $40.86 and generating revenue of $103.18.

23. 

Click the 134 link to drill down to the details page and view information on those magazine sales.

24. 

 

Note: The details page appears. The Store_Name column indicates the stores that sold the Excel computer magazine.

25. 

Click the horizontal scroll bar and scroll to the right if necessary to view more information.

26. 

Note: The Unit_Sales column displays the number of magazines each of the stores sold.

27. 

Click the x Close button at the top right to close the details window and return to the application.

28. 

Near the top left, click to collapse the All Products level to return to the default view.

29. 

Note: Task 1: Drill down to find information in an OLAP view, is complete.

30. 

Next, explore the OLAP view settings and options.

 

At the far left, click the Change Data Cube button, the button with the cube image on it.

31. 

Note: The settings page appears. On this page you configure all aspects of the OLAP view.

32. 

Near the top under the Columns heading, click the Measures link.

33. 

Note: Select the measures you want to appear in the view. The first three measures are selected; they were present when you explored the view during the previous task.

34. 

Click the Sales Count option to include it in the view.

35. 

Click the OK button to save changes to the Measures specification.

36. 

Click the OK button near the bottom to save all changes and exit the settings page.

37. 

Note: The Sales Count measure appears in the view at the far right.

 

Task 2: Explore settings and options for the view, is complete.

38. 

Click the Log Out link at the top right to exit the application and end the session.

39. 

Congratulations!

You completed the following two tasks:

 

1. Drill down to find information in an OLAP view

2. Explore settings and options for the view

End of Procedure.