Copy from application A to application B using Destination_App

[Former Member]

Hi experts,

I have 2 applications with the following dimensions:

application A (account,bookctry,category,custid,datasrc,destctry,entity,inputcurrency,origctry,ps,psl,salectry,service,time)

application B (account,category,custid,datasrc,entity,inputcurrency,psl,service,time,views)

I would like to copy all the records from application A with Entity=Logistics to be copied into application B

the logic is in default.lgf as follows:

*DESTINATION_APP=LOGISTIC

*SKIP_DIM=BOOKCTRY

*SKIP_DIM=DESTCTRY

*SKIP_DIM=PROFITSHARING

*SKIP_DIM=SALECTRY

*SKIP_DIM=SERVICE

*SKIP_DIM=ORIGCTRY

*ADD_DIM VIEWS=OPS

*WHEN ENTITY

*IS "LOGISTIC"

*REC(EXPRESSION=%VALUE%)

*ENDWHEN

*COMMIT

I input and send some data in application A, however I do not see the data being copied into application B. I'm not sure what is wrong and whether the logic correct?

Please help. Thanks

Rgds

PH

[Former Member · Accepted solution]

You may need some additional information in the script depending on how you are initiating the logic statement. If you are running this as a package, you would be selecting the ENTITY member. If you are running this from default logic, you may need to add the statement

*XDIM_MEMBERSET ENTITY = LOGISTICS

Plus you may need to pass more dimension members with XDIM statements when using default logic when it runs at the time of a data SEND. The XDIM adds the selected members to the data ste that is queried for the logic, so if the input doesn't have the required memebrs to review and pass, you will not get the appropriate output sent to the other application.

Plus, review the script. It appears that you cube is named LOGISTIC, and the "*IS" statement looks for "LOGISTIC" rather than "LOGISTICS", the entity ID.

Hope this helps.