Invalid members using ADD_DIM and dimension property

[Former Member]

Hi experts, I am facing an issue when using a dimension property to transfer among models with Logic Script, namely it is not reading a property when using *DESTINATION_APP. Here's my scenario:

• My source model does not have an INTERCO dimension, the destination model (Consolidation) does have an INTERCO dimension.
• The source model uses an ACCOUNT dimension called ACCOUNT_USGAAP, whereas in the destination model, the ACCOUNT dimension is called ACCOUNT_IFRS.
• The source model's account dim has a property called INTERCOMAP, which contains valid INTERCO dimension member IDs as I_NONE, I_E1, I_E2, I_UNASSIGNED

When running my transfer script I get "Invalid members [INTERCO]=" as if the property INTERCOMAP weres blank and thus resulting in error. I have checked many times and the dimension is processed and has a valid INTERCO as value. My script is:

*DESTINATION_APP = Consolidation

*ADD_DIM INTERCO = ACCOUNT_USGAAP:INTERCOMAP
*ADD_DIM AUDIT_TRAIL = INPUT, FLOW = F10, SCOPE = S_NONE, CURRENCY = LC
*RENAME_DIM ACCOUNT_IFRS = ACCOUNT_USGAAP

*WHEN ACCOUNT_LOCALTB.ACCTYPE
*IS "INC", "EXP"
    *REC(FACTOR = 1, ACCOUNT_LOCALTB = ACCOUNT_USGAAP.ACCTMAP)
*ENDWHEN

*COMMIT

Any idea why it is returning blank even though I have values on the INTERCOMAP property? Thanks!

[former_member186338 · Accepted solution]

Hi Ivan,

Unfortunately you are not providing the full script, the member list of ACCOUNT_USGAAP with INTERCOMAP property and UJKT logs...

But, please add the following:

*SELECT(%ACCTRANS%,"[ID]",ACCOUNT_USGAAP,"[INTERCOMAP]<>''")

*XDIM_MEMBERSET ACCOUNT_USGAAP=%ACCTRANS%

Please read

Vadim

P.S. Never use USELESS COMMIT with WHEN/ENDWHEN...

[Former Member · Accepted solution]

Hi Vadim, thanks for the feedback I was unsure on the use of COMMIT so I ended up using it always at the end so nice to know. I just tried the scoping for non-blank property values and still not working so here's my detailed scenario:

• I am using SAP BPC 10.1 NW SP03 (Standard) with calc engine ABAP
• What I want to achieve with the logic is transfer data among two models: DataCollect -> Consolidation
• Account dimension in DataCollect is different than the one in the Consolidation model and has two properties, ACCTMAP and INTERCOMAP. The former (ACCTMAP) defines the target Account member and the latter (INTERCOMAP) defines the target Intercompany member in the Consolidation model.
• I want to do this on the default logic of DataCollect model, however I've been testing it with UJKT and also as user package with same result.

My models look like this:

DataCollect

----

VERSION (Category)

ACCOUNT_USGAAP (Account)

TIME (Time)

ENTITY (Entity)

Consolidation

----

VERSION (Category)

ACCOUNT_IFRS (Account)

TIME (Time)

ENTITY (Entity)

INTERCO (Intercompany)

AUDIT_TRAIL (Datasource / Audit Trail)

FLOW (Subtable / Flow)

SCOPE (Group / Scope)

CURRENCY (Rate)

Example for ACCOUNT_USGAAP member:

ID               | Description            | ACCTYPE | ACCTMAP  | INTERCOMAP

300001-00 | Retained earnings | LEQ           | 241005       | I_NONE

Example for ACCOUNT_IFRS member (destination model):

ID         | Description             | ACCTYPE

241005 | Retained earnings | LEQ

Example for INTERCO member (destination model):

ID           | Description

I_NONE | Intecompany None

My script:

*XDIM_MEMBERSET VERSION = ACTUAL

*XDIM_MEMBERSET ACCOUNT_USGAAP = 300001-00

*XDIM_MEMBERSET TIME = 2015.01

*XDIM_MEMBERSET ENTITY = USA

*DESTINATION_APP = Consolidation

*ADD_DIM INTERCO = ACCOUNT_USGAAP:INTERCOMAP

