Composite Providers are used to combine multiple InfoProviders using Join or Union operations. When you use SAP BW on HANA, one of the InfoProvider. Trying to figure out how SAP BW’s relatively new virtual InfoProviders . CompositeProvider / Composite Provider – How to assign your Source. SAP BW on HANA is nothing but SAP’s existing NetWeaver BW data warehouse, editors, e.g. for the composite provider or the new query designer (planned).

Author: Mazura Dailabar
Country: Liechtenstein
Language: English (Spanish)
Genre: Art
Published (Last): 13 October 2015
Pages: 30
PDF File Size: 1.83 Mb
ePub File Size: 10.42 Mb
ISBN: 123-8-89829-927-8
Downloads: 45698
Price: Free* [*Free Regsitration Required]
Uploader: JoJogis

Blog PostsNewsTutorials. Please help me here to get clarified.

Creating a Composite Provider in SAP BW 7.3 on HANA

You can find the Join Condition Fields in the Composits area after selecting them. Running a query from BO Analysis. Keep in mind, there are also several functional restrictions when using field-based modeling. Anupriya Posted on March 20, at When you preview the composite provider you will find the data.

After you select CompositeProvider, you see the following screen:. Here we see something interesting. We achieve this by proviver selecting the Inner Join box on the left, so the PartProviders for the Join pop-up in the Source screen in the middle. Right click on the filed which you need to make joins for the two info providers. In wap you only need specific fields, expand the PartProvider tree by clicking on the arrow next to the PartProvider name.


The fields we selected will now be available for querying and our PartProviders will be joined at runtime.

Procedure to create Composite Provider

Hemanth Aluri Posted on April 10, at Add PartProvider screen Here we see something interesting. Excellent tutorials — very easy to understand bbw all the details.

Also, it does not let you edit the amount of space designated to measures even if you only have 1.

You can also see the properties of those fields in the Output tab. Field cannot be used in a CompositeProvider.

How can we tell? There are objects used in your old composite provider that are compounding with other objects, they should be in the composite provider as well. Proviser to assign your Source fields to a Target field.

After you fill in the straightforward stuff, like compossite and description, you get to the following screen:. On the right, we see the Target area that will contain all the Target fields after we assign the Source fields.

Creating a Composite Provider in SAP BW on HANA

Leave a Reply Cancel reply Your email address will not be published. Search or use up and down arrow keys to select an item.


Query result of Data Preview in Eclipse. You will find composite provider is available in the info area. If you change your mind after this step, no worries, because you can add and remove PartProviders later in the CompositeProvider modeling screen.

But I still have some questions: The world of online dancing proviider has just become more transparent!

How to go Virtual in BW Part II: The HANA CompositeProvider – Just-BI

Grouping does not affect query performance, it only exists to organize the fields in a logical way. I would like to ask a question In Bw we would see the composite provider. New CompositeProvider After you fill in the straightforward stuff, like name and description, you get to the following screen: Whenever i try to migrate old composit providers to new ones i get the error compounding parent missing for this field….

With regards to joins: We can model a Join or a Union by either right-clicking the PartProviders or the box indicating the Join or Union itself.