Database Reference
In-Depth Information
2.
When the Create Named Query dialog window appears, type in the code defined in
Listing 11-3. Afterward, click oK to close the dialog window, as shown in Figure
11-36
.
Tip:
This code can be found in
C:\_BookFiles\Chapter11Files\ListingCode\Listing 11-3
.
3.
Verify that the FactsSales table now looks like Figure
11-37
.
Copy the Cube
Now make a copy of the cube for testing purposes and add the derived member and calculated members
to the test version of the cube.
1.
Create a copy of the existing cube for test purposes and name it
DWPubsSalesForTesting
. To do so, right-click the DWPubsSalesVer1cube and
select Copy from the context menu. Right-click the Cubes folder and select Paste
from the context menu (Figure
11-38
). Finally, type in the new name in the dialog
box as it appears in Figure
11-38
.
Add the Derived Member to the DWPubsSalesForTesting Cube
The two derived members now exist in the data source view. Next, add the two derived members to the
cube.
1.
Navigate to the DWPubsSalesForTesting's Cube Structure tab of the cube-editing
window. You can do this by right-clicking the
DWPubsSalesForTesting.cube
file
and selecting View Designer.
2.
Highlight the Sales measure group, as shown in Figure
11-39
.
3.
in the Sales measure group, right-click and choose New Measure from the context
menu. The New Measure dialog window will appear, as shown in Figure
11-39
.
4.
Select the DerivedTotalPrice, and click oK to close the New Measure dialog window.
5.
Right-click Sales Measure group again, and choose New Measure from the context
menu.
6.
When the New Measure dialog window appears, select the CurrentStdPrice, and
click oK to close the New Measure dialog window.
7.
Rename both members by removing the spaces that the designer has added to their
names.
8.
Verify that both new measures have been added to the Sales measure group, which
should now look like Figure
11-40
.
