How To Build SAP BW MultiProviders and Infosets Guide

Table of Contents

SAP How-To Guides

As part of our on-going SAP BW educational series of SAP How-To Guides, we have put together this guide that provides step-by-step instructions on how to design and build both SAP BW Multi-Providers and InfoSets.

What is a SAP BW MultiProvider?

Glad you asked!  They are one of the most useful InfoProviders within the SAP Business Warehouse system

Why is that?

They are able to combine views from several other InfoProviders.

MultiProviders are a special type of InfoProvider that combine data from several InfoProviders. They are then available for reporting via BEx.  MultiProviders themselves (like InfoSets and Virtual Providers) do not contain any data. Their data comes exclusively from the InfoProviders upon which they are based.

MultiProviders can be based upon any combination of the following InfoProviders:

✴InfoCubes

✴DataStore Objects

✴InfoObjects

✴InfoSets

✴Aggregation levels (slices of InfoCubes to support BI Integrated Planning)

How might they be used?

Example Business Scenario

 

You may have previously developed InfoProviders for cost center transactions that provide both plan and actual data.  BI Integrated Planning (IP) can be supported by this separate plan-vs-actual design with the addition of one more infocubes.

It can also be used to support the loading of actual cost data from the SAP source system. Your business users need reports that provide comparison reports of planned vs actual cost.  Using a MultiProvider, you can easily set this up.  To learn this and specific How-To techniques, just download our guide.

 

MultiProviders and InfoSets GuideOur View of the SAP BW Solution

 

 

Not sure how to build a SAP BW MultiProvider or Infoset?  You can master this important SAP BW consultant skill now.  Just download our guide to modeling multiproviders and Infosets by pressing the button the below.

 

Download Modeling  MultiProviders and InfoSets Guide

3 Ways to Design KPIs Using SAP Solution Map Composer

 

 

Download SAP BW Mindmap

Learn what SAP Business Warehouse is and what it does in under five minutes

Get this Mindmap

Lonnie D. Ayers, PMP

About the Author: Lonnie Ayers is a Hubspot Certified Inbound Marketing consultant, with additional certifications in Hubspot Content Optimization, Hubspot Contextual Marketing, and is a Hubspot Certified Partner. Specialized in demand generation and sales execution, especially in the SAP, Oracle and Microsoft Partner space, he has unique insight into the tough challenges Service Providers face with generating leads and closing sales using the latest digital tools. With 15 years of SAP Program Management experience, and dozens of complex sales engagements under his belt, he helps partners develop and communicate their unique sales proposition. Frequently sought as a public speaker in various events, he is available for both inhouse engagements and remote coaching.
Balanced Scorecard Consultant

He also recently released a book "How to Dominate Any Market - Turbocharging Your Digital Marketing and Sales Results", which is available on Amazon.

View All Articles by Lonnie D. Ayers, PMP

The SAP Blog

Subscribe to our blog and receive SAP BW Updates, demand generation, inbound marketing, sales enablement, technology and revenue generation insights and ideas delivered right to your email.