August 14, 2009 at 6:47 am
Hi,
Imagine that you have a fact table(number of clients, income) of the clients and its dimensions.(jobs, tranche age, studant.. )
But on the other hand, you have a fact table of credits(amount) and its dimensions type of credit.
When they are two different etudes , I have no problem. I can put out medium incomes of the students...And also I can put out the medium amount of a special credit selected ..
But my problem is to put out the medium amount of the students(dimension of the fact table client) for a special type of credit selected
Can yu please help me??
When I lie these two fact tables with the help of a bridge table (attribut:cleint id)I can get the medium numbers of students who have a special type of credit but I can't get the amount of credit for different profiel of clients(for exemple student).
In fact if i had to do a summery , the problem is to get the measure of a fact table as using th edimension of the other fact table??
Do u have any idea??
August 19, 2009 at 3:42 am
Hi, I've solved my problem as using a bridge table i could get the measure of a fact table sur an axe analyse(dimension) which is not lied directly to fact table.
But it must be defined perfectly the relastions between fact table dimension table and the bridge table
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply