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
Has anyone successfully used HasChildren=True/False in a cube view member filter?
I'm building a cube view where I want to pull, in tree view, all descendants of a particular hierarchy but I also want to apply 2 where clauses: Where the member is either a 'parent' OR where the me...
I came across the below thread which helped me understand why this wasn't functioning properly in my app. FWIW, I believe this is an issue in applications prior to v8.4.
https://community.onestreamsoftware.com/discussions/Reporting/known-issues-with-version-8-4-pf-21833---member-filters/39736
EricOsmanski
OneStream Employee
OneStream EmployeeThis works: A#[Income Statement].TreeDescendantsInclusive.Where(HasChildren = True). Try spaces before and after the equal sign.
Thanks Eric. It seems like I can get this working as well for any of the Standard dimensions but not from a UD dimension. Are you able to make this same MF work with a user defined dimension? I'm curious.
- EricOsmanski
Yea, it works as long as you have spaces before and after the equal sign. If you don't, you get the error message you are seeing.
OK thanks for this. I must be doing something wrong because I sure can't get it to work with my Alternate UD4 hierarchy. At least I know it should work. Thanks again.
