Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

how to design the model for budgets-commitments-payments

Go down

how to design the model for budgets-commitments-payments  Empty how to design the model for budgets-commitments-payments

Post  cowayne Sun Mar 27, 2011 2:54 am

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.


cowayne

Posts : 1
Join date : 2011-03-27

Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum