EVEXP functionality in BPC MS 7.5

[Former Member]

Hi Fellow colleagues,

I am using EVEXP function in my input schedule.

Have created a property called CAPEX in Account dimension and have given values Y to specific accounts.

In the Function arguments, Member is a parent, EVBAS in Include flag and in the filter CAPEX='Y'.

The fomula gves true and doesnt expand to the basmembers.

Kindly advise.

Regards,

Shrini

[JohnL · Accepted solution]

Hi Shrini,

Can you give us the exact EvEXP function parameters you are calling?

i.e.

=EVEXP(...)

Thanks,

John

[Former Member · Accepted solution]

Hi John,

Thank you for your prompt response.

My syntax is as follows:

EVEXP(I2,D71,C73:C111,D73:E111,TRUE,"EVBAS",,,"CAPEX='Y'")

I2=Application

D71 is the Parent of the account members

C73:C111 is the key range

D73:E111 is the data range

EVBAS is the Include flag

CAPEX='Y' is the filter (Have added a property in Account Dimension and have inputted values as Y for the respective account members)

Let me know if you need any more information....

Cheers,

Shrini

Edited by: sheenugaonkar on Feb 10, 2012 11:25 AM

[JohnL · Accepted solution]

Hi Shrini,

You need to fully qualify the Filter as follows:

Account.currentmember.properties(CAPEX)="Y"

i.e.

=EVEXP(I2,D71,C73:C111,D73:E111,TRUE,"EVBAS",,,"Account.currentmember.properties(CAPEX)="Y"")
 

Let me know if that works,

Thanks,

John

[Former Member · Accepted solution]

Hi John,

It doesnt work.

It only gives the parent member, in this case.

Cheers,

Shrini

[JohnL · Accepted solution]

Hi Shrini,

Sorry, try this instead:

=EVEXP(I2,D71,C73:C111,D73:E111,TRUE,"EVBAS",,,"[Account].currentmember.properties('CAPEX')='Y'")

Note the single quotes around CAPEX and the Y

I tested the above and it works for me in BPC 7.5 SP6

Also, remember that since this uses MDX statements(currentmember.properties), you need to make sure the CAPEX dimension property is set to be InApp (i.e. InApp checkbox is Checked off in the dimension property page).

Let me know how that goes.

Thanks,

John

[Former Member · Accepted solution]

Hi John,

Thanks a lot. Your quick response is highly appreciated.

The formula gave the desired results....

Cheers,

Shrini