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