I have some wrong numbers coming up in my cube and need to debug it. For categories i can go and check the same in the category view. Is there a place i can see the measure values too other than looking at mdc file in Analysis studio. I think not but wanted to be sure. Else, how do you approach debugging cube
You can see cube content via powerPlay or report studio or Analysis studio. You need to perform queries for db and for cube that return same result. first of all you should prove connection between dims and facts. any fact table row cann't contain data in dimension link column where it must be. thus cube can be without that row.
Is it possible you have set the data type of your measures too small and the numbers are overflowing as they get aggregated up the levels? I have seen that happen before.
Regards,
MF.