i have few excel sheets from which i want to make dashboard but i am facing Synthetic key error, can anyone help me to solve these 3 synthetic key?
attached is my Script:
vinieme12 Do you want data file for reference?
Yes , a sample app will be helpful
Attached is my sample data file and Qvf.
i have still 3 synthetic keys error, can you please correct my script? as i dont understand how it can give impact to my results.
Share a sample qvw file.
This is the error
Lines fetched: 57
$Syn 1 = Team+Role
$Syn 2 = Employee+Month+Team
$Syn 3 = $Syn 1+$Syn 2
for this $Syn 1 = Team+Role
You have to write
i corrected this but still the same error 3 Synthetic keys
Can you please tell me in allocation tab what you have to do.
I mean which criteria basis you need join the tables
In Allocation tab i want to join employee and its role that is allocated.
Have you check the attachment ?
Thanks for help, can you let me know how did you did this without changing names of field..
i mean how did you ignored synthetic keys?
First synthetic is because of your join keyword is not proper.
Second is in Resource Allocation table have multiple same common fields name, hence you will get two synthetic key here. so i join this MonthlyData table ....
three synthetic keys is not a big issue, More synthetic keys will not effect your data. even if we take link tables that also same, So you no need to bother about the synthetic keys in your data model.
You can continue with reports without any fear.
Retrieving data ...