In a data model there is no direct connection between two table and also with intermediate table in between we cannot achieve 1:N relationship.
Is there a way to view the columns of both the table side by side without disturbing the existing Data Model table mappings.
Can we make use of Knowledge Model here?
+2you can add these two tables to the data model and leave it disconnected to everything else. Then you can create two separate OLAP tables and see both (independent) columns
Hello @gabriel.okaba11 ,
Let me explain the scenario with an example. There are two tables named BI_P_INV_Q and DT_P_SUPPHIER. In the data model, we do not have a direct relationship between the tables. But it is stated that DIFF_INV column of BI_P_INV_Q can be equated with EBSNO column of DT_P_SUPPHIER i.e. "BI_P_INV_Q" "DIFF_INV" = "DT_P_SUPPHIER".
Now without disturbing the basic data model structure, can we merge both the tables in analysis sheet to see the contents of both the tables in one OLAP table.
Or we can use the knowledge model here.
Thank You
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.