Skip to Content
0
Former Member
Apr 16, 2010 at 07:16 PM

FACT2 or WB table migration problem

31 Views

We have migrated to V7 and we ran our first report in v7 .we experienced a problem which seems to be linked to the size of FACT2 or WB tables. we ran consolidation produced numbers which were incorrect. We ran a full optimization. But the numbers were still wrong It was fixed after we ran consolidation. It seems that now that the logic doesnu2019t calculate correctly when there are a large number of records in FACT2 and WB . We had similar problem in v5 but previously in V5.1 the logic would work or at least the package would fail with an error message. Now the problem is consolidations did not fail on all categories, the ones which did fail work differently to the ones which passed in that the ones which failed take LC values and rates from other categories/periods. These categories were consolidated last when FACT2 was at its very large. Also the consolidation may produce the correct numbers for say 5 periods then incorrect for the remaining 7. Is it due timing ?

Can some one give me lead is it due V7 issue or we did something wrong ? Can some one guide me the debugging steps please ?

Thanks

Satya Kantiwal