cancel
Showing results for 
Search instead for 
Did you mean: 

BCS Virtual Cubes Performance Tuning

Former Member
0 Kudos

Hi All,

We are working on improving the performanc tuning of queries on BCS Virtual Cubes (with services).

Any specific changes (from RAM to specific properties on queries, Virtual Cubes with services) that you have seen working in improving the performance in yuor environemnt is greately appreciated.

Thanks,

- Shashi

Accepted Solutions (1)

Accepted Solutions (1)

former_member93896
Active Contributor
0 Kudos

Hello Sashi,

there are several things you can do. First, make sure you are using the MultiProvideer scenario in the best way (as much data in the persistent InfoCube as possible). This is described in the corresponding how-to paper, which you can find here: http://service.sap.com/sem > BCS > Media Library

Second check that you have either a current support package or implement all notes you can find for "RSSEM_CONSOLIDATION_INFOPROV3".

Next, create aggregates for the base InfoCubes. You can check the BI or BCS stats. As an alternative you could look into BI Accelerator.

Regards,

Marc

SAP NetWeaver RIG

Former Member
0 Kudos

Thanks a lot Marc,

We are on NW2004, with the following support pack levels

SAP_BW 350 0016

FINBASIS 300 0012

BI_CONT 353 0008

SEM-BW 400 0012

I have checked the service market place and the current SP's available are:

SAP_BW 350 0019

FINBASIS 300 0015

BI_CONT 353 0013

SEM-BW 400 0015

Which Service Packs that you suggest us to go with for performance issues on BCS Virtual Infoprovider queries?

Thanks,

- Shashi

former_member93896
Active Contributor
0 Kudos

Implement the following notes:

938682 Data doubled sometimes when running a complicated query

979510 Doubled data returned by a complicated query sometimes

966348 Improvement for memory consumption of huge selections

962623 No further processing needed when there's no open request

Regards,

Marc

SAP NetWeaver RIG

Former Member
0 Kudos

Thanks Marc.

Best Regards,

- Shashi

Answers (1)

Answers (1)

Former Member
0 Kudos

Usually, financial reporting is done for current year and previous year. SO, in all my implementations, I try to keep only data only 2 years or may be 3 years for forecasting purposes. This will give some performance gains.

If you have complex allocations, beware of the runtime performance of that.

Ravi Thothadri