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.
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