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.
Glad you asked! They are one of the most useful InfoProviders within the SAP Business Warehouse system.
Why is that?
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?
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.
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.
3 Ways to Design KPIs Using SAP Solution Map Composer