dbTalk Databases Forums  

Summing a dimension property value on a changing dimension

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Summing a dimension property value on a changing dimension in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Naona Manthorpe
 
Posts: n/a

Default 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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.