12c Migration - Aggregation issues

Question

Hi,

Recently my original files were migrated from 10G to 12C.

I have noticed that especially on Pivot Table view there are issues aggregating data, e.g. issues relating to the summing of the breakdown and/or overall total of the column.

If I was to apply an additional field so that  the count can be broken down line by line then it will show the correct count, e.g 1's and 0's  but the total sum will be off, e.g. summing to 1.

In CSV format the data is fine but it appears that the majority of issues relate to the summing of fields that have been created/manipulated  using logic especially in Pivot Table view and sometimes in table/Excel format view.

Can anyone please advise of what workarounds can be applied and also provide possible reasons as to  why  the aggregation might be thrown off?

Thanks,

Jas

SonPat99 · Answer

Better, try to understand the Physical SQL generated for the incorrect Totals. That should give an idea as of what is going off.

[Deleted User] · Answer

99% of these issues are due to misconfiguration done in the legacy versions which were accepted by the tool back then but never really proper config.

In order to know WHAT is wrong you have to start looking at the RPD model as well as the construction of the analyses.