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