Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 213 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
12c Migration - Aggregation issues
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
Answers
-
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.
0 -
Better, try to understand the Physical SQL generated for the incorrect Totals. That should give an idea as of what is going off.
0