Question Re: Join Cardinality on Sap Analytics Cloud in Technology Q&A

Join Cardinality on Sap Analytics Cloud

filomenamelardo — Thu, 26 Jan 2023 08:42:54 GMT

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.

Re: Join Cardinality on Sap Analytics Cloud

CKnall — Thu, 26 Jan 2023 09:18:25 GMT

Hi Filomena,

maybe this link can help you a little bit:

https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/8c8691c24ade40d580a4b2017e67110d.html?locale=en-US&q=link%20dimensions

Greetings Cornelius

Re: Join Cardinality on Sap Analytics Cloud

mfoeken — Thu, 26 Jan 2023 09:30:20 GMT

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

Re: Join Cardinality on Sap Analytics Cloud

sandip_kumar003 — Tue, 16 May 2023 05:26:23 GMT

Hi,

Please go through this link:

https://help.sap.com/docs/SAP_HANA_PLATFORM/9de0171a6027400bb3b9bee385222eff/f2d39eda7780414a9d482d48dc7a68cc.html?version=2.0.04

Best Regards,

Sandip Kumar.