We can also analyze multiple numeric values across time. Suppose we want to compare the quarterly snack foods sales dollar amount among the West Coast states.
In the following example, we’ll use the Foodmart Sample Analysis View.
To compare quarterly snack foods sales dollar amounts among the West Coast states:
| 1. | Click View>Repository to display the Repository panel. |
| 2. | In the Folders panel, expand the folder Organization > Analysis Components > Analysis Views. |
A list of OLAP views appears in the Repository panel
| 3. | Click Foodmart Sample Analysis View to open it. |
| 4. | Click |
For details about using cube dimensions, see Columns, Rows, and Filters.
| 5. | Click the Move to Rows icon |
| 6. | Click the filter icon |
| 7. | Click OK twice to accept the selections. |
| 8. | Click Zoom on Drill to activate it. When active, its tool bar button looks like this |
| 9. | Click the Edit Display Options tool bar button |
| 10. | In the table, click USA to zoom in. |
The following navigation table appears.
|
2012 Quarterly Snack Food Sales, Dollar Amount, for West Coast States |
The view now shows the quarterly snack food sales compared by state.
Recommended Comments
There are no comments to display.