Question Re: Issue with EPMAxisOverride in Financial Management Q&A

Issue with EPMAxisOverride

sebastian_hagl — Mon, 04 May 2015 09:32:04 GMT

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

Re: Issue with EPMAxisOverride

Former Member — Mon, 04 May 2015 09:43:19 GMT

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

Re: Issue with EPMAxisOverride

Former Member — Mon, 04 May 2015 09:56:42 GMT

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 ",".

Re: Issue with EPMAxisOverride

sebastian_hagl — Mon, 04 May 2015 09:57:30 GMT

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

Re: Issue with EPMAxisOverride

Former Member — Mon, 04 May 2015 10:16:42 GMT

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.

Re: Issue with EPMAxisOverride

Former Member — Mon, 04 May 2015 10:50:21 GMT

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

Re: Issue with EPMAxisOverride

sebastian_hagl — Mon, 04 May 2015 12:25:57 GMT

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