Database Reference
In-Depth Information
Figure 11-41.
The settings for the CalculatedTotalPrice
Process the DWPubsSalesForTesting Cube
We now have both a calculated and derived member in the Measures dimension (also known as calculated
and derived measures). We need to process the cube before it can be viewed in the browser. Let's do that now.
1.
Right-click the cube in Solution Explorer, and select Process from the context
menu. This will start the building and deployment of your changes to SSAS before
processing will begin.
2.
After the build and deployment are successful, a Processing dialog window will
appear. Click Run and wait for it to successfully process.
3.
in a few seconds, you should be able to close the Processing dialog window, and
processing will be complete.
Validate the CurrentStdPrice Measure
You have created both the calculated and derived members and added them to the cube. it's time to validate
whether they are giving you correct answers.
1.
Navigate to the browser tab in the cube-editing window.
2.
Create a result that looks similar to the one shown in Figure
11-42
.
