November 23, 2011 at 11:15 pm
I have two tables in my DB, Application Table, where the primary key is ApplicationID and a transaction table for new disbursements where primary key is ApplicationID+DisbursementDate.
Application table also contains a measure for Insurance Amount.
I want to now create a front end report in PPS using Disbursement Date from the transaction table as dimension and Insurance Amount as measure from application table.
What is the kind of relationship I should specify in Dimension Usage to make this work accurately?
November 25, 2011 at 2:00 am
This should be a Regular relationship.
The composite key could give troubles though.
I think it is best to introduce surrogate keys between those tables. It will make configuration a lot easier.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 25, 2011 at 3:36 am
The composite key could give troubles though.
I think it is best to introduce surrogate keys between those tables. It will make configuration a lot easier.
Normally I don't add something just to say I agree, but this point is so important, I want to reinforce it. I would even say the use of anything other than surrogate keys in dimension tables is not a sound design.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply