Skip to Content

dimensionpropertyvalues not giving lower level of hierarchy

Hi Experts,

I have an issue with Epmdimensionpropertyvalues function. I have to give selection of hierarchies in a dropdown. I have written this formula =EPMDimensionPropertyValues(,"ENTITY","PARENTH1",Z22), but I get a result of first level of Hierarchy only, but I need to get a first level only. In the screenshot I need to get Algeria but my result is giving only Africa. How do I get to the bottom of the hierarchy. I tried with PARENTH2 which is not working.

thanks

h1.png (8.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jan 28 at 11:46 AM

    I have another example here, I want to select the months from Q1 hierarchy. can I do that from the dropdown ? Now it does not display all the months here, it displays only the Quarter hierarchy

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 27 at 08:52 PM

    Screenshot of combobox in the report, please!

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 28 at 04:24 PM

    Not clear what do you want: "I want to select the months from Q1 hierarchy"

    What do you mean by "Q1 hierarchy"? What do you want to have?

    By design, EPMDimensionPropertyValues will show ALL values of the selected property, no filter possible!

    To select with filter you have to use EPMSelectMember, but without dropdown.

    P.S. For sure you will never have base months in EPMDimensionPropertyValues for PARENTH1 - only parents!

    Add comment
    10|10000 characters needed characters exceeded