MDX Essentials: Enhancing CROSSJOIN() with Calculated Members - Page 6
By William Pearson
10. Type Non-Domestic
into the Member name box of the Calculated Member Builder.
11. Click the "+"
sign to the immediate left of Store in the Data pane of the Calculated
12. Click the "+"
sign to the immediate left of Store Country that appears.
13. Click Canada to
14. Click the Insert
button, once Canada is highlighted, to insert the appropriate syntax
into the Value expression box just above.
15. Using the keypad under the Insert
button, click the "+" sign.
The "+" sign appears in the Value
expression box, to the immediate right of the Canada syntax we added
in the previous steps.
16. Click Mexico, just
under Canada, in the Data pane of the Calculated Member Builder,
to select it.
17. Click the Insert
button to insert the appropriate syntax for Mexico Stores into the Value
expression box just above.
The syntax appears in the Value expression box, to
the immediate right of the syntax we added in the previous steps. The Calculated
Member Builder, with our additions, appears as shown in Illustration 10.
Illustration 10: The Calculated Member Builder (Compressed
View) with Our Additions
18. Click the Check button
to perform a quick syntax check.
A message box appears, indicating that syntax is valid, as
depicted in Illustration 11.
Illustration 11: Message Box Indicates that Syntax is
19. Click OK to close the
20. Click OK to accept
input and close the Calculated Member Builder.
The Calculated Member Builder closes, and the Non-Domestic
calculated member appears in the Calculated Members folder in the Tree
21. Open the Properties
pane underneath the Tree pane, if required.
22. Click the Basic tab
of the Properties pane, as necessary.
The Non-Domestic calculated member, with associated Properties
pane, Basic tab, appears in the Calculated Members folder in the Tree
Pane, as shown in Illustration 12.
Illustration 12: The Non-Domestic Calculated Member (with
23. Click the Data tab to
the right of the Properties pane, to access the Cube Editor's Data
24. Click the downward arrow for
the Store member in the Data Slicing pane, atop the Data
view (it displays All Stores, by default).
25. Expand All Stores in
the tree that appears, clicking on the "+" sign to its immediate
The Stores member expands to the next dimensional
level, where, along with the FoodMart Store Countries, we see our new
calculated member, Non-Domestic, as depicted in Illustration 13.
Illustration 13: The Non-Domestic Calculated Member Appears
in the Store Country Level
We now have a clone cube that resembles the lost production
cube in all material respects. Our next steps will be to analyze and enhance
the query that has been presented to us by the information consumers. To do
this, we will return to the MDX Sample Application.
26. Select File -> Exit to close the Cube
Editor, saving the cube when prompted.
Some of the products that appear on this site are from companies from which QuinStreet receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. QuinStreet does not include all companies or all types of products available in the marketplace.