Database Reference
In-Depth Information
Figure 11-39.
Adding a new derived member to the cube
Once you have added the derived member to the cube, the queue must be processed for it to appear. This is
logical, because it is the act of processing that creates the derived member and its values on the SSAS server.
Let's put our knowledge to work in the next exercise by creating both a calculated measure and a derived
measure and testing to see whether one or both of them are correct.
eXerCISe 11-3. aDDING CaLCULateD aND DerIVeD MeaSUreS
in this exercise, you create a copy of the cube for testing your derived and calculated measures. You also
modify the copied version of the cube to include both a calculated and derived measure. You then browse
the test cube to determine which value is correct and then decide which new measure to keep.
Note:
if the solution from the previous exercise is closed, open Visual Studio. Remember to select Run as
Administrator and answer Yes to close the UAC.
Add a Derived Measure
We need to create the derived measure in the data source view, so we navigate to the data source view and
modify the fact table to include the derived member.
1.
in the existing data source view, right-click the FactSales table and choose the
Replace ➤ With New Named Query option from the context menu, as shown in
Figure
11-35
. This will launch the Create Named Query dialog window.
