How To Create Multiprovider In Sap Bi

SAP BI / BW BO Video - Creación de Multiprovider

MultiProviders are a special type of InfoProvider that combine data from several InfoProviders. They are then available for reporting. MultiProviders themselves (like InfoSets and VirtualProviders) do not contain any data. Their data comes exclusively on 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) What is a MultiProvider Used For? You can only create a BEx query against a single InfoProvider. A MultiProvider provides a way to to access multiple InfoProviders, as it can combine a number of InfoProviders Our Business Scenario includes two InfoCubes (plan and actual cost data). We have one InfoProvider with actual data for a logically self-contained business area and a corresponding InfoProvider with plan data. By using a MultiProvider, you can combine the InfoProviders into a MultiProvider to compare Plan vs. Actual data in a query. Many other examples exist. You could have an InfoCube and an InfoObject. You have an InfoCube with your products and revenues. You could combine it with the InfoObject PROD (product). This would allow you to display slow-moving items, since products that generate no revenue are also displayed.

Advantages of the MultiProvider • Simplified Design: The MultiProvider concept provides you with advanced analysis options, without you having to fill new and extremely large InfoCubes with data. You can construct simpler BasicCubes with smaller tables and with less redundancy. • Individual InfoCubes and DataStore Objects can be partitioned separately* • Performance gains through parallel execution of subqueries • Note: *"partitioned separately" can either relate to the concept of splitting cubes and DataStroe Objects into smaller ones, perhaps by limiting the number of years in a each or via physical database partitioning of the fact table. Integration MultiProviders exist only as a logical definition. The data is still stored in the InfoProviders on which they are based. This aspect of MultiProviders makes them very similar to InfoSets; however, the big difference between InfoSets and MultiProviders is in the technical way the tables are linked. InfoSets link the underlying providers with database joins, and MultiProviders use a technically different method called unions. These differences result in different result sets and, therefore, different end uses for MultiProviders versus InfoSets

Creating MultiProviders Prerequisites

There is an active version of each InfoObject that you want to transfer to the MultiProvider. Create any InfoObjects that you require that do not already exist and activate them.

Instead of creating a new MultiProvider, you can install a MultiProvider from SAP Business Content.

Procedure

1. Create an InfoArea to which you want to assign the new MultiProvider.

Choose Modeling → InfoProvider.

2. In the context menu of the InfoArea, choose Create MultiProvider.

3. Enter a technical name and a description.

4. Choose Create.

5. Select the InfoProvider that you want to form the MultiProvider. Choose Continue. The MultiProvider screen appears.

6. Use drag and drop to transfer the required InfoObjects into your MultiProvider. You can also transfer entire dimensions.

7. Use Identify Characteristics and Select Key Figures to make InfoObject assignments between MultiProviders and InfoProviders.

In a MultiProvider, each InfoObject in the MultiProvider must correspond to exactly one InfoObject in each of the InfoProviders involved (as long as it is available in the MultiProvider). If this mapping is not clear, you have to specify the InfoObject to which you want to assign the InfoObject in the MultiProvider.

See also, Consistency Check for Compounding.

8. Save or Activate the MultiProvider. Only active MultiProviders are available for analysis and reporting.

See also:

The additional functions in DataStore object maintenance are also available as additional functions in MultiProvider maintenance. The only exception is the last function listed for performance settings.

Sobre el autor

Publicaci�n acad�mica de Mary Galicia, en su �mbito de estudios para la Carrera Consultor en SAP BI / BW BO.

SAP Senior

:: Al igual que Mary �Usted est� dispuesto a aprender SAP BI / BW BO?

El lunes 29 Noviembre 2021 comenzamos la 🎓Carrera Consultor en SAP BI / BW BO.
Juntos para realizar sus m�s grandes desaf�os!

Consultas y Soporte

👋Hola! Estamos listos para ayudarle con el soporte que su carrera merece.

Acceda sección contacto y seleccione canal de comunicación más cómodo para usted.

🤝Aguardamos su mensaje, ��xitos!

Las Bases éticas de nuestra Academia

👉Que las empresas tomen en serio sus estudios es muy importante para que su inversión educativa tenga sentido.
Las empresas líderes de Singapore y del Mundo confían a CVOSOFT su recurso m�s valioso, la formación de su gente.

¿Quieres conocerlas?