Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
BICC CodeCombinationPVO performance enhancement
Description
FscmTopModelAM.FinGlAccountsCodeComboAM.CodeCombinationPVO
Rel 19_13C
This PVO performs extremely slowly when either these columns selected:
| CodeCombinationConcatenatedSegments |
| CodeCombinationDescription |
We have 300,000 code combinations and selecting 58 columns from this PVO via BICC consistently took 3+ hours to extract.
Eliminating just either 1 of these columns (57 columns remain) reduced extract duration to 90+ minutes.
Eliminating both these 2 columns (56 columns remain) reduced extract duration consistently below 5 minutes for same row count.
Since both these columns are concatenations I'm pretty sure the problem is caused by the use of a scalar database function. Enhancement could be to concatenate outside the database, or perhaps store the concatenation in the DB.
Use Case and Business Need
Use case : needing descriptions of chartfield combos for subledger accounting in our data lake.
Original Idea Number: abe52e9e5b