The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Solved
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...
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
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
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?
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?
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
Hi Alex,
Thank you! I got it!