Skip to main content
Question

Extract an olap table from view

  • September 18, 2025
  • 1 reply
  • 317 views

Akshay H
Level 4
Forum|alt.badge.img

Hi all,


I am trying to extract an olap table data from a view can you guys please help me with the appropriate python/pycelonis code.

 

Thanks,
Akshay

1 reply

Jan-Peter van der Steege
Level 12
Forum|alt.badge.img+26

Hi ​@Akshay H, 

Ideally you use the SaolaPy connector for this. This connects directly to the Database behind the Data Model. 
You can use the docs to get started with your first script: https://celonis.github.io/pycelonis/2.14.0/tutorials/executed/05_saolapy/03_dataframe/. 

If you want to reuse some filters that are in the Knowledge Model and/or View, you first should read out these using the PyCelonis connection (see https://celonis.github.io/pycelonis/2.14.0/reference/pycelonis/ems/studio/content_node/knowledge_model/filter/), store them as variables and apply them in your SaolaPy query.