Can we view data in Multiprovider

[Former Member]

Hello All

In one of my interview he asked me can v view data in multiprovider.(Not in reporting level).

I said no,he said yes?

If anyone knows abt this pl let me know.

Regards

balaji

[Former Member · Accepted solution]

Hi Balaji,

Yes. Your are right that teh multi-provider does not store any data. It is like a view that displays the data from various data targets using union. LISTCUBE displays the data using those unions and displays the data. It is not fetching data from any underlying table of the Multi-provider. Probably if you debug then you would find the various SQL statements fetching data from the other data targets using the join conditions.

LISTCUBE is just meant for displaying the data from an Info-provider in the backend.

If you are familiar with R/3 then you would have noticed that you can see the data in table or view in SE11/SE16 even though a table has data where as a View does not. It is something similar to that.

Hope this helps.

Bye

Dinesh

[Former Member · Accepted solution]

Hi

Dinesh

Thanks a lot for your detailed information.Yes as you said I checked in SE11/SE16,for table name data is been displaying but when v select view and display this the contents icon itself is not displaying.

Can you tell me how to debugg and check this options,I never did this debugg.

Thanks & Regards

Balaji

[kostas_tsioubris]

Hello ppl,

the best way to see the SQL statements is to activate SQL Trace I believe...

br,

Kostas

[Former Member]

Hi

Kostas

Thanks for your message

Regards

Balaji

[Former Member]

Hi Balaji,

If you see the SQL Code it would give you a good idea of the underlying query that gets executed when data is fetched from a multiprovider.

If you want to debug then got to LISTCUBE -> Give the multiprovider name. Now enter "/h" in the command field(i.e in the place where you enter transactions like RSA1). Now execute. You should now be able to debug.

Bye

Dinesh

[Former Member]

Hi

Dinesh

Thanks a lot.

Regards

Balaji

[Former Member]

Hi Balaji,

You can debug from the LISTCUBE transaction though you would not make much of it.

The best option is to build a query on a Multiprovider and then use the "execute+debug" option in RSRT and select "Display SQL query" option.

Hope this helps.

Bye

Dinesh

[Former Member]

Hi dinesh,

i tried in a way that what u said above. but i unable to debugg it...,

Regards

Swetha

[Former Member]

Hi

Dinesh

As you said I executed query on multiprovider,and used RSRT and clicked on Execute + Debbug button there I selected display SQL query option as you said,but I could find only the ABAP code not in the debugg mode.

Pl help me out

Regards

Balaji

[Former Member]

Hi Balaji,

As the word "Virtual" itself states. It does not store any data. The data is provided from different data targets using joins and unions in the case of Multiproviders and Infosets.

Bye

Dinesh

[Former Member]

Hi

Dinesh

Thanks a lot ,understood ur point.

But how to debugg,pl let me know?

Thanks & Regards

Balaji

[Former Member]

Hi,

MultiProvider is a type of InfoProvider that combines data from a number of InfoProviders and makes it available for reporting purposes. The MultiProvider does not itself contain any data. Its data comes entirely from the InfoProviders on which it is based.

Regards

Siddhu

[Former Member]

Hi

Sidhartha

Thanks for your message.Untill today I also was in same thought,but today I came to know that v can view data by using Tcode mentioned.

What I want to know is how the data is been storing in virtual infoproviders.Is the data really storing in multiproviders or joining from different data targets

Regards

Balaji

[Former Member]

Hi Balaji,

Yes you can view data in Multiprovider.

In NW 2004s (BW 7.0), just right mouse click on the Multiprovider and you have the option to "Display Data"

Regards

Anurag

Message was edited by: Anurag Khungar

[Former Member]

Hi

Anurag

Thanks for your message.I can see data in 3.1C also.But generally Virtual Infoproviders does'nt hold data physically,but how come data is storing here?

Pl let me know

Regards

Balaji

[Former Member]

Hi Balaji,

The Multiprovider being a virtual Infoprovider does not store data, when a request for accessing the data is made it accesses the same from the underlying Infoproviders/Infoobjects which have the data.

Hope it helps.

Cheers

Anurag

[edwin_harpino]

hi,

transaction LISTCUBE,

object type MPRO

[Former Member]

Hi

AHP

Thanks for your message.But generally Virtual infoproviders does not hold data only structure is been maintained,but how-come data is been storing/display here in Listcube-tcode?

Can you tell me abt how it works internally,whether multiproviders hold data physically? or data is coming from different data targets.

Pl let me know.

Thanks & Regards

Balaji