I don't think you are talking about a dimension table rather it appears as fact table.
Best way to handle is build every thing in a single dimension and as every record is associated with a surrogate key you can get the values with group by clause.
and creating sub dimensions is allowing...
Hi nchapman,
continuation for your posting......
you take the balances and running balances as measures in the fact and while retrieving multiply them with the wieghting factor.
For hetrogeneous products if the measures are different(obviously the measures will be different) you create a fact...
Hi nchapman,
To cope up with joint accounts you link the customer dimension with account dimension which will act as a bridge table between the customer and the fact table and take a field wieghtage. and the mechanism is if the account type is single wieghtage factor is 1 if in joint account...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.