Skip to main content
Question

Automatic Export of OLAP Table

  • February 23, 2021
  • 2 replies
  • 56 views
A
Level 4
Hello, I would like to know if there is an option to make an automatic export of OLAP tables in excel or CSV. Would be interesting as well if the Action Engine could make it in a periodic manner. Thanks in advance

2 replies

.
Level 1
  • .146001054
  • Level 1
  • June 14, 2021

have you gotten any answer yet? I have the same question

D
Level 0
Forum|alt.badge.img

Hello Alejandro and Marius.

Yes, you can use the PyCelonis for that.

here is the link for the API Tutorial: https://celonis.github.io/pycelonis/notebooks/03_PQL_and_Python_1.html

 

Make sure to create an application key and define permissions (All Access) for the key.

You can define the permissions by clicking on the three-dot button on the analysis or workspaces; Search for the Key name you created, and define the permissions.

After configured, you can schedule the script to run every day, every week, etc. (Machine Learning> Scheduling).

Thank you.

Daniel.

2021-06-15 07_54_36-PQL and Python — pycelonis 1.5.5 documentation

Community Code of ConductAccessibility statement