Hello,
I have sales commission's data mart. Each record in data mart
corresponds to sales agent's receivable commission from some sale
he/she produced. More than one agent may participate in selling one
thing. In case of two were involved, two records on a mart will
correspond the same sale, but each record will correspond it's own
sales channel (agent's) dimension key:

collumns:
- commission_fact_id
- sales_channel_key
- client_dimension_key
- commission_sum_usd
- commission%
values:
1 101 13 10 10%
1 101 13 15 15%

end users want warehouse browser to display amount sold (the base for
counting in commission). What is correct solution?
To add additional column in COMMISSIONS data mart; in that case this
fact will not be additive:

collumns:
- commission_fact_id
- sales_channel_key
- client_dimension_key
- commission_sum_usd
- commission%
- summ_sold_usd
values:
1 101 13 10 10% 100
1 101 13 15 15% 100

or run a query to COMMISSIONS data mart to get results about
commission, then run a query to SALES data mart, and combine two
results?

Thank you in advance,
Vaidotas

It depends on your front end tool. You could always add non-additvie measure
in your fact, and overwrite the roll-up behavior in your front BI tool if
possible.

"vaidasd (AT) gmail (DOT) com" wrote:

Thank you.
Well, this shall not depend on front end tool IMO. We using custom
developed metadata driven browser.



yongli wrote: