COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => BI Modeling (Transformer) => Topic started by: hrk551 on 07 Oct 2009 09:54:29 AM

Title: Totals mismatch from cube data and report data
Post by: hrk551 on 07 Oct 2009 09:54:29 AM
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.