(sorry if this shows up as a re-post)

Totally clueless. I'm stuck with a transaction-based table of sales. Besides
dollars and cents, I also have 3 groups of SalesRep + Manager (each with
different roles whose "shares do **not** add up to the aforementioned
amounts) per transaction. All 6 involved people are defined in Employees
table. Since SQL7 OLAP (don't know about 2k DA) allows a table to be used
only once in cube editor, how do I either:

1. create a real role-based dimension (1 per Rep+Mgr pair) with full roll-up
hierarchy, or
2. create 6 dimensions, one for each person involved (I realize this would
be wrong but it's miles ahead from what I have now).

Any idea would be greatly appreciated. TIA.

lc