EPMSelectMemberID Doesn't Work inside of a "IF"

[collepicolo]

Hi,

I've been trying to use the EPMSelectMemberID inside of a IF formula but it doens't seems to work, is it the right behavior? If yes, is there a workaround for it?

Here is an example of the formula: =IF(A2="Y",EPMSelectMemberID(,"TIME,,,,"ID")," - ")

Thanks

[former_member186338]

Hi Alexandre,

"I've been trying to use the EPMSelectMemberID inside of a IF formula but it doens't seems to work, is it the right behavior?" -YES!

"If yes, is there a workaround for it?" - for what? What are you trying to achieve? What for you want to use the formula?

Vadim

[collepicolo]

Hi Vadim,

Thanks for the prompt reply.

So, It will sound weird but I'm trying to restrict the inputs on an input schedule using this formula. The users will only record the ID of a dimension in the input schedule.

Let me try to explain it better, I'm doing a template where I have two accounts(Approval Date and Launch Date) on the column header and products on the rows. With this the user type a date to record in the model to disclosure it on a report. However I would like to restrict/validate the inputs using the time dimension as a "driver" for it. Does it make sense?

In fact I'm using the IF formula on the EPMFormattingSheet and bringing it using the "Content" and " ' " before the formula.

What the formula does is IF the intersection on the Input Schedule has value in the data base we show it using the EPMRetrieveData if not it suppose to show the EPMSelectMemberID, unfortunately like I already shared it does not work.

I'm thinking to use a VBA in this case.

Thanks for any idea/input.

Alex

[former_member186338]

Sorry, but you explanation is unclear and very generic!

Please explain the restriction/validation in details with screenshots and user actions.

It's possible to restrict using Excel data validation or cells locking or...

Vadim

[collepicolo]

Hopefully these screenshots can give you a better idea of what we are trying to do. A "list"(data validation from the Excel) will not be the best in this case because it will show a lot of periods in a flat-table from the Excel drop-down box.

It is a very simple report, as you can see below:

We just want to control the inputs to be the TIME ID:

 

Thanks

[former_member186338]

Hi Alexandre,

Unfortunately this type of member selection as a date value will not work. Forget about this idea. Use Excel data validation with long list or some VBA form to select date!

By the way, what do you want to do with this value later? You will not be able to use it in calculations (only some custom badi...)

Vadim

[collepicolo]

Hi Vadim,

Yes, that is my conclusion, there is no way out, thanks. Perhaps in the future SAP can improve the EPMSelectMemberID to be embedded in Excel formulas.

These values are going to be used only for reporting purpose, no calculation.

Thanks,

Alex

[former_member186338]

"for reporting purpose, no calculation" - then just use some formula validation! Like year and month!