I'm facing an issue when am trying to create a composite key in Final layer to link 2 fields in a table.
eg: I have 2 tables Incident and Solution. I have connected these 2 tables by using "SOLUTION_ID" field. In chart am getting inconsistent data, since the "Period" field in both the tables 're pulling the records which 're not similar. So decided to link the Period field as well. But if I do this, I will get a synthetic key. To avoid this, am trying to create a Composite key by using these 2 fields as below
Incident table: Field1: SOLUTIONBASEID renamed as SOLUTION_ID. Field2: AppYearPeriod