Skip to Content
0
Former Member
Jun 12, 2014 at 01:26 PM

RUNALLOCATION only on existing records (no filter)

19 Views

Hi All,

I have a working allocation but want to enhance the filter to let it run for the complete dataset that has a specific value instead of a selection value from the datamanagers package.

KYF_02 NO_WBS contains the to be allocated value. KYF_03 P000001.01 AND P000001.02 contain the percentage (driver).

Source dataset:

WBS KYF SIGNEDDATA NO_WBS KYF_02 1000 P.000001.01 KYF_03 0,4 P.000001.02 KYF_03 0,6

And calculate the following blue lines:

Target:

WBS KYF SIGNEDDATA NO_WBS KYF_02 1000 P.000001.01 KYF_03 0,4 P.000001.02 KYF_03 0,6 P.000001.01 KYF_02 400 P.000001.02 KYF_02 600

Now I have the following script in place:

ALLOCATION.LGF

*XDIM_MEMBERSET WBS= NO_WBS,%WBS_SET%

*XDIM_MEMBERSET KYF= KYF_02,KYF_03

*RUNALLOCATION

*FACTOR = USING/TOTAL

*DIM WBS WHAT = NO_WBS; WHERE = %WBS_SET%; USING = <<<; TOTAL = <<<

*DIM KYF WHAT = KYF_02; WHERE = KYF_02; USING = KYF_03; TOTAL = <<<

*ENDALLOCATION

*COMMIT

My question is this: Is it possible to not run the script with a input parameter from the Datamanager packages but on the dataset for every existing WBS which has a value on KYF_03? Now I have to select all applicable WBSs manually which needs to be enhanced. (60.000 + WBSs).

Hope someone can help.

Kind regards,

Vincent Beumer