Performance on virtual Infoprovider / 0FIGL_V10

[Former Member]

Hi Experts,

we have built a cash flow query based on 0FIGL_V10. The performance is quite miserable as it is a virtual infoprovider. Are there any suggestions to tweak the performance ? Does an aggregate on 0FIGL_C10 (the basis of of V10) help at all ?

Thanks for you inputs !

Regards,

Max

[former_member182429]

The other alternative in the long-run would be to use the standard InfoCubes 0FIGL_C10, and enhance that to load more frequently, e.g., once every 2 hours.

That way, you still have up-to-date information, without the performance bottlenecks of using a VirtualProvider.

This alternative however, will incur some resources to develop and deploy.

[Former Member]

We use the virtual infoprovider in order to have accurate balance sheet. Some positions in balance sheet may be debit or credit, depending on the balance of the corresponding accounts ("contra items", Saldowechselposition in German) in the hierarchy. This is the reason why we use 0FIGL_V10 (see http://help.sap.com/saphelp_dimp50/helpdata/EN/f2/e16840b151181ce10000000a1550b0/frameset.htm)

The V10 is not a Remote cube !

Regards,

Max

[Former Member]

Hi, I have the same question.

Anyone know if virtual Providers like 0FIGL_V10

Based on Function Modules

will use aggregates in 0FIGL_C10 ?

Best Regards

Ingrid

[Former Member]

Hi Ingrid,

as far as I know - but I am not 100% sure - they don't use aggregates.

Maybe you can try and test your query in RSRT and check if aggregates are used.

Hope this helps

Viele Grüße

Max

[former_member197993]

Hello Max,

Please have a look at this SAP Note which has helped customers with similar issues:

1173380 - Changes to service function modules of FI-GL virtual cubes

Another customer who faced similar performance issues with virtualproviders solved

the problem by setting parameter STAR_TRANSFORMATION_ENABLED to TRUE.

Please check if this is set to FALSE and if so, change it to TRUE as per SAP Note 830576.

830576 - Parameter recommendations for Oracle 10g

Best Regards

Barry

[Former Member]

thanks for your reply, barry.

i will check your recommondations !

regards,

max