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