High performance data export from PCM
In case you missed it:
In update 21.12 the exportQueryResults function was enhanced to support fast and scalable export of level 0 data from PCM.
With this new enhancement we can avoid the scale and performance limitations of MDX and create txt or zip file output of level 0 data in columnar format. Level 0 filters can also be applied allowing a user to export all data for a specific POV or even further filtering to isolate specific rules or org units. One or more level 0 members from each dimension can be used as filter criteria.
Read the details here: https://docs.oracle.com/en/cloud/saas/enterprise-performance-management-common/cepma/epm_auto_export_query_results.html
Tagged:
3