duplicate data when use *DESTIANTION_APP

[Former Member]

Hi all,

I am using the command *DESTINATION_APP to copy data from 1 model to another model.

In my case, it is from model GOODWILL to model Consolidation.

But, when data is copied from GOODWILL to Consolidation, it is duplicate to 19 time.

Does anyone has this error too? And do you have solution for this error.

My logic script is below:

*XDIM_MEMBERSET TIME = %TIME_SET%

*XDIM_MEMBERSET FLOW = F_CB

*DESTINATION_APP = Consolidation

*SKIP_DIM = C_ITEM

*ADD_DIM AUDITTRAIL = GOODWILL

*WHEN FLOW

*IS F_CB

*REC(FACTOR = 1)

*ENDWHEN

note: %TIME_SET% is parameter pass from data package management.

Please, help me to solve this problem.

Thanks,

Thai.

[former_member186338 · Accepted solution]

Hi Bui,

Please provide additional info in line with:

Show data samples and UJKT results...

Describe C_ITEM dimension.

Vadim

[Former Member · Accepted solution]

Hi Vadim,

Thanks for the guide.

I have to copy data to model Consolidation from model GOODWILL.

My Consolidation data have these dimension:

ACCOUNT

AUDITTRAIL

CATEGORY

ENTITY

FLOW

INTERCO

RPTCURRENCY

SCOPE

TIME

My GOODWILL model have these dimension:

ACCOUNT

CATEGORY

C_ITEM  " this dimesion is my cusomize dimension, which is identify the goodwill.

ENTITY

FLOW

INTERCO

RPTCURRENCY

SCOPE

TIME

My script is use only for copy data from GOODWILL to Consolidation, which has FLOW = F_CB and Time in %TIME_SET%.

In UJKT we test this script with Data Region:

ACCOUNT = 2690000000

TIME=2014.05

CATEGORY=Actual

ENTITY=AA01

CURRENCY=VND

SCOPE = G_VIN

C_ITEM = GW. AA01 - AA01

