How can I retrieve values of a specific property in one formula (all entities in specific region)?

[Former Member]

In ENTITY Dimension the property "Region" is specified in metadata (EMEA, Asia, ...) for each entity. Is there a way to retrieve the total of all EMEA companies?

=EPMRetrieveData(,EPMContextMember(,"ENTITY"))

--> that way I have the full total. Is there a way to work with "Dimension Override" or something similar to have the total for all EMEA entities?

Through AdHoc Report I was able to get the result through "local member creation" which is a simple SUBTOTAL formula, but that does not help with EMPRetrieveData formulas...

[former_member186338]

Sorry, but you are trying to use property instead of normal hierarchy - bad idea in general!

You can't use EPMRetrieveData to get total by property. I also do not recommend using EPMRetrieveData - slow reports.

Create a normal hierarchy parent and use it in the report (may be create additional hierarchy).