Skip to Content

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

Jan 04 at 11:56 AM


avatar image
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?


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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

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

10 |10000 characters needed characters left characters exceeded