Database Reference
In-Depth Information
Figure 11-42.
Testing the results using the Browser tab
Using this report, we can now evaluate the effectiveness of our derived and calculated members.
3.
Locate the row with the title is Anger the Enemy? Notice that the derived member
CurrentStandardPrice indicates a value of $43.8.
4.
open the data source view, right-click the DimTitles table, and then select Explore
Data from the context menu (Figure
11-43
).
Figure 11-43.
Testing the results by exploring the data warehouse data
5.
When the table data appears, note that the price for is Anger the Enemy? in the
DimTitles table is $10.95 (Figure
11-44
).
