BBP_BW_SC_SELECT_1 performance

[Former Member]

Hi,

while using BBP_BW_SC_SELECT_1 to get shopping cart per multi cost centers i get error time.

i searched for an OSS NOTE to better the performance but i didn't find any.

has anybody an idea about the following issue.

BR

[Former Member · Accepted solution]

hi,

the following OSS bettered the function performance 1787319.

BR

[konstantin_anikeev · Accepted solution]

Hi,

have you measured, how much faster it runs now?

Regards

Konstantin

[Former Member · Accepted solution]

It's much faster, but i can not compare because i didn't register the previous measures.

[konstantin_anikeev]

Hi,

this function module is too complex to deliver on the fly results for the millions of documents.

Options:

1. Background processing

2. Parallel processing - n threads with single cost center

3. Use BW/BI for reporting

4. Use custom selections - own functions

5. HANA

6. SAT analysis and new DB indexes

7. Say your BASIS to extend timeout for dialog sessions

choose one or combine them.

Regards,

Konstantin