topic SAP high workload when qlikview reload via SAP connector in QlikView

SAP high workload when qlikview reload via SAP connector

Fri, 25 Feb 2011 09:50:05 GMT

Dear Guru,

Just received the feedback from SAP basis team the SAP workload is very high when qlikview reload from SAP.

Can anyone please advice if there is any way that something can be done to optimize the problem?

SAP high workload when qlikview reload via SAP connector

suniljain — Fri, 25 Feb 2011 11:26:46 GMT

if you are extracting cluster table then definitely it high workload in SAP.

because it is cluster in nature.

I will suggest you to extract huge table with related header table.

LIKP ->LIPS,

MKPF->MSEG,

BKPF->BSEG,

etc.....

if you require any help pls reply me.

SAP high workload when qlikview reload via SAP connector

disqr_rm — Mon, 11 Apr 2011 01:15:20 GMT

If you are putting WHERE conditions in your queries at QV side, please consider creating secondary indexes at SAP side for those fields in the table. Now you may not want to create too many indexes in SAP and your BASIS group may have concerns about it. In that case, you may want to optimize your queries to use any existing indexes and may be extract more data than you need and then filter records at QV side.

If you have problem with any specific table/fields you may post here.

SAP high workload when qlikview reload via SAP connector

suniljain — Mon, 11 Apr 2011 11:01:47 GMT

if you put copmlex where condition during extraction it will definitely slow extraction peocess. and also put extra load sap r/3 system.

try to put where condition on QVD.

Re: SAP high workload when qlikview reload via SAP connector

Mon, 28 Jan 2013 01:31:45 GMT

Hi Sunil,

What do you mean by "extract huge table with related header table"?

Because I'm also planning to optimize our data extraction. Would you give me some tips?

Thank you.

Regards,

Lester

Re: SAP high workload when qlikview reload via SAP connector

Mon, 28 Jan 2013 01:31:53 GMT

Hi Sunil,

What do you mean by "extract huge table with related header table"?

Because I'm also planning to optimize our data extraction. Would you give me some tips?

Thank you.

Regards,

Lester

Re: SAP high workload when qlikview reload via SAP connector

Mon, 28 Jan 2013 01:32:02 GMT

Hi Sunil,

What do you mean by "extract huge table with related header table"?

Because I'm also planning to optimize our data extraction. Would you give me some tips?

Thank you.

Regards,

Lester

Re: SAP high workload when qlikview reload via SAP connector

Mon, 28 Jan 2013 01:32:28 GMT

Hi Sunil,

What do you mean by "extract huge table with related header table"?

Because I'm also planning to optimize our data extraction. Would you give me some tips?

Thank you.

Regards,

Lester