Text/Association missing in the Text tables of sap datasphere

[Nageswara6]

Hi Experts,

Problem:

All the Text tables created by Import Entities option are missing the “Text/Association”.

For example, Cost Center Text table is created as seen in the screenshot below with the warning -
Text entity "Remote.SAP_S4H_XXX_XXX.I_CostCenterText" does not have exactly one key attribute with a "Text / Association" set. This attribute must not have any semantic type and must be the representative key, if one is defined.

SAP has not given authorizations to make changes in the table. So it does not allow me to update the Text/Association.

How can this be fixed? Could you please suggest.

[GaitanDiaz]

After reviewing the examples from SAP's Samples GitHub, where hierarchies are created, I observed the following:

1. Remote tables are left exactly as they are imported. First, because some of their characteristics cannot be modified, and second, because they might be needed later for other tasks or datasets.
2. What the examples actually do is create a graphical view using the imported remote table as a source without transformations. In the properties of that view, all the semantic usage configurations for both fields and the object are applied. Additionally, keys that are required and not necessarily defined in the source table can be specified.
3. Within those same views, if necessary, dimension-type views are associated with text-type views

I also noticed that the views included in the published GitHub packages come without any warnings once they are imported, however, if one tries to recreate them exactly, the warning you mentioned still appears. 

In conclusion, the warning will continue to appear even if the views are created, but you will still be able to change the required properties. For now, the warning does not prevent saving and deploying the object.

I hope this helps.