EPM 10 Hierarchy and Property filter

[Former Member]

Hi Experts,

I need a help about filtering the members.

I have an hierarchy for 0COSTELMNT, and I have a property on this dimension. I want to filtered both hierachy and property. But EPM applied only first filter. Although I used to "&" operator, result did not change. I took a screenshot. What can I do?

Best regards

Haşim

[former_member190501 · Accepted solution]

Hi,

Try =EPMDimensionOverride("000","COSTELEMENT","ALL AND PROPERTY= VALUE")

Hope it works..

regards,

Raju

[Former Member · Accepted solution]

Dear Potturi;

I also filtered property with usin EPMDimensionOverride formula. It works but I add another filter like that screenshot, any change occured.

Any Offer.

Best regards

Haşim

[Former Member · Accepted solution]

Hi again,

And I don't want to add all costelement, only costelements in hierarchy which has X property.

[former_member190501 · Accepted solution]

Hi,

Here ALL is nothing but Descendents of selected Costelement member (hierarchy node) plus X property.

Thanks,

Raju

[Former Member · Accepted solution]

Thank you, It's working