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: Shakasho Zurg
Country: Panama
Language: English (Spanish)
Genre: Photos
Published (Last): 1 October 2008
Pages: 139
PDF File Size: 2.84 Mb
ePub File Size: 6.74 Mb
ISBN: 270-9-65434-472-7
Downloads: 99018
Price: Free* [*Free Regsitration Required]
Uploader: Voodooshura

Secondly, in the fifth and sixth column of Figure 18, we see the field values of all the Dancing Course Instructors. When you preview the composite provider you will find the data.

Hi Steven, Good questions!

The sum of the measures in the HCPR is equal to the sum of the measures in the fact table 1. The result of adding the joined fields to the Target The result is in Figure You can execute all these actions by right-clicking a PartProvider and selecting the appropiate option from the context menu.

The result of adding the joined fields to the Target. Together with Part I of this article, you are now equipped with the knowledge necessary to go virtual in BW! You can click a topic to jump to that particular section:.


Blog PostsNewsTutorials. There are three different types of CompositeProviders: On the right, we see the Target area that will contain all the Target fields after we assign the Source fields. BusinessObjects Analysis Mission Complete!

There are objects used in your old composite provider that are compounding with other objects, they should be in the composite provider as well. Hierarchies and formatting rules 22 Jan, Left side composit the Scenario Tab. With regards to joins: You cannot use the OLAP cache, when there are fields in the query un.

This mapping is done automatically, when you click Create Assignments see Figure April 3, 2 minute read. If there are fields in an InfoProvider, the fields can only be read sequentially: Running a query from BO Analysis. After clicking the right option, you end up at the following screen:.

We are running a web-service same user-id for each job against SAP HANA complsite 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.

Procedure to create Composite Provider | SAP Blogs

Field cannot be used in a CompositeProvider. Jamiroquai would be proud of you! This icon means that this is an old Composite Provider that was created before the upgrade to BW7. Mike Posted on March 22, at 2: Hi Laurant, Thanks for sharing the blog. We use cookies to ensure that we give you the best experience on our website.


The result in Excel is nice and wb, we instantly have a nice overview of the fields we want to see. You can also see the properties of those fields in the Output tab.

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

Once you click a PartProvider on the left side of the Scenario Tab, it shows up .73 the Source section. If you change your mind after this step, no worries, because you can add and remove PartProviders later in the CompositeProvider modeling screen. You will find composite provider is available in the info area.

I was actually holding my breath as I followed these directions. How to Join bd Union in the Scenario Tab. When you model with fields instead of InfoObjects, these are the main performance penalties:. After adding the provider name, next will be the other provider which you need to join.

Can you tell me what could be the problem?