If you found something like 1+1 not equal to 2 in your SSAS cube results,
try checking the query of DSV in the first time.
The query builder today is too easy to use. On the other hand, it's too easy to make mistake with. For the problems that I encountered in a project, there are around 1/2 of the problems are come from the wrong SQL in the DSV.
Before checking the Dimension usage, Dimension, Role Settings... Try looking at the problem in the very back end first.
No comments:
Post a Comment