Data Mismatch from CUBE to Report Studio Report

[hrk551]

Tested in both  in 8.3 and 8.4

we will get data in excel which we will load in to cube. now when we check data in cube its exactly matching upto penny. when we make a Report Studio report from this cube we are missing few dolalrs

ex: expenses =  1,456,123.45  (in cube)
                  =  1,456,121       (in report)   

Expenses in details are   w+x+y+z.

we are ahaving this problem not every month for suppose  we have data mismatch for aug, july is good, may & June also missing few dollars


Any idea.

Thanx in Adv.

[billylodz]

check the default category in cube

I had 7,4 cube for 8.3 RS and I have seen that if there was any default category in dimension the report is filtering for this category by default without any information in Report.

it is special sytiation but I have seen something like that.


maybe round() in RS