//Pull Product QTY
*XDIM_MEMBERSET S_PRODUCT = <All>
*XDIM_MEMBERSET S_PROCACT = <All>
*XDIM_MEMBERSET S_CURRENCY = LC
*XDIM_MEMBERSET S_INVMETRIC = QTY

*LOOKUP SF_INVENTORY
	*DIM S_TIME = %S_TIME_SET%
	*DIM S_COMPANY = %S_COMPANY_SET%
	*DIM S_CURRENCY = %S_CURRENCY_SET%
	*DIM S_CATEGORY = %S_CATEGORY_SET%
	*DIM S_INVFLOW = PROD
	*DIM S_PRODUCT = S_PRODUCT
	*DIM PRODQTY:S_INVMETRIC = QTY
	*DIM MEASURES = "PERIODIC"
*ENDLOOKUP
 

*WHEN S_PRODUCT
	*IS *
	*REC(EXPRESSION = LOOKUP(PRODQTY), S_INVMETRIC = QTY)
*ENDWHEN 


//Calculate Processing costs per Unit
*WHEN S_INVMETRIC
	*IS *
	*REC(EXPRESSION = [S_INVMETRIC].[HOURS]*[S_INVMETRIC].[RATE], S_INVMETRIC = PRCOST)
*ENDWHEN

//Calculate total hours for all QTY
*WHEN S_INVMETRIC
	*IS *
	*REC(EXPRESSION = [S_INVMETRIC].[HOURS]*[S_INVMETRIC].[QTY], S_INVMETRIC = THOURS)
*ENDWHEN
