MultiProvider - Identify (Assign)

[Former Member]

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!

[former_member188975 · Accepted solution]

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 · Accepted solution]

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 · Accepted solution]

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 · Accepted solution]

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 · Accepted solution]

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

Hope this helps...