ExportQueryResults: Slow run time using Member Filters
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.