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
Question
Extract an olap table from view
+26Hi
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.