how to design the model for budgets-commitments-payments
Page 1 of 1
how to design the model for budgets-commitments-payments
hello everyone,
i am just build a dw, our bussiness process is
we have created a budget, and spend the budget called commintments, and the end, payment the commitment.
i have the dimenson table as beblow,
dim_mkt
dim_brand
dim_channel
and i have 3 fact table
fact_bgt
fact_commintment
fac_payment
one budget have several commitments,and one payments have several payments.
my questions is:
my boss focus on how many budget commitment and payment per channle or per brand.
sorry my english is poor.
thanks in advance.
i am just build a dw, our bussiness process is
we have created a budget, and spend the budget called commintments, and the end, payment the commitment.
i have the dimenson table as beblow,
dim_mkt
dim_brand
dim_channel
and i have 3 fact table
fact_bgt
fact_commintment
fac_payment
one budget have several commitments,and one payments have several payments.
my questions is:
my boss focus on how many budget commitment and payment per channle or per brand.
sorry my english is poor.
thanks in advance.
cowayne- Posts : 1
Join date : 2011-03-27
Similar topics
» Reasons to use a 3NF design over a Dimensional Model design for an EDW - Discussion
» dimension model design:
» Model Design - Year of Course
» Model Design With Several 0 to Many Joins?
» Overall design and data model and Informatica CDC
» dimension model design:
» Model Design - Year of Course
» Model Design With Several 0 to Many Joins?
» Overall design and data model and Informatica CDC
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum