Can I customize the sum aggregate function?

Last Post 21 Oct 2004 02:01 AM by dize. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

21 Oct 2004 02:01 AM
Hi everyone, I hope someone can help me with this...

I have a measure in my cube that I don´t want to aggregate in the usual way.. (Cannot use any of the available aggragate functions:sum,count,min,max or dist.count). Is there a way to let the measure´s aggregate function sum only some of the values? The problem is that in the fact table the same value (for the same product) is listed more than ones (because there are more than one occurences of the same product in the table) but I only want the aggregation to sum the value for each product once.
I´m new at this so I´m hoping there is a simple solution to this? Any suggestions would be greatly appreciated
the rookie

Acceptable Use Policy