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
Extracting Dimension hierarchies
Hi,
There seems to be an issue when pulling members through GridView from the dimension library. As shown in the screen shot below, when filtering on a specific roll up within the dimension using the parent child relationship reference the report includes duplicate members. This is because OS is pulling all the alternate roll up locations as well. We are wanting to pull just the main rollup so that we can see the members and parents in separate columns within excel. Does anyone know how to get around this or another way to pull this data from OneStream.
3 Replies
- JackLacava
OneStream Employee
I believe that's expected behaviour. If a child has two parents, how could the system decide which parent to display...? If you know that you don't want to show children under a particular node, append a .Remove(A#YourParent.Children) to the current filter.
That is interesting, I thought .Remove only takes a specific member name, not functions.
- JackLacava
I tested it and it seems to work here (7.2.2). The related sample says it takes a list of members, so using expansions to generate that list should be ok.
