Forum Discussion

kmd's avatar
kmd
Contributor
3 years ago

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...
Reports
  • ASides's avatar
    ASides
    3 days ago

    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's avatar
EricOsmanski
Valued Contributor

This works: A#[Income Statement].TreeDescendantsInclusive.Where(HasChildren = True). Try spaces before and after the equal sign.

kmd's avatar
kmd
Contributor
3 years ago

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's avatar
    EricOsmanski
    Valued Contributor
    3 years ago

    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.

    • kmd's avatar
      kmd
      Contributor
      3 years ago

      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.