Has anyone tried to have two case tables in the data model? How can one achieve that?

Hi Salma, is there a reason why you are not creating a BI table for AUFK and one for MHIS?

You could add the caseid to your BI table via left join and then connect your tables in the data model via the caseid.

Thank you for your reply. What do you mean with BI table? Something like a view?

Hi Salma, a BI Table is like a table with additional attributes that you can use for your analysis. How to create one? You can just to a select into statement.

For example: Select * into BI_AUFK from AUFK

OR: Select field1, field2 into BI_AUFK from AUFK

If your caseid is not directly in this table and you would like to add it then you can do:

select

caseid,

field1,

field2

into BI_AUFK

from AUFK

left join (the table from where you created the caseid)

I hope that helps.

Amina

Hi Salma,

You can have two case tables,2 activity tables using what we called "Multi-event Log".

Find more on Celonis MEL on the help page(incl. some videos)

celonis.cloud/help/pages/viewpage.action?pageId=35554007 or search for "Analyze multiple processes" within Help Resourcers.

obs.: even though you are going to use a single Data Model, it will count as 2 Data Models in case you have restrictions of # data models

Best,

Gabriel