Multiprovider for Brand and Inventory Cube

[govind_ramesh]

Hi All,

I have a requirement wherein I have been asked to show the stock report (0RT_C37) at Brand/Monthly level.

But the problem is that 0RT_C37 does not have Brand field.

I have tried to create a multiprovider on 0RT_C37 and 0MATERIAL to show the Brand as Brand is available in 0MATERIAL. But somehow I feel this is not the right join as the cube 0RT_C37 does not have the field for Brand (or is it that I'm wrong ? )

EG:

0RT_C37 fields

PLANT, MATERIAL, STOCK Qty, STOCK Val (No Brand)

0MATERIAL fields

MATERIAL, BRAND...etc

Now my result should look like:

PLANT, BRAND, STOCK Qty, STOCK Val

If I activate the brand as a navigational attribute in the cube 0RT_C37 then I will be able to see brands from today and not for the historic records.

Please do send me your suggestions in order to create the result as shown above.

Regards and Thanks in advance,

Govind

[former_member623450 · Accepted solution]

Hi,

In such scenerios use Infoset instead of multiprovider.

Join using 0material.

Hope this works.

[govind_ramesh · Accepted solution]

Hi,

Thanks for the reply.

But, Is it possible to create an Infoset with an Infoobject and an infocube ? I have read about Infoobject and an ODS.

Please guide.

If possible please mention the steps or transaction involved in the creation of the Infoset.

Regards

Govind

[Former Member · Accepted solution]

Hi,

In BI7 it is possible to create Info sets on info cube.

To see hoe to create info set check here,

http://help.sap.com/saphelp_nw04/helpdata/en/a3/96663bd194a978e10000000a11402f/content.htm

-Vikram

[govind_ramesh · Accepted solution]

Hi Vikram,

I tried to create the infoset but the system gives me the following error.

The InfoSet does not support non-cumulative InfoCubes - 0RT_C37

Is there any way out for this ?

Please advice.

Regards

Govind

[govind_ramesh · Accepted solution]

Hi All,

I have found a solution to my problem.

I have created a query by giving brand selection on the infoobject 0MATERIAL.

Now the result is just the 0MATERIAL on the row.

This will return all the articles of the brand given as an input.

This rersult is then chosen as an input via a variable created with replacement path on 0MATERIAL.

hence I get the movements of the articles for a particular brand.

Regards

Govind