Skip to Content
0
Former Member
Dec 11, 2006 at 10:30 AM

Data Modelling Advise

22 Views

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