Skip to Content
0

Virtual provider based on Direct Access DTP from the DSO- Performance issue

Nov 04, 2016 at 11:18 AM

201

avatar image

Hello Gurus,

We are on SAP BW7.4 SP11

As part of HANA optimization POC activity we are trying an approach as below in order to reduce the DB size consumed by the Infocubes.

AS-IS Scenario: Data source --> DSO--> Standard Info cube-->MP-->Query

POC for Optimization PLAN--> DSO (Active Data Table)-->Virtual Infocube based on DTP Direct Access -->MP--> Query

We have implemented the Logic between the DSO and Standard Infocube into the transformation Between DSO and Virtual Infocube virtual Infocube based on DTP Direct Access

After Building the New data flow based on Virtual provider we observed that the performance is very good when run a LIST CUBE transaction on the Virtual cube. In fact better than the LISTCUBE execution on the STANDARD cube for same selections.

But, when we run the query built on Virtual provider the performance is very very low.

We have tried building indexes on VP based on direct access DTP using RSDDB transaction. Still performance issue persists.

For your information, We have millions of records in the Active data table of the DSO which we consumed in the Virtual cube based on Direct Access DTP

Our Idea is to delete the Infocube Data once the new data flow is successful so that we can reduce the DB size consumed by this Huge Infocube.

Please share your thoughts and expertise to Highlight some performance factors or throw some light on our approach as we expect an increase in the performance with this approach

Thanks,

Srini

10 |10000 characters needed characters left characters exceeded

Dear Gurus,

Can you throw on light on the below request.

Reagrds,

Srini

0
* Please Login or Register to Answer, Follow or Comment.

0 Answers