Summing a dimension property value on a changing dimension -
09-18-2003
, 08:46 PM
I am having a problem when trying to sum a distinct set of
dimension property values within a changing dimension. I
am always returned the complete set of descendants,
instead of the distinct set. Also, when viewing the
results in the fact table it still returns values for
members which are not always included in the slice of data
I am analysing.
The syntax is as follows:
Sum(distinct(Descendants([Timekeeper].currentmember,
[Timekeeper Numb])), cdbl([Timekeeper].properties("fte")))
I have another calculated measure to retrieve the distinct
and this is working correctly, syntax:
DistinctCount(Descendants([Timekeeper].currentmember,
[Timekeeper Numb]))
Thanks,
Naona Manthorpe |