Usage of EVMBR function in input schedule....

[Former Member]

Hi Experts,

I am using multiple EVDRE's in single input schedule.

As part of my requirement I need to keep some of the dimension members as static in EVDRE page key range....

I tried to do it by use EVMBR function... but I am getting different results.

In my scenario, I am having NA member in account, cost center and Product dimensions( With same name)

When i had given below statement I got account NA member as static.. but I need cost center NA member as static...

=EVMBR("SALES","NA")

Here there is no option to select particular dimension.

I also tried by giving filters in EVMBR function..

Please help me to solve this issue.

Regards,

Kumar.

[former_member186498 · Accepted solution]

Hi Kumar,

not sure I've understand what you asked but if you want to know how to select the right NA value you have to write <dimension name>:NA

Kind regards

     Roberto

[Former Member]

Hi Kumar,

EVMBR function can pull the members from only one dimension at a time, and I believe SALES is the member of the account dimension. That's the reason that NA is also pulled from the account dimension only.

Hope this helps.