WFA on HANA dimension labels

[abalasescu2]

Hi @YSE-1 

I have an issue with a few custom pretty basic dimensions - 1 level flat org related like legal entity, dep etc.

I have 4 of those, all with quite a few results that come as "??" which would mean they do not have labels.

But strangely enough they do, I have checked them in manage data as well as canvas reporting and I can find both en_GB and en_US descriptions.

Here is the SQL:

select DISTINCT IFNULL(CAST(JOB_INFO."DEPARTMENT" AS nvarchar(50)), '??') AS Level1Id, 

IFNULL(CAST(DEPARTMENT_LABEL."LABEL" AS nvarchar(50)), '??') AS Level1Name

from ( SELECT DISTINCT EMP_JOB_INFO_T."DEPARTMENT" DEPARTMENT FROM "[%ODS_DATABASE%]"."EMP_JOB_INFO_T" ) JOB_INFO

LEFT OUTER JOIN "[%ODS_DATABASE%]"."MDF_SPLIT_GENERIC_OBJECT_T_Department" DEPARTMENT_CODE ON JOB_INFO."DEPARTMENT" = DEPARTMENT_CODE."INTERNAL_ID" AND CAST(DEPARTMENT_CODE.EFFECTIVE_END_DATE AS date) = '9999-12-31' 

LEFT OUTER JOIN "[%ODS_DATABASE%]"."CONFIG_GENERIC_OBJECT_T_GOLocalizedData" DEPARTMENT_LABEL ON DEPARTMENT_CODE."EXTERNAL_NAME" = DEPARTMENT_LABEL."INTERNAL_ID" AND DEPARTMENT_CODE.ROW_ID = DEPARTMENT_LABEL.PARENT_ROW_ID AND DEPARTMENT_LABEL."LOCALE" = 'en_GB' 

ORDER BY Level1Name

Here is a screenshot of my results for one of the dimensions:

Attaching here the IDs of business unit MDF vs business unit job info - both have the internal ID 17, as per the build as well - the issue is with the label...

Kind regards,

Alex

[abalasescu2]

Hi @YSE-1 I have checked with new initial build but still doesn t work.

I have also moved configuration to production and can replicate the same exact issue.

Not really sure what to check further. Any ideas please?

Kind regards,

Alex

[YSE-1]

Hi @abalasescu2 - can you please provide the datacenter and instance ID so I can have a look at the configuration? Thanks.

[abalasescu2]

DC33, company ID S001955610P - please keep in mind this one has EUDP flag on...