Database Reference
In-Depth Information
Note
When you add new calculations, you do not need to process the cube.
They are immediately visible when they have been deployed. You can
change what the deploy command does by setting the processing op-
tions on the project properties.
Adding advanced calculated measures
You can also add more advanced measures to your cube. An example of a more ad-
vanced calculated measure could be a ratio calculation, such as showing the ratio of
product sales in relation to its parent product. To create such a calculation, perform
the following steps:
1. Click on the New Calculated Member button in the cube designer.
2. Name the measure as [Ratio to Parent Product] and add the follow-
ing expression:
case
when [Product].[Product
Hierarchy].CurrentMember.Level.Ordinal = 0
then 1
else [Measures].[Sales Amount] /
([Product].[Product
Hierarchy].CurrentMember.Parent,
[Measures].[Sales Amount])
end
3. Specify that the format string should be Percent .
4. Select the associated measure group to be Fact Internet Sales .
5. Deploy the cube and browse the cube to review the results.
Search WWH ::




Custom Search