Cardinality

[valluvan_navalan]

Hi Does Cardinality have any effect on the generation of the query ?

Regards,

Valluvan N

[former_member182521 · Accepted solution]

Hi Valluvan,

If carnality is not specified in Universe level it will be automatically identified from your Database layer where you specified your table relationships (Primary key,Foreign key)

Regards,

Mani

[michael_melters]

Cardinality does not change the query. Cardinality is only relevant when you want IDT/UDT to help you with solving loops (detections). Tables with only one-ends are lookup tables they are candidates for aliases. If a table has only n-ends it is treated like a fact table so the tool suggests a contexts in this case.

So if have solved a loop after having defined all the cardinalities and you have aliases and contexts as a result of the detect loop, contexts , aliases procedures, then yes, your query is changed, finally.

[Former Member]

Hi,

Check here:

http://help.sap.com/businessobject/product_guides/boexir4/en/xi4sp4_info_design_tool_en.pdf#page=134

BR