We have a cube with several date dimensions e.g. expected ready date, actual ready date, expected ship date, actual ship date etc. That may or may not be relevant. In total there are less than 16 objects when counting fact table and dimensions.
In a couple of time dimensions all measures are allocated to 1999. I have checked the source data and the transactions have a range of dates against them and the foreign keys match the correct record in the relevant time dimension. So why aren't the measures allocated to the correct time period? Are there too many dimensions for the cube?
Not all time dimensions behave this way. Only 2 are wrong.
Any help would be greatly appreciated.
Steve
40 million lemmings can't be wrong........can they?
In a couple of time dimensions all measures are allocated to 1999. I have checked the source data and the transactions have a range of dates against them and the foreign keys match the correct record in the relevant time dimension. So why aren't the measures allocated to the correct time period? Are there too many dimensions for the cube?
Not all time dimensions behave this way. Only 2 are wrong.
Any help would be greatly appreciated.
Steve
40 million lemmings can't be wrong........can they?