Skip to Content

EPMSelectMember Property Range

Jun 14, 2017 at 10:10 AM


avatar image
Former Member


Wondering if you can help. I am trying to achieve 2 things using the EPMSelectMember formula with dimension TIME.

The aim is to have the user double click on a specific cell that then opens up the EPM - Member Selector pane and then they select a TIME that is restricted to a certain range (e.g. 2006.01 to 2025.12).

Going a step further I really want to have two separate cells (one for year and other for month), restrict both cells to a range and do this using the EPMSelectMember formula. Right now, I can restrict it to only one year or say one month in the EPM formula. Is there say an AND / OR option that combined with property and restricts to a range?

Hope this has made sense.

Thank you in advance,


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

1 Answer

Vadim Kalinin Jun 14, 2017 at 10:45 AM

Requirements not clear...

But OR can be used like here:


";" = "OR"

P.S. You can't use:


YEAR=2015,2016,2017 (multiple values)

10 |10000 characters needed characters left characters exceeded