I have a cube with quarter partitions and a measure group which is structured in DSV as it picks only latest record per member and stores in that measure by partition scheme. There are count and sum measures depending on this measure group. My cube is used
for reports in SSRS.
When I am looking the reports, If the time frame is in one partition range the numbers look right and if the time frame is across multiple partitions, the numbers are wrong. It's over counting things coz, If a member is counted in one partion, I don't want
that to be counted in other partion when the time frame is across multiple partitions.
Any help is greatly appreciated
View Complete Post