Cognos Framework Issue with joins -

i have 2 tables:

the cost file:

 facility, product, cost set, cost bucket, cost 

the transaction file:

 facility,  product, quantity, date 

my issue need run through cost file specific cost set (03) , present information in list report :

 facility:product:quantity:bucket 1:bucket 2:bucket 3:etc. etc. 

i have tried many things, cannot information display without quantity aggregation getting hosed number of cost buckets facility/item combination. pretty sure has determinants, set them , found of no help.

can point me in direction might helpful, or there more can add description might useful?

what's relationship of cost bucket product? when "bucket 1", "bucket 2", etc these data values within bucket data item? if give sample data generates 1 line of output, that'd great.

general advice. if model solely rs use (not qs adhoc), may find easier create object within fm custom sql joining required tables together.