Database Reference
In-Depth Information
Let us review the created calculation to understand the code used in the example.
First, the code starts with a normal case statement:
case
The next statement is a check that checks the level of the current member in the
product hierarchy; if it is 0 , it means that it is on the top of the hierarchy:
when [Product].[Product
Hierarchy].CurrentMember.Level.Ordinal = 0
If this is true , the value is set to 1 meaning 100 %:
then 1
Search WWH ::




Custom Search