Skip to Content
avatar image
Former Member

how to transfer data from one model to another model by using destination app

Hi Experts,

I have been write a script logic for transfer data from one model to another according to the requirement i have two model one is model A and Model B:

Model A:

Account

Category

Entity Entity

Time

Rptcurrency

Audittrail

Intercompany

Flow

Model B:

Account

Category

Rptcurrency

Time

Breakup

Department

List

Intercompany

Flow

Script Logic:

*XDIM_MEMBERSET ENTITY =INR

*XDIM_MEMBERSET TIME=2017.01,2017.02,2017.03,2017.04,2017.05,2017.06,2017.07,2017.08,2017.09,2017.10,2017.11,2017.12

*X DIM_MEMBER SET RPTCURRENCY=LC

*XDIM_MEMBERSET ACCOUNT=1128 ,1129

*XDIM_ADDMEMBERSET AUDITTRAIL = SCOPA_TOTAL

*DESTINATION_APP = GL_NAV

*SKIP_DIM = BREAKUP

*WHEN CATEGORY

*IS Actual

*REC(EXPRESSION=%value%)

*ENDWHEN

Thanks

Regards

Shaik Ghous

logic.png (14.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jun 16, 2017 at 11:00 AM

    Incorrect order of statements on the screenshot! Have to write first:

    *DESTINATION_APP = GL_NAV

    *ADD_DIM AUDITTRAI...

    *SKIP_DIM

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 16, 2017 at 10:48 AM
    -1

    And what is the question point?

    Add comment
    10|10000 characters needed characters exceeded

    • "when iam trying to open the blog its not openeing" - perfectly opening, just tested! Try again!

      "In SSGL_NAV audittrail is not present when ever we gave data to ssgl_nav from their data should appear in gl_nav by keeping context as audittrail in GL_NAV" - absolutely not clear!

      "And is the above scrpit logic correct or not? if not please ensure me." - incorrect!

      First for default.lgf the logic has to be different and I explained it in my blog about default.lgf.

      Second - you have incorrect lines:

      *ADD_DIM AUDITTRAIL=Support Schedule

      *IS Dw Budget

      What do you mean by: "Support Schedule" and "Dw Budget"????

      Members with space inside ID????????????????????