How to verify an SAP BI MultiProvider definition and
its mappings

Checking SAP BI MultiProvider mappings can be cumbersome because the user interface shows InfoProviders descriptions instead of technical names

If you want the check your MultiProvider mapping, just download 2 main tables from BI (use transaction SE16):
-RSDCUBEMULTI ‘InfoCubes concerned with MultiCube’ has the providers you have assigned to the MultiProvider
-RSDICMULTIIOBJ ‘MultiProvider: Selection/Identification of InfoObjects’ contains the mappings.

Things to check:
-Search for missing mappings: for example you have 3 similar cubes and 0MATERIAL is mapped to 2 of them but not to the third one.
-Inconsistent assignments: one mapping refers to a navigational attribute while a similar one refers to the InfoObject itself.

Downloading RSDICMULTIIOBJ in a spreadsheet and sorting it by IOBJNM (InfoObject in MultiProvider) may help. Also counting the number of assignments to a specific provider and comparing it to a similar provider.

Other tables that help in the MultiProvider definition are the cube ones:
-RSDCUBE ‘Directory of InfoCubes / InfoProvider’
-RSDCUBET ‘Texts for the InfoCubes’
-RSDDIME ‘Dimensions directory’
-RSDDIMET ‘Dimension Texts’
-RSDDIMEIOBJ ‘InfoObjects per dimension (where-used list)’
-RSDCUBEIOBJ ‘Objects per InfoCube (where-used list)’

Also executing the FM BAPI_MPRO_GETDETAIL will provide you with all the information mentioned above without dealing with all the tables.

SAP, R/3, SAP NetWeaver, Duet, PartnerEdge, ByDesign, SAP Business ByDesign, and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP AG in Germany and other countries.