Skip to Content
0
Former Member
Jan 11, 2008 at 07:00 PM

Data Model Help

23 Views

Hi All, I have the below data in 3 different ODEs & respective cubes. I need to display the below 3 different data coming into BW in a single report. I have tried creating a multicube but it doesn't help. Any Ideas??

This is PM data having work orders, notification causes & confirmations that user wants on same report.

This has Orders & their operations, order & counter are key.

Order No Counter Date Notification Confirmation No Actual Work

1001 1 1/8/2008 3001 2001 1Hr

1002 1 1/8/2008 3002 2002 2Hr

1002 2 1/8/2008 3002 2002 2Hr

there can be multiple confirmation done for same order. Conf No & Counter are key

Confirmation No Counter Order No Text Person Worked Actual Work

2001 1 1001 Confirm txt 1 Mark 1Hr

2002 1 1002 confirm txt 2 Pete 2Hr

2002 2 1002 confirm txt 3 Dave 3hr

Notifications created for maintenance, this is used to create an Order

Notification No Order No Cause Text

3001 1001 Text 1

3002 1002 Text 2

Edited by: Mark Smith on Jan 11, 2008 8:20 PM