on 2016 Aug 31 9:59 AM
Request clarification before answering.
Dear All,
Thanks for reply
Script posted previously worked with small changes
Previous only 11 dimension out of 12 was used in script for scoping the data for BADI. When 12th dimension was used in scoping, it started working from default itself.
Lesson learned:
1. %DIM_SET% collects the value posted through input templates.
2. Scoping for all dimension needs to be provided when it is running through default logic.( I am not sure whether it is a standard rule or not, but it worked in our case).
Regards
Tarun Agarwal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
"Scoping for all dimension needs to be provided when it is running through default logic.( I am not sure whether it is a standard rule or not, but it worked in our case)" - strange statement!
Scoping is required only if you want to include some members that are missing in the sent data!
And anyway, your default.lgf will work correctly only with some templates, it's not universal...
Also I see a lot of fixed scopes (not related to the scope of sent data)! If you fix scope then badi will run with this scope independent on the data sent - not sure it's fine.
By the way, if you want to use badi to calculate something in default.lgf it's better not to use default.lgf and custom logic badi but to create write back badi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
%DIM_SET% is not works in default logic.
In my case i want to use below given these three condition in logic script scoping and same i want to be runs in Default Logic.
*SELECT(%ENTI1%,COMPANY_CODE,COST_CENTER,BUSINESS_AREA=%BUS_AREA_SET%)
*SELECT(%TIME1%,YEAR,TIME,ID=%TIME_SET%)
*SELECT(%FCST%,PLAN_FCST,CATEGORY,ID=%CATEGORY_SET%)
And of applying this three condition I want to used member getting saved or from context of input template.
So how can I do this.
Please guide for the same.
Best Regards,
Tarun Agarwal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Tarun,
I dont think Vadim's explanations in the document are so hard to understand!
Anyways, Why are you passing the scope using SELECT statement. I am not an expert in script logic, but I would suggest to do all scopings, selective filtering of members in BADI itself unless you have any user specific selections to be passed to BADI for calculations because you are using default logic not some script logic! If not in BADI add all the 3 dimensions in the report with member required!
Regards,
JP
Hi tarun,
Please use Vadim's document to write the logic properly in default.....http://scn.sap.com/docs/DOC-55628
If your running through default, how will %DIM_SET% work????
Regards,
JP
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Vadim,
Thanks for reply..
We want to write the dynamic scoping for custom badi based on time, category & business area entered through input template.
Trying to write below condition to achieve dynamic variable to make scoping dynamic.
*SELECT(%ENTI1%,COMPANY_CODE,COST_CENTER,BUSINESS_AREA=%BUS_AREA_SET%)
Company code based on Business area entered in input sheet
*SELECT(%TIME1%,YEAR,TIME,ID=%TIME_SET%)
Year based on time enter in input sheet
*SELECT(%FCST%,PLAN_FCST,CATEGORY,ID=%CATEGORY_SET%)
Plan category based on forecast category entered in input sheet.
This is working through DMP and not working through default.
Regards
Tarun
It's possible to have dynamic scoping with default.lgf, but I don't see any input form samples to understand what data you are sending to the cube!
By the way in default.lgf the scope will be a sum of all scopes of changed data. It means that the script will not work correctly for any input form (if different members are updated)
| User | Count |
|---|---|
| 8 | |
| 8 | |
| 7 | |
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.