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