Attribute text not showing after deploying analytical model in Datasphere

[Lluís]

We have an analytical model in Datasphere that includes the "Employee" field, which was correctly displaying its corresponding text—until the model was deployed. Below, I explain in detail how it was configured and at what point it stopped working, since no changes were made that could explain why the text suddenly stopped appearing.

How was it configured when it was working?

The source view of the analytical model includes both an attribute association (EMPLOYEE_ATTR_1) and a text association (EMPLOYEE_TEXT) for the "Employee" field.

In the attribute list of the view, only the attribute association is assigned—not the text one (only one can be assigned):

We could see the "T" icon in the source view next to the "Employee" field, indicating that text was correctly linked:

Additionally, the EMPLOYEE_ATTR_1 table has two associations: one to another attribute table (EMPLOYEE_ATTR_2) and another to EMPLOYEE_TEXT. As in the previous case, only one association can be assigned to the "Employee" field, and the one assigned is EMPLOYEE_ATTR_2: 

In the analytical model, the "Employee" field is marked to allow the use of attributes:

I can’t confirm if the "T" icon ever showed up for the "Employee" field inside the analytical model itself, but the text display was working correctly with this configuration.

What change caused the issue?

Nothing in the configuration was changed. However, these steps were taken:

• A deploy was performed on the EMPLOYEE_ATTR_1 attribute table.

• A deploy was then performed on the analytical model (From this point onward, the "Employee" text stopped being displayed).

We also noticed that in other analytical models using the same setup and referencing EMPLOYEE_ATTR_1, the "Employee" text also stops displaying after deployment—even if no actual changes are made.
So, with each deploy, the text disappears from the "Employee" field.

(Language settings were not changed.)

What workaround did we implement?

First, we tried reverting to previous versions of EMPLOYEE_ATTR_1 and the analytical model, but this didn’t restore the text.

So we tried a different approach:
The second employee attribute table (EMPLOYEE_ATTR_2) does have a text association, and this one can be assigned to the "Employee" field:

In the analytical model, we activated the attributes from EMPLOYEE_ATTR_2:

Now we see the "T" icon:

And in our SAC dashboard, instead of using the original "Employee" field, we use the one from EMPLOYEE_ATTR_2, which has the text association.
In other words, we had to add an additional field just to display the text.

I wonder if this is actually the correct solution, and whether we need to apply the same changes in other models and dashboards in order to display the texts.

Final questions: 

• Is there no way to use a single field that has both an attribute association and can also display the text?
• Has anyone experienced the same issue? (The setup used to work as described, and suddenly stopped working without an apparent reason.)
• What’s the recommended solution to display texts for fields that also have attribute associations—especially when there are multiple levels of attributes?

Thanks in advance for your help.

[Simon_Ye]

Hi, you can create a dimension view for the employee, including all attributes and the corresponding text you need.

The sample dimension for Saler is as follows: ID is the key, Name is the text for this ID, it also has an attribute and Status and corresponding text "Status Text." You need to set the semantic type of the text column as Text and then associate it with the corresponding columns. 

In the Analytic model, you can't display the column whose semantic type is text, but you can display the text when drilling down to the corresponding key column.