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 ? )
PLANT, MATERIAL, STOCK Qty, STOCK Val (No Brand)
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,