Skip to main content
I
Irina
November 30, 2024
Solved

Using of Text field on Entity dimension in Cube view

  • November 30, 2024
  • 2 replies
  • 2 views

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,

Entity member with Name B, it has Text1 field Country 2

Entity member with Name C, it has Text1 field Country 2

I would like to show in cube view in rows figures on Country 1 and Country 2 (so I need to aggregate figures of Entity B and C in this row). Could you please advise is it possible? If it isn't possible to aggregate figures, could you please advise if I can simply show three rows Country 1, Country 2, Country 2 in cube view instead of Names.

Best answer by MarcusH

You can do that by using Attribute members. Have a look at this thread:

https://community.onestreamsoftware.com/t5/Application-Build/Attribute-member/m-p/7083

 

2 replies

M
MarcusHAnswer
December 2, 2024

You can do that by using Attribute members. Have a look at this thread:

https://community.onestreamsoftware.com/t5/Application-Build/Attribute-member/m-p/7083

 

I
IrinaAuthor
December 2, 2024

Dear MarcusH,

Thank you! I don't see Attribute Members in Entity dimension. Could you please advise if there is any solution for Entity dimension members?

 

I
IrinaAuthor
December 2, 2024

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?

 

T
TGG_Alex
December 3, 2024

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

 

Terms & ConditionsAccessibility statement