Skip to Content
0

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

Jan 04 at 11:56 AM

38

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?

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

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
0

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

Share
10 |10000 characters needed characters left characters exceeded