I just created a MultiProvider which contains four cubes and one InfoObject. There are three cubes contain the same InfoObjects. For example: Material No and Plant. First let me give you an simple example about the common InfoObjects:
Cube 1: Material No, Plant (All three cubes may have different Material No and plant)
Cube 2: Material No, Plant
Cube 3: Material No, Plant
My report need to show:
Material no where Plant = 10 from cube 1
Quantity on hand where Plant = 15 from cube 2
Material size where plant = 15 from cube 3
1. Is it possible to do the above restrictions in the report?
2. When I do identify (assigns) in the MultiProvider, it is possible to check more than one box if they are used in different cubes. But how to use the same InfoObject to filter the different values in the report?