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: Kigagar Kigazuru
Country: Czech Republic
Language: English (Spanish)
Genre: Finance
Published (Last): 24 July 2005
Pages: 24
PDF File Size: 7.6 Mb
ePub File Size: 9.34 Mb
ISBN: 772-2-67476-852-5
Downloads: 32526
Price: Free* [*Free Regsitration Required]
Uploader: Shakabar

Migrate your Composite Providers after upgrade BW7. If you see the message in Figure 10, the field cannot be used in a CompositeProvider: I hope you will continue to provide more such tutorials.

Appreicate your quick help!

Or do you composlte always using an OODS? So I would only use it on a short-term basis, i. The result of adding the joined fields to the Target The result is in Figure Comlosite are three different types of CompositeProviders:. How many PartProviders can we join and union? BusinessObjects Analysis Mission Complete! Because we mapped the Land Source Field first to the Target, the Target field will end up with the description Land, despite being called Country in one of the PartProviders.


Creating a Composite Provider in SAP BW 7.3 on HANA

Inthe artist Jamiroquai aap the song Virtual Insanity. That way we can determine whether our join is duplicating any data due to a n: Procedure to create Composite Provider. If you change your mind after this step, no worries, because you can add and remove PartProviders later in the CompositeProvider modeling screen.

Hi Sid, I think that this solution has not been Next, in Figure 12, we have to select which field to join the field we right-clicked in Figure After assigning your fields you should see some squiggly lines connecting your Source fields to gw Target fields, like in Figure OpenSAP recommendations 9 Sep, After clicking the right option, you end up at the following screen:.

After clicking select Join with comoosite Union with see Figure 6. Source fields are automatically ccomposite to the same Target fields with the same data type, length and technical name. Select Join Partner screen. When you preview the composite provider you will find the data. June 13, at 5: There are objects used in your old composite provider that are compounding with other objects, they should be in the composite provider as well.


We now also know how to model CompositeProviders. April 3, 2 minute read. Is there any Tcode. Functional restrictions when modeling with fields 2.

Migrate Composite Provider SAP BW

You can also see the properties of those fields in the Output tab. Hi There, Nice tutorial! Also, it does not let you edit the amount of space designated to measures even if you only have 1. This is especially important when you model an Inner Join as in composiet example.

How to create a Join Condition.

Custom color palette BI 4. Secondly, in the fifth and sixth column of Figure 18, we see the field values of all the Dancing Course Instructors. Hello Laurant, Thanks for your blog! You will find composite provider is available in the info area. You can find the Join Condition Fields in the Target area after selecting them.