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: Mosar Mautaxe
Country: Saint Lucia
Language: English (Spanish)
Genre: Spiritual
Published (Last): 16 April 2008
Pages: 495
PDF File Size: 6.12 Mb
ePub File Size: 12.12 Mb
ISBN: 191-2-27298-156-6
Downloads: 28668
Price: Free* [*Free Regsitration Required]
Uploader: Nim

After clicking the right option, you end up at the following screen:. Hierarchies and formatting rules.

When you model with fields instead of InfoObjects, these are the main performance penalties:. Hi Pieter, thanks for sharing your knowledge here. This mapping is done automatically, when you click Create Assignments see Figure You can click a topic to jump to that particular section:.

If you want to add all the fields, right-click a PartProvider in the Source section and click Create Assignments see Figure 8. I believe it depends on where you want to model. How to create a Join Condition. Because the CompositeProvider is a virtual object, we can change source objects with relative ease by selecting Replace as long as there are no queries defined on the HCPR.

Right click on the filed which you need to make joins for the two info providers.


Creating a Composite Provider in SAP BW on HANA

In that song he predicts a future where we as a people are threatened by technology. This is where the CompositeProvider comes in.

If you see the message in Figure 10, the field cannot be used in a CompositeProvider:. Leave a Reply Cancel reply Your email address will not be published. Blog PostsNewsTutorials. I would like to ask a question In Bw we would see the composite provider. You can find the Join Condition Compowite in the Target area after selecting them.

July 28, at Manage logical grouping Grouping does not affect query bs, it only exists to organize the fields in a logical way. We are running a web-service same user-id for each job against SAP HANA and are wondering if there is a way of tracking auditing the login plus the results that are being returned as an outcome for this web-service.

This icon means that this is an old Composite Provider that was created before the upgrade to Privider.

How many PartProviders can we join and union? What are your thought on using Hana views directly in a compositeProvider?

Migrate your Composite Providers (after upgrade BW7.3 –> BW7.4)

Together with Part I of this article, you are now equipped with the knowledge necessary to go virtual in BW! You cannot use the OLAP cache, when there composiye fields in the query definition. Custom color palette BI 4. Result of mapping Source fields to your Target. In Figure 3 we see the PartProviders we can select when we press Add: April 3, 2 minute read.


If you want to disable cookies please change this in your browser settings. Keep in mind, there are also several functional restrictions when using field-based modeling.

Hi thanks for the nice explaining. Whenever i try to migrate old composit providers to new ones i get the error compounding parent missing for this field….

Grouping does not affect query performance, it only exists to organize the fields in a logical way. After clicking the right option, you end up at the following screen: After clicking select Join with or Union with see Figure 6.

In output tab we have the fields which we had selected in the target area, where saap assign for each the respective info objects in the association. Good luck with migrating your Bbw Providers!!!

Procedure to create Composite Provider

The Scenario Tab In Providwr 4 we see that the screen is split up into 3 segments: How to assign your Source fields to a Target field. This site uses cookies. Anupriya Posted on March 20, at Hi Friedrich, Nice to hear that you’re using Now Activate the composite provider. Hierarchies and formatting rules 22 Jan, In case of a Union, we map similar Source fields to the same field.