April 27, 2016 at 3:36 am
I use SQL Server 2012 Enterprise Edition.
According to many post online about semi additive measures it is possible to calculate a measures over a time dimension (calculate always the max value over the hierarchy) and an additive dimension. So I implemented a measures without changing the aggregate function. Then I used the Business Intelligence-Assistent to define a semi additive behavior for a individual measure. I switched the aggregate function from Sum to Max. That was all. After recalculation the cube I recognized that the system used the max-calculation for both dimension instead only for time dimension.
Maybe I use a wrong attitude in related properties. I tried many different attitudes but nothing changed.
I want to ask for help.
solved: The implemention of max aggregat function seems to be incorrect. If I used 'LastNonEmpty' it works. So I write in MDX an own MAX funktion.
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply