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