Suggest an Idea

[laxma]

The Qlik Compose for Data Warehouses datamart table does not allow a specific field is a primary key and it creates its own. we need to assign our own field as a primary key.

Can you please consider this feature in a future release because this will give reporting tools to create reports without any issues.

[Tzachi_Nissim]

Hi @laxma ,

Thank you for your input!

So I understand you want to use your business key as the primary key instead of the surrogate keys we generate (OID/VID)?

Please note that:

1. If you create type-2 dimensions the business key will not be unique and so cannot be the primary key.
2. The reporting tools can use the OID/VID fields for reporting without a problem.
3. Using the OID/VID fields will allow you to join with the fact that includes these fields and not the business key.
4. Surrogate keys have an advantage in performance (join on int vs. join on string) and in simplicity (join on one field vs. join on several segments).

Regards,

Tzachi

[Meghann_MacDonald]

Archiving due to age of idea and relevance. If this idea is still needed please resubmit as a new idea.

Meghann