In the given data tables below - I used the statement - 'PU_SUM ( DOMAIN_TABLE ( “Chapters”.” Title”, “Book_Author_Mapping”.” Book ID” ), “Chapters”.” Number of Pages” )' Here I have a couple of questions in understanding the functionality:- If the Domain Table is formed based on the specified column/tables - To which Specified Table will the Damon Table be linked to? - as both the tables 'Chapters and Book_Author_Mapping' have an N:1 relationship with other tables?Will the Domain table link to the 'specified tables - Chapters; Book_Author_Mapping' based on the Table we mention in the SourceTable?Column field of PU_X Functions -i.e. “Chapters”.” Number of Pages” in this case ?' Thanks in Advance. Kind regardsAbhinav

Formation of temporary Domain table when we specify multiple tables that are with N- 1relation with other tables in the data model.

In the given data tables below -

I used the statement - 'PU_SUM ( DOMAIN_TABLE ( “Chapters”.” Title”, “Book_Author_Mapping”.” Book ID” ), “Chapters”.” Number of Pages” )'

Here I have a couple of questions in understanding the functionality:-

If the Domain Table is formed based on the specified column/tables - To which Specified Table will the Damon Table be linked to? - as both the tables 'Chapters and Book_Author_Mapping' have an N:1 relationship with other tables?
Will the Domain table link to the 'specified tables - Chapters; Book_Author_Mapping' based on the Table we mention in the SourceTable?Column field of PU_X Functions -i.e. “Chapters”.” Number of Pages” in this case ?'

Thanks in Advance.

Kind regards

Abhinav

Page 1 / 1

Share

Hello Abhinav, Here are some good example how Domain table works - https://docs.celonis.com/en/domain_table.html
I am not sure you can bring into DOMAIN table fields from different tables, you probably would need to add BIND function to form single table first and then select which columns you want in your temp table using DOMAIN.

Hi Abhinav,

Can you really execute the query you posted? I would assume that you can not execute it because Chapters and Book_Author_Mapping don't have a common table. Normally DOMAIN_TABLE is joined to the common table of its arguments.

Hope this helps,

Mentor

Reply

ANY QUESTION?

MORE CELONIS

CHECK US IN

Reply

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded

ANY QUESTION?

MORE CELONIS

CHECK US IN