Dear All,
Wanted to ask advise regarding the modelling of a BW project:
I have 3 Extractors (will be using Delta)
1 for all the Sales Details (from R/3)
1 for all the Options sold against each sales doc (from R/3)
1 for Territories (from CRM)
I want to combine all together so I can create 1 query.
Both the Sales Details Extractor and the Options have Sales Doc field: but there maybe up to 100 lines for all the Options sold against Sales Doc in the Options Extractor compared to just 1 line for the Sales Details.
I have tried MultiProvider but can't seem to get it to not work.
I tried Infoset and that seems to work I can get every line of all the Options to also contain all the Sales Details but
Is there a smarter way of doing this?
Is it ok to use Infosets?
Is it ok to create a Multiprovider with an Infoset and a Cube?
What are the drawbacks?
Any advise/help would be much appreciated as I am struggling with building the correct design.
Many Thanks
Shenanigans