Skip to Content
0
Former Member
Dec 11, 2006 at 03:35 PM

How to Model this?

25 Views

Hello experts,

Need help modelling the below data into Cubes:

Sales Extractor:

Has 30 fields including:

Sales Doc: Sales Order Item: Config no.: Plant: Material: Customer Group: etc

85252 10 1 4525 0001 Engine 10

Options Extractor:

Sales Doc: Sales Order: Item Config No.: Characteristic Name: Char Value:

85252 10 14525 Alternator ALT

85252 10 14525 Alternator ALT02

85252 10 14525 Valve 3

(there maybe up to 100 characteristics for each Sales Doc)

I have each extractor going into an ODS.

Now I am not sure what to do next?

For example I would want to run a report to see what Characteristics where sold to which customer group, so I need to bring both the ODS's together and then combine with a Cube (for Territory management from CRM).

Do you have any ideas how I could design this

Any help is much appreciated

Many Thanks

Helen