cancel
Showing results for 
Search instead for 
Did you mean: 

MultiProvider - Identify (Assign)

Former Member
0 Kudos

Hello everyone,

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

Cube 4:

InfoObject: 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?

Thank you!

Accepted Solutions (1)

Accepted Solutions (1)

former_member188975
Active Contributor
0 Kudos

Hi,

You can do this not at the identification level in the multiprovider, but in the query by creating RKFs, like Qty restricted to InfoProvider 2 and Plant 15.

Hope this helps...

Former Member
0 Kudos

I think we only can bring one same InfoObject to the MultiProvider. When I do restriction in query, how do we know which plant come from Cube 1 or Cube 2?

former_member188975
Active Contributor
0 Kudos

Hi,

You can use the 0INFORPOV char which is found in the Data Package dimension for MultiProviders...check in the query designer and you should be able to find it.

Hope this helps...

Former Member
0 Kudos

Yes, I did find 0INFORPOV. That's help! Thanks a lot.

Another question, if I need to restrict the same InfoObject but used in Cube 1, 2 and 3. Should I Identify(assign) all the cubes in MultiProvider?

former_member188975
Active Contributor
0 Kudos

Yes Qingbo, you can select the infoobject from all the base cubes and then separate in the query.

Hope this helps...

Answers (0)