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,
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.
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
5 Replies
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
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
