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
Show L1,L2 in Cube View
A#Cash.TreeDescendantsInclusive.Where(Text8 = L1). I have used the above formula to display only level1 members of one account but now I want to like to display level1 members along with the parent ...
JackLacava
OneStream Employee
OneStream EmployeeGoing "up" a tree is typically a bad idea, for the simple fact that the system must work on the assumption that there might be more than one parent. You can try appending .Parents but it might return multiple ones.
A better idea is probably to start your filtering directly at the parent level, and then look at the descendants of the selected parents. This might have the side-effect of having to edit the Text8 property on fewer members, which is always a good idea.