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

We must go by our requirements in-sync with guidelines for designing
EDW e.g. If we have any banking table it may contain semi-additive fact
tables but complete information can be derived out of it.

If I have to do this then I would have following columns:
and I will ask user to have commission_sum_usd in their DB View as a
derived column or may be calculated value in user package.

Regards,
HB




vaidasd (AT) gmail (DOT) com wrote:

Thank you for response, what means "to have commission_sum_usd in their
DB View as a derived column" ?
Is this some end-user tool specific thing?

Vaidotas

bhatnagar.harsh (AT) gmail (DOT) com wrote: