Join Cardinality on Sap Analytics Cloud

[#1]

Is it possible to join Two models on SAC with cardinality 1 to many, many to many or many to one?

If yes, which combinations of models is supported for this kind of operation? for example ca you do it between an import model and a live connection model?

Many thanks to who will answer.

[sandip_kumar003]

Hi,

Please go through this link:

https://help.sap.com/docs/SAP_HANA_PLATFORM/9de0171a6027400bb3b9bee385222eff/f2d39eda7780414a9d482d4...

Best Regards,

Sandip Kumar.

[mfoeken]

Hi f_melardo82,

There are three options when linking models. Below

• All primary data – Allows all data in the primary model, and corresponding data in a secondary model to appear in the table
• All data – Allows all data in the primary and secondary model to appear in the table. (This option isn't available when linking on hierarchies.)
• Intersecting data only – Allows only linked data to appear in the table.

You can find more information here.

Kind regards,

Martijn van Foeken | Interdobs

[CKnall]

Hi Filomena,

maybe this link can help you a little bit:

https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/8c8691c24ade40d580a4b...

Greetings Cornelius