Skip to Content
0
Former Member
Nov 08, 2012 at 05:44 AM

EPMAxisOverride

283 Views

Gents,

I am having a few issues with EPMAxisOverride to override the row axis using a Excel Cell Reference.

The problem is the EPMAxisOverride does override the row axis but mysteriously adds a "&" operator with another random base member value which causes the report to not show.

If I hardcode the value returning from the Excel Reference this this is not an issue but sooner than I put a Excel Cell Reference.

I have set the "Relationship to Member Only" .

My EPM Addin Version is Version 10.0 SP 12 PATCH 6 .NET 4 BUILD 8143. This is for NW.

=EPMAxisOverride("001",TRUE,"ACCOUNTF",$L$18) - NOT WORKING

=EPMAxisOverride("001",TRUE,"ACCOUNTF","SALES") - WORKING

Any inputs would be appreciated.

Regards

Afshin