dear all,
I have a requirement where I need to integrate data of two BPC models where I dont have any common dimension as of now.
These two models cater different businesses where Product/Material in XX model is represented as Material code in XY model
Product(in XX model) Material code(in XY model)
RTG 300000852
RFF AYYPH
And so on
As these two models cater to differ businesses I need to create a report displaying the qty/amt n one business (XX model) and the same qty/amt should be received by other business(XY model).
Product(in XX model) Qty(XX model) Material code(in XY model) Qty(XY model)
RTG 100 300000852 100
RFF 59 AYYPH 59
Please suggest if I can achieve this by maintaining property Material code in Product & material dimensions in XX model, but again the challenge will be how can I build a dynamic BPC report on these two models.
Also I thought of maintaining a table where I can maintain mapping between Product/material with Material codes and plant codes but in this case again how can I build bpc report showing the integrated data.
Any suggestions please.
Thanks,
Ambika