Microsoft Analysis Server 2008 cube problem
My problem is that I have the same values showing up for each calendar
year for items which are sold in only one calendar year and not all?
So I have 3 dimensions.
SalesHeader, SalesLine and Time.
When filtering by a single product on the left side of the cube
browser and putting the calendar year at the top. I get the total
amount sold for the product showing up in each calendar year. So it
the total amount shows up duplicated across calendar years when it was
only sold in one calendar year.
this happens for all items so I cannot tell which year it was sold as
the values are duplicated in each calendar year?
How do I fix this problem.