Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

High performance data export from PCM

in Profitability and Cost Management 7 comments

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:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!