hi,

thanks for ur reply..

i clearly explain u...

we have company master table ,

company

=======

A

B

C

D

E

...etc

transaction table per company as

A$Item

A$ValueEntry

A$Customer

B$Item

B$ValueEntry

C$Item

C$ValueEntry

this is tables in sql,now i have design the cube,i need insert sales amount for entrier company(A,B,C,D..etc),

but sales amount from table A$ValueEntry for Company A, B$ValueEntry for Company B, C$ValueEntry for Company C...likewise etc...

how we insert sales amount to fact table....this is my question.

i need sql query for this?

Please help me on this?