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
CrispinC
4 years agoNew Contributor II
Creating a parent dimension within an existing UD Attribute
Hi
We have set up a line of business attribute in our UD3 dimension based on cost centres. It has become clear that in several reports we need to aggregate some of these members. I think the easie...
- 4 years ago
Hello!
Sure it's possible - you would just insert a new child under Line_of_business then move those three children under the new parent.
Regarding reporting, you'll have to consider how reports are set up around these members. For example, if you have a CV that's pulling Line_of_business.children, it's no longer going to be clean with just the lines of business. It's easy enough to fix that - just some manual cleanup that might need to be done after you make this update.
The first suggestion is another possibility too, depending on how you do your reporting - an alternate hierarchy so your current structure is untouched but you have another structure with just the new parent and the three lines shared underneath it.
Hopefully that makes sense but let me know if it doesn't.
CrispinC
4 years agoNew Contributor II
Thanks for this solution. I messed about about trying to move them and probably took the long route by eventually deleting and then setting up the children again ...but it works fine for both my new report and existing reports.
Thanks again for your help