*ADD_DIM AUDIT_TRAIL = INPUT

*ADD_DIM FLOW = F99

*ADD_DIM SCOPE = S_NONE

*ADD_DIM CURRENCY = LC

*RENAME_DIM ACCOUNT_IFRS = ACCOUNT_USGAAP

*WHEN ACCOUNT_USGAAP.ACCTYPE

*IS AST, LEQ

     *REC(FACTOR = 1, ACCOUNT_USGAAP = ACCOUNT_USGAAP.ACCTMAP)

*ENDWHEN

Data Region in UJKT:

VERSION = ACTUAL

ACCOUNT_USGAAP = 300001-00

TIME = 2015.01

ENTITY = USA

Value in this Data Region is - 220000000.00

Result:

LGX:

*XDIM_MEMBERSET ACCOUNT_USGAAP = 30001-00

*XDIM_MEMBERSET VERSION = ACTUAL

*XDIM_MEMBERSET TIME = 2015.01

*XDIM_MEMBERSET ENTITY = USA

*DESTINATION_APP = Consolidation

*ADD_DIM INTERCO = ACCOUNT_USGAAP:INTERCOMAP

*ADD_DIM AUDIT_TRAIL = INPUT

*ADD_DIM FLOW = F99

*ADD_DIM SCOPE = S_NONE

*ADD_DIM CURRENCY = LC

*RENAME_DIM ACCOUNT_USGAAP = ACCOUNT_IFRS

*WHEN ACCOUNT_USGAAP.ACCTYPE

*IS AST, LEQ

*REC(FACTOR = 1, ACCOUNT_USGAAP = ACCOUNT_USGAAP.ACCTMAP)

*ENDWHEN

-------------------------------------------------------------------------------------------------------------------------------------

LOG:

LOG BEGIN TIME:2015-06-02 17:38:42

FILE:\ROOT\WEBFOLDERS\XXXXX \ADMINAPP\DataCollect\TEST.LGF

USER:XXXXX (is Admin user)

APPSET:XXXXX

APPLICATION:DataCollect

[INFO] GET_DIM_LIST(): I_APPL_ID="DataCollect", #dimensions=5

ACCOUNT_USGAAP,ENTITY,MEASURES,TIME,VERSION

#dim_memberset=4

ACCOUNT_USGAAP:30001-00,1 in total.

VERSION:ACTUAL,1 in total.

TIME:2015.01,1 in total.

ENTITY:USA,1 in total.

REC :%value%*(1)

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 1  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

CALCULATION TIME IN TOTAL :0.00 ms.

1  RECORDS ARE GENERATED.

CALCULATION END.

ENDWHEN ACCUMULATION: 1  RECORDS ARE GENERATED.

Invalid Members [INTERCO]=

1 RECORDS ARE Rejected:

ACCOUNT_IFRS AUDIT_TRAIL CURRENCY ENTITY FLOW INTERCO SCOPE TIME VERSION SIGNEDDATA ERROR MESSAGE

241005 DATACOL LC USA F99 S_NONE 2015.01 ACTUAL - 220000000.00

0  RECORDS HAVE BEEN WRITTEN BACK.

WRITING TIME :0.00  ms.

SCRIPT RUNNING TIME IN TOTAL:0.00 s.

LOG END TIME:2015-06-02 17:38:42

[former_member186338 · Accepted solution]

Hi Ivan,

Some comments:

1. SAP BPC 10.1 NW SP03 is a bit old... better upgrade to the latest!

2. The correct syntax of ADD_DIM is (look help - single line!):

*ADD_DIM INTERCO = ACCOUNT_USGAAP:INTERCOMAP, AUDIT_TRAIL = INPUT, FLOW = F99, SCOPE = S_NONE, CURRENCY = LC

3. Account ID 30001-00 with "-" inside is not perfect test another!

Vadim

[Former Member · Accepted solution]

Thanks for the suggestions, I ended up adding the INTERCO dimension to the source model as well. I don't like that solution because it adds overhead to my model but since I only had 5 dims I decided to do it this way to stop torturing myself with this issue.

[former_member186338 · Accepted solution]

It's definitely an absolutely bad decision - adding useless dimension! Will affect performance and complexity!

Vadim