Skip to main content

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

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.