on 06-12-2014 2:26 PM
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
Hi Vincent,
Try scoping WBS as <ALL> instead of NO_WBS,%WBS_SET%.
Gersh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vincent,
Yes, when BPC extracts data from the Model it will put all WBS in selection criteria, but when it does allocations it will use only records that were extracted.
So,if user selected 1 WBS and you want to use all WBSs in allocations of course you are going to see performance degradation, but this should be expected. When user selected 100 WBSs and all of them have transaction data then you shouldn't see any slow down.
Regards,
Gersh
Hi,
Have considered adding a property "Key_figure" in your WBS dimension to identify which members to process.
Obviously, you have to consider :
Hope it helps.
prat
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vincent,
Can you explain the business scenario? What happens if you select all WBS?
Vadim
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You said - 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?
When you pass the WBS members from DM package, how do you know for what all members KYF.03 has got data?
Regards,
Ashish
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
15 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.