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: Mazuran Tera
Country: Lesotho
Language: English (Spanish)
Genre: Software
Published (Last): 24 April 2008
Pages: 344
PDF File Size: 20.1 Mb
ePub File Size: 3.42 Mb
ISBN: 842-2-41780-465-6
Downloads: 92185
Price: Free* [*Free Regsitration Required]
Uploader: Maurn

Hierarchies and formatting rules. Anyways great write up, your efforts are much appreciated. Manage logical grouping Grouping does not affect query performance, it only exists to organize the fields in a logical way.

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

What can be the possible reason? Source fields are automatically mapped to the same Target fields with the same data type, length and technical name. June 13, at 5: Migrate your Composite Providers after upgrade BW7. If there are fields in an InfoProvider, the fields can only be read sequentially: Please help me here to get clarified.

I hope you will continue to provide more such tutorials. Functional restrictions when modeling with fields 2. How many PartProviders can we join and union?

Creating a Composite Provider in SAP BW on HANA

After adding the provider name, next will be the other provider which you need to join. Leave a Reply Cancel reply Your email address will not be published. This is where the CompositeProvider comes in. Without going into the hana studio can we find out which operation did composite provider performed Join, union in Bw itself. We achieve this by first selecting the Inner Join box on the left, so the PartProviders for the Join pop-up in the Source screen in the middle. Slow logon WebI Rich Client?


Together with Part I of this article, you are now equipped with the knowledge necessary to go virtual in BW! Query result of Data Preview in Eclipse. Hi Steven, Good questions! Open link in a new tab.

Your email address will not be published. The fields we selected will now be available for querying and our PartProviders will be joined at runtime. Result of mapping Source fields to your Target If you do not see all of the fields in your Source provider in the Source area, one of your Source fields probably has a data type that is not compatible with CompositeProviders.

Procedure to create Composite Provider | SAP Blogs

Procedure to create Composite Provider. My source of unhappiness? Then select the .73 you want i. In output tab we have the fields which we had selected in the target area, where we assign for each the respective info objects in the association.

New Compoosite After you fill in the straightforward stuff, like name and description, you get to the following screen: There are objects used in your old composite provider that are compounding with other objects, they should be in the composite provider as well. You will find composite provider is available in the info area. The Scenario Tab In Figure 4 we see that the screen is split up into 3 segments: Whenever i try to migrate old composit providers to new ones i get the error compounding parent missing for this field….


Also, it does not let you edit the amount of space designated to measures even if you only have 1. Or do you recommend always using an OODS?

July 30, at compositf In case of a Union, we map similar Source fields to the same field. If you see the message in Figure 10, the field cannot provirer used in a CompositeProvider:. Learn how your comment data is processed.

Anupriya Posted on March 20, at If you have already modeled Calculation Views then using them directly in the CompositeProvider would be the preferred option if you do not want to do any further modeling based on the views in BW. We can model a Join or a Union by either right-clicking the PartProviders or the box indicating the Join or Union itself.

On the right, we see the Target area that will contain all the Target fields after we assign the Source fields. Have you tried this program with local composite providers? If you want to disable cookies please change this in your browser settings.

You can click a topic to jump to that particular section:.

Hi thanks for the nice explaining. Appreicate your quick help! How to assign your Source fields to a Target field.