Skip to Content
avatar image
Former Member

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

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...

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 04 at 12:00 PM

    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).

    Add comment
    10|10000 characters needed characters exceeded