Including a DW field in the related dimension

Question

Hi everyone,

I’m working on Performance Management and I need to include the Document Type field in the subject area.

I noticed that in the DW tables the field already exists (DOC_TYPE_ID in DW_PERF_TEMPLATE_DEF_D and the corresponding TL table DW_PERF_DOCUMENT_TYPE_D_TL).

However, in the dimension "Dim – HCM – Performance Template" (Dim_DW_PERF_TEMPLATE_DEF_D), I can’t find the DOC_TYPE_ID field.

Does anyone know if there is a way to include this field in the dimension, since it already exists in the DW tables, without having to create extended-extension objects?

I was expecting to simply extend the dimension by adding the TL, but it looks like this is not possible.

Any guidance or confirmation would be appreciated.

RVohra · Answer

As per my understanding, we cannot expose DOC_TYPE_ID in the existing delivered dimension (Dim – HCM – Performance Template) even though the field exists in the DW source tables, it is not part of the delivered semantic model, and FADI does not support “turning on” hidden columns inside delivered dimensions.