the % Profit Contribution Calculated Member
that remains structurally is to add the % Profit Contribution to have all the components in place to meet the
information consumers' stated business requirements.
the Calculated Members folder.
Calculated Member from the context menu that appears, as shown in
The Calculated Member
Ensure that Measures
is selected in the Parent Dimension selector atop the Builder.
following into the Member Name box within the Calculated Member
% Profit Contribution
following into the Value Expression box within the Calculated Member Builder:
Ancestor([Store Location].CurrentMember,1))), 1,
[Measures].[Warehouse Profit]/([Measures].[Warehouse Profit],
The above MDX provides
for a Percentage Profit Contribution calculation, while also making the
result a "1" (or "100 percent") when the CurrentMember
of the Store dimension has no parent.
NOTE: For more information regarding
the CurrentMember function, see my Database Journal article MDX
Essentials: MDX Member Functions: "Relative" Member Functions.
The Calculated Member
Builder appears as depicted in Illustration 25.
Illustration 25: The
Calculated Member Builder, with Our Input
to close the Calculated Member Builder, and to accept our input.
We see the new Calculated
Member appear in the tree pane, within the Calculated Member folder,
as shown in Illustration 26.
Illustration 26: The %
Profit Margin Calculated Member Appears
Click the % Profit Contribution calculated member in the tree, to
select it, if necessary.
Click the Properties
bar at the bottom of the pane, to open the Properties pane, if
necessary. (If "Properties" appears on the bar with an
upward-pointing arrow to its right, clicking will open the pane / point the
Click the Advanced
tab in the Properties pane.
selector for the Format String property box, select Percent, as
depicted in Illustration 27.
Illustration 27: Setting
Percent Format for the % Profit Contribution Calculated Member
process the cube again, to update it for all our work.
Select Tools -> Process Cube from the Cube Editor main
menu, as shown in Illustration 28.
Illustration 28: Reprocess
the Cube ...
when prompted to save the cube, as depicted in Illustration 29.
Illustration 29: Save
the Cube before Processing
when asked if you wish to design aggregations, in the next Analysis Manager
dialog, shown in Illustration
Illustration 30: Decline
Aggregation Design ...
The Process a Cube dialog
appears, as before.
radio button to the left of Full Process, to select full processing.
to begin processing.
Processing begins. The Process
viewer displays various logged events, then presents a green Processing completed successfully message, as we
to dismiss the viewer.
stage, all components are in place to deliver the data presentation requested
by the information consumers during the business requirements gathering phase.