August 11, 2009 at 7:00 am
hi,
I've already designed my architecture but i have a problem:
I will not explain in detail( because it is long) but
I have two fact tables:
I) factClient
age
number of partner
domicile income
are the measures of that fact table
II)factProductCredit
outstanding
annuity
are the measures of that fact table
fact table of cleints is attached to 2 dimension tables:
dimStudent-->student or not
dimConvention-->have a convention or not
fact table of credits is attached to a dimension table
dimCredit-->all hierrachical structure of credits: credit car, habitation, consommation...
I have relied that two star schema with client_ID as bridge table and i've constituted my cube
Now i can put up the number of clients who are students and who have convention and also who have habitation credit.THE RESULT IS TRUE
but if i want to put up the annuity of credit habitation of the clients "student " and "not student" , annuity doesn't change from student to "not student", I can put up the true annuity results for different type of credits but not different type of populations:(
I think my architecture is logic but i don't know how to lie th emesures of client to th emeasures of credits ??
do u have any idea??
August 11, 2009 at 7:51 am
It's a little hard to tell, but it sounds like you may have a 'many-to-many' business requirement here (and definitely sounds like you are either missing relationships between your facts and dims, or they are at a minimum, not correct). I would look over Marco Russo's "The many to many revolution' document and see if one of his many examples as close to what you have.
Steve.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply