Using @SUBSTRING() in @XWRITE is failing
Hello,
I'd like to rewrite a few Essbase scripts by combining the logic into one script using @relative().
I have a source app, called SRCAPP and a target app TGTAPP. On the source app, I combined the logic of multiple scripts, however, I get a error msg on runtime execution.
In the source app, dimension "Plance" contains the following members:
AAB00-100
AAC00-101
BGD00-456
etc.
In the target app, dimension "PlanceX" has the following members:
AAB00
AAC00
BGD00
etc.
and dimension PlanceY has the following members:
100
101
456
etc
fix ( @relative( "Plance", 0 ), "Actual", "Jan", "CC_SRC" )
I'd like to rewrite a few Essbase scripts by combining the logic into one script using @relative().
I have a source app, called SRCAPP and a target app TGTAPP. On the source app, I combined the logic of multiple scripts, however, I get a error msg on runtime execution.
In the source app, dimension "Plance" contains the following members:
AAB00-100
AAC00-101
BGD00-456
etc.
In the target app, dimension "PlanceX" has the following members:
AAB00
AAC00
BGD00
etc.
and dimension PlanceY has the following members:
100
101
456
etc
fix ( @relative( "Plance", 0 ), "Actual", "Jan", "CC_SRC" )
"Acct_SRC" (
@xwrite( "Payroll", _tgtplan_, "Actual", "Acct_TGT",
@xwrite( "Payroll", _tgtplan_, "Actual", "Acct_TGT",
Tagged:
0