Skip to Content

Script logic Look up In same model

Hi Guys,

I have requirement to read data from at Higher level (Costcenter,JOb,IO level) which is entered by planners and assign it to detail level (Costcenter,Job,Position,IO level) transaction data.

Position is property of JOb but i don't want read all the positions from JOb and i want assign the JOb level planned IO percentages to Postions which is already planned (transaction data). Can i use the LOOK up to read data from JOb level and assign it to Position level. Can anyone share the some pseudo code for using Look up to read data from one set of data and assign it to another set of data.

Scope of data at JOB level:

*XDIM_MEMBERSET DATATAG= DT_PEXP_TMAL

*XDIM_MEMBERSET HRACCT= ALLOC_PCT

*XDIM_MEMBERSET EMPLOYEE= No_EMPLOYEE

*XDIM_MEMBERSET HRPOSITION= NO_HRPOSITION

*XDIM_MEMBERSET COSTCENTER= %COSTCENTER_SET%

*XDIM_MEMBERSET JOB= %JOB_SET%

*XDIM_MEMBERSET SKF=NO_SKF


There could be one more IO (Internal Order) Percentages planned at JOB level.

Data is something like this.


Datatag HRAcct Employee HRPosition Costcenter JOb SKF IO Measure(KF)

Dt1 acct1 No_EMP NO_Positon CC1 Job1 No_SKF IO1 60%

IO2 40%



Scope of data Position level (transcation data which is already planned)

*XDIM_MEMBERSET DATATAG= DT_PEXP_TMAL

*XDIM_MEMBERSET HRACCT= ALLOC_PCT

*XDIM_MEMBERSET EMPLOYEE= No_EMPLOYEE

*XDIM_MEMBERSET COSTCENTER= %COSTCENTER_SET%

*XDIM_MEMBERSET JOB= %JOB_SET%

*XDIM_MEMBERSET SKF=NO_SKF


Existing Data at Position level in the system


Datatag HRAcct Employee HRPosition Costcenter JOb SKF IO Measure(KF)

Dt1 acct1 No_EMP POS1 CC1 Job1 SKF1 IO3 50%

IO4 50%

So i want to read data from JOb level assign it to Positon level data

My output should be like this

Datatag HRAcct Employee HRPosition Costcenter JOb SKF IO Measure(KF)

Dt1 acct1 No_EMP POS1 CC1 Job1 SKF1 IO1 60%

IO2 40%

Can anyone share you ideas on this how to read data from JOb level and assign it to Posiiton level using Look up or something.

Thanks in advance.

Thanks

Best regards

SG

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Jan 13, 2016 at 04:43 PM

    Sorry, but what is the issue?

    You can use RUNALLOCATION to copy NO_HRPOSITION value to all required positions:


    *RUNALLOCATION

    *FACTOR=1

    *DIM HRPOSITION WHAT=NO_HRPOSITION; WHERE=POS1,POS2

    *ENDALLOCATION


    Instead of POS1,POS2 you can use BAS(...) or some variable %POSITIONS% with a list of positions


    Vadim

    Add a comment
    10|10000 characters needed characters exceeded

    • Lookup will not help you!

      And unfortunately the requirements are not logically defined...

      Also you always use incorrect wording - like "charge to any sender_io" - absolutely incorrect. You can't change dimension member for record, you can create a new record for another intersection. It's not a table it's a cube!

      You script is wrong, but without clear logic I can't propose a solution...

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.