EPM Dimension override not working if the node has Special char like "."

[sree_ravinutala]

BPC10.0 SP21 Patch 2 .NET4

Hi ,

  I am using the

=EPMDimensionOverride("000","INT_ORDER","LBAS(10,"$J$2&")")  

If i select a  node in $J$2 with special charecters like " .Finance "  override is not working if the node is "CTO" with out any "." infront of it

it is updaing fine .

Please let me know if anyone faced this issue . I never faced this issue before some thing new ..

Best regards,

Sreedhar .

[gajendra_moond]

Hi Sreedhar

My understanding is that system treats "." as decimal point and hence reads it as a number. Therefore, the override fails.

If you can replace "." with say "_", it will work.

[sree_ravinutala]

Interesting !!! we are using this for more than year suddenly i see this problem ..

[gajendra_moond]

Are you saying that Dimension override was working earlier for the members beginning with "."?

[sree_ravinutala]

yes it was working until recently ..in hierarchies we use "." sub nodes e.g .MISC_ABC .

[gajendra_moond]

Hi Sreedhar

I have tested it a multiple times for a few scenarios. The overrride is failing only if the "." is at the beginning of the member.

On checking the log, system is throwing error for the same.