1. Open the Cube Editor for the Store Expense cube.
2. Within the Cube Editor for Store Expense, process the cube, without defining aggregations or storage mode.
3. Within the Data pane, ensure you retrieve $847.20 for the following member combination:
· Current YearÅ‚s Actuals
· Store managers that begin with S
· All Department
· All Store Type
· San Francisco
Store 14
· 2000
· Total Expense
· Amount
4. Ensure you retrieve $10,272.00 for the following member combination:
· Current YearÅ‚s Actuals
· Store managers that begin with B
· All Department
· All Store
· Supermarket store type
· 2000
· Total Expense
· Amount
5. Ensure you retrieve negative $373,823.44 for the following member combination:
· Current YearÅ‚s Actuals
· All Store Manager
· All Department
· All Store
· All Store Type
· 2000
· Net Income
· Amount
The value is negative because the Net Income member is equal to Net Sales minus Total Expense, and the cube does not contain data for Net Sales.
6. Save the Store Expense cube, and then close the Cube Editor.