Q about multi-cubes or other method to link 2 providers

Hello

Let's suppose that a user wants a query from material master data which involves basic data (0MATERIAL) and MRP data (0MAT_PLANT).

For example, material number (in both), plant (0MAT_PLANT only), cross-plant (0MATERIAL only) and MRP controller (0MAT_PLANT only).

If I create a multi-cube, I will get all parts from 0MATERIAL with cross-plant and all other fields empty (3) and all parts from 0MAT_PLANT with plant, MRP but without cross-plant.

Creating an infoset is (at least in my opinion) painful and not user friendly

Any other idea how to link them easily?

Any suggestion is welcome

Thank you

Ioan