Using Virtual Provider - Select on DSO active tables

[Former Member]

Hi all,

I have a requirement to build a virtual provider by using the selections passed via query variables and use it in a select statement joining couple of DSOs. Once the data is processed I need to pass the data back to the OLAP engine.

1. How do i get the selections from the Query variables ?

2. Where should I write my ABAP code for selecting the DSO tables and the method to be used for passing the data back to OLAP ?

Thanks in advance

Regards,

_Mhel

[Gabor_Kovacs]

Hi Mhel,

Please check http://help.sap.com/saphelp_nw73/helpdata/en/4a/124975ca771b41e10000000a42189c/content.htm?frameset=... for details - e.g. VirtualProviders with function modules. Read the detailed documentation of the function module templates in the system.

Alternatively you can consider CompositeProvider to build the joins between DSOs.

Regards,

Gabor

SAP Customer Solution Adption (CSA)

[Former Member]

Hi Mhel

i got a document prepared for "how to use virtual Infoprovider" - it does not answer fully your questions - but give a hint how to proceed. Give me an email - and i will post you that pdf.

Johannes