Filter while importing data into Celonis

Hi Celonis Team,

Is there a way that while we load data into Celonis from one HANA table/view we can apply some filters to import only a limited dataset?

For example, I have two years of data in cases table but want to load only the last 6 months data into Celonis.

Regards,
Sachin

Hi Sachin,

in order to answer your question in more detail, it would be very helpful when you could tell us the Celonis Version you’re using.

Best regards,
Viana

Hi Viana,

We are using CPM 4.4.

Regards

Sachin

Hi Sachin,

since you’re using 4.4, you have connected your data model to a specific schema (most likely called CELONIS) where your celonis activity and case table as well as additional master data are stored. Within that schema your case table is actually a view, the best practice here is that you add the filter within that view.

Kind regards,
Viana

Hi Viana,

Thank you for your response. This should do.

Regards,
Sachin