Skip to Content
0
Former Member
Jan 28, 2011 at 02:44 PM

Default Logic Optimization

15 Views

Hello All,

I have built a BADI and I am using it in Default logic. I have included scoping statements in my default logic to get all the information for my BADI. If I look at my default log, the total execution of default logic is 3 mins, out of which 165 seconds is in the query read prior to execution of the BADI. BADI executes only for 10 seconds. How can I decrease this query time? I do have employee dimension with 20,000 members. I use

*XDIM_MEMBERSET EMPLOYEE=<ALL> to get everyone as I am calculating Labor costs at Employee level. Script I have in default logic is:

*XDIM_MEMBERSET TIME = %YEAR%.INP

*XDIM_MEMBERSET JOB = <ALL>

*XDIM_MEMBERSET P_ACCT = FTE,HR_RATE,MNTHLY_PREM_PAY,OT_RATE

*XDIM_MEMBERSET EMPLOYEE = <ALL>

*START_BADI LABOR

QUERY = ON

WRITE = ON

*END_BADI

Any ideas and help is appreciated.

Thanks!