Forum Discussion

Irina's avatar
Irina
New Contributor II
21 days ago

Using of Text field on Entity dimension in Cube view

Dear all, Could you please advise how to show Text field of Entity member in cube view instead of Entity Name. For example, I have: Entity member with Name A, it has Text1 field Country 1, Enti...
Cube View
  • TGG_Alex's avatar
    TGG_Alex
    19 days ago

    Irina - that sounds right.  A few more things to consider:

    1. Attribute members are resolved as in-memory, the greater number of attribute members in a given application, the greater impact on performance even though there is no technical limit.  Some have mentioned this theoretical limit of 500 but it also depends on the data model and query.

    2. Attributes off Entity DIM will result in this being stored.  To reflect changes, it may require a Process Cube Action (Consolidate, Force Consolidate) to reflect

     

Irina's avatar
Irina
New Contributor II

Dear MarcusH,

I looked more deeply in description of solution. Could you please advise am I right that solution with using of Attribute Members is applicable for Entity dimension too? I need to create list of countries as members in UD Dimension and linked these members to Entity dimension according to your link guide?

 

TGG_Alex's avatar
TGG_Alex
Contributor
19 days ago

Irina - that sounds right.  A few more things to consider:

1. Attribute members are resolved as in-memory, the greater number of attribute members in a given application, the greater impact on performance even though there is no technical limit.  Some have mentioned this theoretical limit of 500 but it also depends on the data model and query.

2. Attributes off Entity DIM will result in this being stored.  To reflect changes, it may require a Process Cube Action (Consolidate, Force Consolidate) to reflect

 

  • Irina's avatar
    Irina
    New Contributor II
    19 days ago

    Hi Alex,

    Thank you! I got it!