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

ExportQueryResults: Slow run time using Member Filters

in Profitability and Cost Management 1 comment

Summary:

Hello Gurus,


We are using "Export Query Results" through EPM Automate and noticed unusual behavior in our testing.


1) When we used below query to Export All Application data it took 10 mins to execute.

epmautomate exportQueryResults APPNAME fileName="Output.txt" fileOutputOptions=TEXT_ONLY


2) When we applied Member Filters and Columnar format to Export data then it took 40 mins to complete and below is the Query we used.

epmautomate exportQueryResults APPNAME fileName="Output.txt" dataFormat="COLUMNAR" memberFilters="{\"Year\":[\"FY22\"],\"Period\":[\"May\",\"June\"], \"Scenario\":[\"OEP_Working\"], \"Entity\":[\"Entity1\",\"Entity2], \"Segment\":[\"Seg1\",\"Seg2\",\"Seg3\",\"Seg4\"],}" includeHeader="true" delimiter="," roundingPrecision="3"


We noticed there was no impact on the performance even if we increase or decrease the Dimensions in the Query. The execution time was same even if we run the query applying the Filters for other dimensions or if we run only with Year, Period and Scenario.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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