Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 55 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI 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