How to create multiprovider in sap bi

‎12-08-2016 09:07 PM

Hi Power BI Team,

We have SAP BW at the backend and trying to create specfic Dashboards in Power BI.

The specific requirement for the client is to design a Power BI Dashboard based on Multiproviders from SAP BW.

1. Able to connect to the SAP BW Infocube in Power BI.

2. But while trying to connect to SAP BW Multiprovider, facing the error as mentioned below:

"SAP Business Warehouse: RfcReceiveEx Failed (RFC_SYS_EXCEPTION): EXception condition "HIERARCHY_NOT_FOUND" raised"

Is there any fix for the issue mentioned? If so please update.

Awaiting your response at the earliest.

Regards,

JK.

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.

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.

Socializar Publicación Académica:

Si le es de utilidad este publicación académica sobre SAP BI / BW BO Video - Creación de Multiprovider, que Mary Galicia ha realizado, le invitamos a apoyar este conocimiento libre compartiéndolo desde:

O bien simplemente copie y pegue el siguiente vínculo en su red social preferida:
https://www.cvosoft.com/apuntes-sap/sap-bi/video-creacion-de-multiprovider-/apunte-sap-bi-video-creacion-de-multiprovider-82124.html

Gracias!

Cerrar

:: CVOSOFT OPEN ACADEMY ::
Producción Colaborativa y Abierta de Conocimientos, nuestro potencial está en nuestra gente!

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.

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.