Adding Functionality to Your Cube - Getting Started with SQL Server 2012 Cube Development - page 168

If this is not true, it will calculate the percentage of the sales using the Sales Amount
measure and divide it using a tuple containing the sales amount and the parent of
the current member in the product hierarchy:
else [Measures].[Sales Amount] /
([Product].[Product
Hierarchy].CurrentMember.Parent,
[Measures].[Sales Amount])
The last statement in the statement terminates the case statement:
end
When you create calculated measures, you need to be aware of the fact that some
calculations can be very slow, as there are no aggregates created for a calculation.
In some cases, you are better off creating a calculated column down in the Data
Source View.
Adding calculated members
Another thing that you can do with the calculations is adding calculated members
to dimensions. These members can be both calculated members as well as named
sets.
To create a simple calculated member, perform the following steps:
1. Click on the New Calculated Member button in the cube designer.
2. Name the calculated member as [Bikes and Clothing] .
3. Change the value of Parent hierarchy to be Product.Product Hier-
archy .
4. Specify the value of Parent member as [All] .
5. Add the following expression:
([Product].[Product Category].&[1] +
[Product].[Product Category].&[3])