SAP Functional Modules ==> SAP BW

What are the steps to create multi provider?

Step by step procedure to create a multi provider.

MultiProvider is a special InfoProvider which combine data from several InfoProviders for its own reporting, without actually holding any physical data itself (i.e. its data comes exclusively from the InfoProviders on which it is based), then, it can only use an InfoProvider that is ready and available for reporting, in which case, the Transactional ODS object is not one of them. Therefore, to include a Transactional ODS object in a MultiProvider, you would have to first define an Infoset for the Transactional ODS object.

You can include Master data table in the Multiprovider but for that you should convert the InfoObject as the data target then only it is possible.

Note : We go for Multiprovider when we want to do reporting on two or more data targets.

A MultiProvider can be made of of various combinations of the following InfoProviders:

1. InfoCubes
2. ODS Objects (Standard only)
3. InfoObjects
4. InfoSets

Creation steps :
1. Go to the info area where you want the multi provider; right click and chose create multi provider.
2. Chose a technical name and also choose the info providers that you make part of this multi provider.
3. When you confirm your entries, you will get a infocube maintenance screen; on the right side, you will see the characteristics available in al the basic cubes that you choose in the first step. 
4. Select the chars that you wish to be in the multiprovider and similarly for time chars, key figs, and nav attributes ( if any).
5. Choose to create dimension and you will get a system msg whether to create from any of the basic cubes.
6. Either select to create your own dimension and insert all the chars in to the approprate dimensions.
7. Go back to chars tab and there will be tab for "idendification" click that and here is where you specify which are the chars form each cube you want into the multiprovider. And likewise for the key figure.
8. Activate the multiprovider.

If you have data in the basic cube, you can view the data in the multiprovider from LISTCUBE transaction.

Get help for your SAP BW problems
SAP BW Forum - Do you have a SAP BW Question?

SAP BW Books
SAP Business Warehouse Certification, Interview Questions and Configuration Reference Books

SAP BW Tips
SAP BW Tips and Business Information Warehouse Discussion Forum

Best regards,
SAP Basis, ABAP Programming and Other IMG Stuff
http://www.sap-img.com