SIGNEDDATA = 918.770,9157286- (this is expected result too, but it is multy 16 time in result, i don't know but this time it is 16 time, not 19 time like before)

RESULT in UJKT

LGX:

*XDIM_MEMBERSET TIME = 2014.05

*XDIM_MEMBERSET FLOW = F_CB

*DESTINATION_APP = Consolidation

*SKIP_DIM = C_ITEM

*ADD_DIM AUDITTRAIL = GOODWILL

*WHEN FLOW

*IS F_CB

*REC(FACTOR = 1)

*ENDWHEN

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

LOG:

LOG BEGIN TIME:2015-01-08 14:54:01

FILE:\ROOT\WEBFOLDERS\VINSHELL \ADMINAPP\GOODWILL\TEST.LGF

USER:FPT-THAIBV2

APPSET:VINSHELL

APPLICATION:GOODWILL

[INFO] GET_DIM_LIST(): I_APPL_ID="GOODWILL", #dimensions=10

ACCOUNT,CATEGORY,C_ITEM,ENTITY,FLOW,INTERCO,MEASURES,RPTCURRENCY,SCOPE,TIME

#dim_memberset=2

TIME:2014.05,1 in total.

FLOW:F_CB,1 in total.

REC :%value%*(1)

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 8.00 ms. 128  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

CALCULATION TIME IN TOTAL :0.00 ms.

8  RECORDS ARE GENERATED.

CALCULATION END.

ENDWHEN ACCUMULATION: 8  RECORDS ARE GENERATED.

DATA TO WRITE BACK:

ACCOUNT AUDITTRAIL CATEGORY ENTITY FLOW INTERCO RPTCURRENCY SCOPE TIME SIGNEDDATA

2690000000 GOODWILL Actual AA01 F_CB I_AA01 VND G_VIN 2014.05 - 14700334.65 (multi by 16 time)

2690000000 GOODWILL Actual AA01 F_CB I_CD06 VND G_VIN 2014.05 - 198466.59

2690000000 GOODWILL Actual AA01 F_CB I_AB05 VND G_VIN 2014.05 - 266666.67

2690000000 GOODWILL Actual AB01 F_CB I_AA01 VND G_VIN 2014.05 - 146369.88

6428888880 GOODWILL Actual AA01 F_CB I_AA01 VND G_VIN 2014.05 14700334.65

6428888880 GOODWILL Actual AA01 F_CB I_CD06 VND G_VIN 2014.05 198466.59

6428888880 GOODWILL Actual AA01 F_CB I_AB05 VND G_VIN 2014.05 266666.67

6428888880 GOODWILL Actual AB01 F_CB I_AA01 VND G_VIN 2014.05 146369.88

8  RECORDS HAVE BEEN WRITTEN BACK.

WRITING TIME :0.00  ms.

SCRIPT RUNNING TIME IN TOTAL:8.00 s.

LOG END TIME:2015-01-08 14:54:09

Thanks,

[former_member186338 · Accepted solution]

I think that the issue is with C_ITEM - you have multiple members and the aggregation happens!

Check without DESTINATION_APP - write the same value to the same place:

*XDIM_MEMBERSET CATEGORY = Actual

*XDIM_MEMBERSET ENTITY = AA01

*XDIM_MEMBERSET INTERCO=I_AA01

*XDIM_MEMBERSET RPTCURRENCY=VND

*XDIM_MEMBERSET SCOPE=G_VIN

*XDIM_MEMBERSET TIME = 2014.05

*XDIM_MEMBERSET FLOW = F_CB

*WHEN FLOW

*IS * //already scoped to F_CB

*REC(FACTOR = 1)

*ENDWHEN

Show the records generated!

Vadim

[Former Member · Accepted solution]

Hi Vadim,

The result is still multi 16 time.

The result is below:

*XDIM_MEMBERSET CATEGORY = Actual

*XDIM_MEMBERSET ENTITY = AA01

*XDIM_MEMBERSET INTERCO=I_AA01

*XDIM_MEMBERSET RPTCURRENCY=VND

*XDIM_MEMBERSET SCOPE=G_VIN

*XDIM_MEMBERSET TIME = 2014.05

*XDIM_MEMBERSET FLOW = F_CB

*WHEN FLOW

*IS *

*REC(FACTOR = 1)

*ENDWHEN

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

LOG:

LOG BEGIN TIME:2015-01-08 15:42:08

FILE:\ROOT\WEBFOLDERS\VINSHELL \ADMINAPP\GOODWILL\TEST.LGF

USER:FPT-THAIBV2

APPSET:VINSHELL

APPLICATION:GOODWILL

[INFO] GET_DIM_LIST(): I_APPL_ID="GOODWILL", #dimensions=10

ACCOUNT,CATEGORY,C_ITEM,ENTITY,FLOW,INTERCO,MEASURES,RPTCURRENCY,SCOPE,TIME

#dim_memberset=7

CATEGORY:Actual,1 in total.

ENTITY:AA01,1 in total.

INTERCO:I_AA01,1 in total.

RPTCURRENCY:VND,1 in total.

SCOPE:G_VIN,1 in total.

TIME:2014.05,1 in total.

FLOW:F_CB,1 in total.

REC :%value%*(1)

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 8.00 ms. 32  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

CALCULATION TIME IN TOTAL :0.00 ms.

2  RECORDS ARE GENERATED.

CALCULATION END.

ENDWHEN ACCUMULATION: 2  RECORDS ARE GENERATED.

DATA TO WRITE BACK:

ACCOUNT CATEGORY C_ITEM ENTITY FLOW INTERCO RPTCURRENCY SCOPE TIME SIGNEDDATA

2690000000 Actual GW. AA01 - AA01 AA01 F_CB I_AA01 VND G_VIN 2014.05 - 14700334.65 (multi by 16 time)

6428888880 Actual GW. AA01 - AA01 AA01 F_CB I_AA01 VND G_VIN 2014.05 14700334.65

2  RECORDS HAVE BEEN WRITTEN BACK.

WRITING TIME :0.00  ms.

SCRIPT RUNNING TIME IN TOTAL:8.00 s.

LOG END TIME:2015-01-08 15:42:16

Thanks,

[former_member186338 · Accepted solution]

Ok,

I think the issue is with member ID: For C_ITEM you have incorrect syntax for member ID:

GW. AA01 - AA01

Containing spaces!!!! It will create issues in many areas like script logic, formulas, etc...!

Use something like:

GW_AA01_AA01

Vadim

[Former Member · Accepted solution]

Hi vadim,

Many thanks for your help, but after i delete all the master data in C_ITEM, create new one "GW_1".

But after run script, the result is still multi 16 time.

Do you know another cause for this problem?

Thanks

[former_member186338 · Accepted solution]

Always provide UJKT log!

Test:

*XDIM_MEMBERSET CATEGORY = Actual

*XDIM_MEMBERSET ENTITY = AA01

*XDIM_MEMBERSET INTERCO=I_AA01

*XDIM_MEMBERSET RPTCURRENCY=VND

*XDIM_MEMBERSET SCOPE=G_VIN

*XDIM_MEMBERSET C_ITEM=GW_1

*XDIM_MEMBERSET ACCOUNT=2690000000

*XDIM_MEMBERSET TIME = 2014.05

*XDIM_MEMBERSET FLOW = F_CB

*WHEN FLOW

*IS *

*REC(FACTOR = 1)

*ENDWHEN

[Former Member · Accepted solution]

Hi Vadim,

This is data in bw

ACCOUNT = 2690000000

TIME=2014.05

CATEGORY=Actual

ENTITY=AA01

CURRENCY=VND

SCOPE = G_VIN

C_ITEM = GW_1

SIGNEDDATA = 4.136,9863014

This is the UJKT result.

LGX:

*XDIM_MEMBERSET CATEGORY = Actual

*XDIM_MEMBERSET ENTITY = AA01

*XDIM_MEMBERSET INTERCO=I_AA01

*XDIM_MEMBERSET RPTCURRENCY=VND

*XDIM_MEMBERSET SCOPE=G_VIN

*XDIM_MEMBERSET C_ITEM=GW_1

*XDIM_MEMBERSET ACCOUNT=2690000000

*XDIM_MEMBERSET TIME = 2014.05

*XDIM_MEMBERSET FLOW = F_CB

*WHEN FLOW

*IS *

*REC(FACTOR = 1)

*ENDWHEN

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

LOG:

LOG BEGIN TIME:2015-01-08 16:55:22

FILE:\ROOT\WEBFOLDERS\VINSHELL \ADMINAPP\GOODWILL\TEST.LGF

USER:FPT-THAIBV2

APPSET:VINSHELL

APPLICATION:GOODWILL

[INFO] GET_DIM_LIST(): I_APPL_ID="GOODWILL", #dimensions=10

ACCOUNT,CATEGORY,C_ITEM,ENTITY,FLOW,INTERCO,MEASURES,RPTCURRENCY,SCOPE,TIME

#dim_memberset=9

CATEGORY:Actual,1 in total.

ENTITY:AA01,1 in total.

INTERCO:I_AA01,1 in total.

RPTCURRENCY:VND,1 in total.

SCOPE:G_VIN,1 in total.

C_ITEM:GW_1,1 in total.

ACCOUNT:2690000000,1 in total.

TIME:2014.05,1 in total.

FLOW:F_CB,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.

DATA TO WRITE BACK:

ACCOUNT CATEGORY C_ITEM ENTITY FLOW INTERCO RPTCURRENCY SCOPE TIME SIGNEDDATA

2690000000 Actual GW_1 AA01 F_CB I_AA01 VND G_VIN 2014.05 - 66191.78

1  RECORDS HAVE BEEN WRITTEN BACK.

WRITING TIME :0.00  ms.

SCRIPT RUNNING TIME IN TOTAL:0.00 s.

LOG END TIME:2015-01-08 16:55:22

[former_member186338 · Accepted solution]

In the log you can see that single record is selected and the value is written over itself.

Then your assumption that: SIGNEDDATA = 4.136,9863014

Is incorrect!

Show the EPM report screenshot (not RSA1 figures!!!) for:

CATEGORY = Actual

ENTITY = AA01

ITERCO=I_AA01

RPTCURRENCY=VND

SCOPE=G_VIN

C_ITEM=GW_1

ACCOUNT=2690000000

TIME = 2014.05

FLOW = F_CB

By the way GOODWILL model is YTD or Periodic?

Vadim

P.S. If you read

Then it's specially mentioned in point 9!

[Former Member · Accepted solution]

Hi Vadim,

Many thanks for your answer, you are correct about the C_ITEM member. But now, i have another issue, that only when i use the *XDIM_MEMBERSET for ACCOUNT, the result is correct; but when i don't use this command for ACCOUNT, the result will multi 16 time.

Expected result is 4.136,9863014

This is my UJKT result

LGX:

*XDIM_MEMBERSET CATEGORY = Actual

*XDIM_MEMBERSET ENTITY = AA01

*XDIM_MEMBERSET INTERCO=I_AA01

*XDIM_MEMBERSET RPTCURRENCY=VND

*XDIM_MEMBERSET SCOPE=G_VIN

*XDIM_MEMBERSET TIME = 2014.05

*XDIM_MEMBERSET FLOW = F_CB

*WHEN ACCOUNT

*IS *

*REC(FACTOR = 1)

*ENDWHEN

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

LOG:

LOG BEGIN TIME:2015-01-08 18:48:44

FILE:\ROOT\WEBFOLDERS\VINSHELL \ADMINAPP\GOODWILL\TEST.LGF

USER:FPT-THAIBV2

APPSET:VINSHELL

APPLICATION:GOODWILL

[INFO] GET_DIM_LIST(): I_APPL_ID="GOODWILL", #dimensions=10

ACCOUNT,CATEGORY,C_ITEM,ENTITY,FLOW,INTERCO,MEASURES,RPTCURRENCY,SCOPE,TIME

#dim_memberset=7

CATEGORY:Actual,1 in total.

ENTITY:AA01,1 in total.

INTERCO:I_AA01,1 in total.

RPTCURRENCY:VND,1 in total.

SCOPE:G_VIN,1 in total.

TIME:2014.05,1 in total.

FLOW:F_CB,1 in total.

REC :%value%*(1)

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 8.00 ms. 32  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

CALCULATION TIME IN TOTAL :0.00 ms.

2  RECORDS ARE GENERATED.

CALCULATION END.

ENDWHEN ACCUMULATION: 2  RECORDS ARE GENERATED.

DATA TO WRITE BACK:

ACCOUNT CATEGORY C_ITEM ENTITY FLOW INTERCO RPTCURRENCY SCOPE TIME SIGNEDDATA

2690000000 Actual GW_1 AA01 F_CB I_AA01 VND G_VIN 2014.05 - 66191.78

6428888880 Actual GW_1 AA01 F_CB I_AA01 VND G_VIN 2014.05 66191.78

2  RECORDS HAVE BEEN WRITTEN BACK.

WRITING TIME :0.00  ms.

SCRIPT RUNNING TIME IN TOTAL:8.00 s.

LOG END TIME:2015-01-08 18:48:52

Thanks,

[former_member186338 · Accepted solution]

In the script like:

*XDIM_MEMBERSET CATEGORY = Actual

*XDIM_MEMBERSET ENTITY = AA01

*XDIM_MEMBERSET INTERCO=I_AA01

*XDIM_MEMBERSET RPTCURRENCY=VND

*XDIM_MEMBERSET SCOPE=G_VIN

*XDIM_MEMBERSET TIME = 2014.05

*XDIM_MEMBERSET FLOW = F_CB

*WHEN ACCOUNT

*IS *

*REC(FACTOR = 1)

*ENDWHEN

No accumulation is possible!

And I see in the log:

QUERY TIME : 8.00 ms. 32  RECORDS QUERIED OUT.

2  RECORDS ARE GENERATED.

ENDWHEN ACCUMULATION: 2  RECORDS ARE GENERATED.

No accumulation - from 32 records - 30 have to be zeros! Check data in the EPM report!

And show the report screenshot.

Vadim

[Former Member · Accepted solution]

Hi Vadim,

After testing again i see that there is some dimension member in ACCOUNT not follow the syntax you give. So i replace them by other and solve the problem.

Thanks you very much for your help.

Thai.