Set-analysis_composition

[#1]

GANG

GANG   DESCRIPTION

CUSTOMER_NAME

SHIFT

DATE SHIFT

START SHIFT

END SHIFT

LABOUR_HOURS

PART_NO

Tool

ROLE_CODE

DESCRIPTION

TO_DATE_FROM_TIME

TO_DATE_TO_TIME

WEIGHT HANDLED

LOAD QTY

IDLE TIME

200

HUBO 1

Hamburger

S1

11/01/2013

6:00:00

13:45:00

7:15:00

COLA

-

ID_RAIN

cannot start unload   due rain

6:30:00

6:45:00

174162

81

0:15:00

FANTA

-

ID_RAIN

cannot start unload   due rain

6:30:00

6:45:00

33245

4

0:15:00

SPRITE

ID_RAIN

cannot start unload   due rain

6:30:00

6:45:00

10512

5

0:15:00

DUVEL

694702

185

PALM

83772

40

Total

996393

315

0:45:00

WEIGHT_HANDLED   : =sum({<ROLE_CODE={'ID*','FA*'}>}Aggr(sum(WEIGHT_HANDLED),PART_NO))

LOAD_QTY   : =sum({<ROLE_CODE={'ID*','FA*'}>}aggr(sum(LOAD_QTY),PART_NO))

IDLE   TIME : ==sum({<ROLE_CODE={'ID*','FA*'}>}aggr(sum(IDEL_TIME),PART_NO))

How   I would to have it

GANG

GANG DESCRIPTION

CUSTOMER_NAME

SHIFT

DATE SHIFT

START SHIFT

END SHIFT

LABOUR_HOURS

PART_NO

WEIGHT HANDLED

LOAD QTY

Tool

ROLE_CODE

DESCRIPTION

TO_DATE_FROM_TIME

TO_DATE_TO_TIME

IDLE TIME

200

HUBO 1

Hamburger

S1

11/01/2013

6:00:00

13:45:00

7:15:00

COLA

174162

81

VF02

FA_TRUC

waiting for truck

6:00:00

6:15:00

0:15:00

FANTA

33245

4

KR01

FA_OPEN

waiting for truck to   be ready to unload

6:15:00

6:30:00

0:15:00

SPRITE

10512

5

ID_RAIN

cannot start unload   due rain

6:30:00

6:45:00

0:15:00

DUVEL

694702

185

PALM

83772

40

Total

996393

315

0:45:00

need   to have a set-analysis to read out all the used tools

need   to change the place of WEIGHT HANDLED AND LOAD QTY

need   to be able to read out all the role_codes

GANG
GANG
  DESCRIPTION
CUSTOMER_NAME
SHIFT
DATE SHIFT
START SHIFT
END SHIFT
LABOUR_HOURS
PART_NO
Tool
ROLE_CODE
DESCRIPTION
TO_DATE_FROM_TIME
TO_DATE_TO_TIME
WEIGHT HANDLED
LOAD QTY
IDLE TIME


200
HUBO 1
Hamburger
S1
11/01/2013
6:00:00
13:45:00
7:15:00
COLA
-
ID_RAIN
cannot start unload
  due rain
6:30:00
6:45:00
174162
81
0:15:00


FANTA
-
ID_RAIN
cannot start unload
  due rain
6:30:00
6:45:00
33245
4
0:15:00


SPRITE

ID_RAIN
cannot start unload
  due rain
6:30:00
6:45:00
10512
5
0:15:00


DUVEL





694702
185



PALM





83772
40



Total





996393
315
0:45:00





















WEIGHT_HANDLED
  : =sum({<ROLE_CODE={'ID*','FA*'}>}Aggr(sum(WEIGHT_HANDLED),PART_NO))












LOAD_QTY
  : =sum({<ROLE_CODE={'ID*','FA*'}>}aggr(sum(LOAD_QTY),PART_NO))













IDLE
  TIME : ==sum({<ROLE_CODE={'ID*','FA*'}>}aggr(sum(IDEL_TIME),PART_NO))



















































How
  I would to have it




































GANG
GANG DESCRIPTION
CUSTOMER_NAME
SHIFT
DATE SHIFT
START SHIFT
END SHIFT
LABOUR_HOURS
PART_NO
WEIGHT HANDLED
LOAD QTY
Tool
ROLE_CODE
DESCRIPTION
TO_DATE_FROM_TIME
TO_DATE_TO_TIME
IDLE TIME


200
HUBO 1
Hamburger
S1
11/01/2013
6:00:00
13:45:00
7:15:00
COLA
174162
81
VF02
FA_TRUC
waiting for truck
6:00:00
6:15:00
0:15:00


FANTA
33245
4
KR01
FA_OPEN
waiting for truck to
  be ready to unload
6:15:00
6:30:00
0:15:00


SPRITE
10512
5

ID_RAIN
cannot start unload
  due rain
6:30:00
6:45:00
0:15:00


DUVEL
694702
185








PALM
83772
40








Total
996393
315





0:45:00





















need
  to have a set-analysis to read out all the used tools
















need
  to change the place of WEIGHT HANDLED AND LOAD QTY














need
  to be able to read out all the role_codes