01-17-2023 12:24 PM - last edited on 05-03-2023 09:16 AM by JackLacava
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.
01-18-2023 09:46 AM - edited 01-18-2023 09:47 AM
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.
01-18-2023 08:12 PM
That is interesting, I thought .Remove only takes a specific member name, not functions.
01-19-2023 03:28 AM
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.