Skip to main content

Is there an easy way to use Action Flow to generate an Export of an OLAP table into an xls file? (the standard export capability of an OLAP table). The OLAP table was created via in an Analysis and has some rather robust calculations. I'd prefer not to have to effectively recreate it via Queries.

The most feasible approach at present involves the creation of a Knowledge Model, followed by the utilization of the "Celonis Get Rows" module within Action Flows to extract pertinent data. This method proves invaluable in directly acquiring Key Performance Indicators (KPIs) from the established Knowledge Model. Subsequently, employing the "Create CSV" module facilitates the transformation of this data into a CSV format, as outlined in this resource:

https://docs.celonis.com/en/create-csv-file-from-celonis-output.html

 

Addressing your queries, is there a quick way to do it with the same analysis, the answer is no. However, for an enhanced methodology, Knowledge Model and Celonis Get Row Action Flow Module a Knowledge Model alongside the Celonis "Get Rows" Action Flow module is recommended.


You are not alone with this request.

We also have set it up the way via query data + create csv but it is just a mess that there isn't any simple way or Celonis module available that allows you to select an Analysis + Sheet + Component and gives you the possibility of maintaining some filters and export it to excel.

 

Really hope that Celonis DEV team is doing something here as this is really a topic users are asking for quite often.

 

BR

Dennis


Reply