Issue with EPMAxisOverride

[sebastian_hagl]

Hi experts,

still in some trouble with EPMfunctions:

I'm trying  so override the current row axis with another dimension using:

EPMAxisOverride("000";"TRUE";A2;B2)  where A2 is the cell with the new dimension in it and ell B2 carries "MEMBERS." for getting all members of the dimension.

The outcome (unfortunately)every time  is  #Value and i really don't know why cause all parameters exist and were spelled in the right way. Is there any other option a have to check/uncheck to get this working?

Thx for help

Best

Sebastian

[sebastian_hagl · Accepted solution]

Solved the issue: The Problem is when using a german Excel the EPM Function wants the german "WAHR" instead of "TRUE".....can't believe....

[Former Member]

Hi Sebastian,

If you want to check that epmaxisoverride is working or not then try to pass only one member, or if you want to override with multiple members then try to pass multiple members separated by COMMA ",".

[Former Member]

Hi Sebastian,

Just wanted to confirm that what members you passing to the function? Is it "ALL" or specific members?

if possible then share screen shot

[sebastian_hagl]

Actually I'm trying to get all members...

[Former Member]

Hi Sebastian,

As far as i know BPC you cant directly override member by passing "ALL", because there no member having id "ALL" and in parameters we have to pass ID's.

If you have hierarchy then you can pass bas(Parent node) like bas(netincome) or dep(netincome) etc or like combination of them. DEP(netbs),bas(netincome),self

where netbs and netincome are members of my account dimension.

Create one top node and and uner that node place all member and then pass parameter like       bas(top node).

hope this will help you.

[Former Member]

Hi Sebastian,

Sorry actually i was wrong. while testing i found that, you can override  all members by using members keyword.  it is working properly in my system. My account dimension have 300 members.

Thanks Sebastian.

Don't know why it's not working properly in your system. Try to use latest EPM version