We have a scenario where there are three different R/3 data sources are used to upload one Info Cube.
Is it possible to control the data coming from those data sources?
In the sense I need certain fields from the 1st data source. But this data source is not reporting the cost estimates properly. We need the Finished goods to show only the semi finished materials and the semi finished need to show only the level lower to it and only when i go to the lowest level it needs to show all the raw materials.
But since this data source is not doing that we brought two other data sources (SAP R/3) tables to do display the reports in that way.
If it is possible to add the other fields to these tables please do let me know how I can do that.
Or is there a way to control what data needs to come from which data source.
Please do give me the suggestions and help me out with this issue.