Skip to Content
0
Feb 06, 2010 at 01:52 PM

Multiprovider for Brand and Inventory Cube

14 Views

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