Cannot correcting my Query in Data Model
Hi Friends,
I want to get Participant Participant Last Name, Cost Center, Plan Component and Earning Amount Per Performance Measure but iam getting Failed to Load SQL Error. Its working fine wtihout adding Cost Center information but when i trying to add Cost Center information in Data Model iam getting error.
and this is the Query;
select "Calendar_1"."Period Name" as "Dönem",
"Participant_1"."Participant Name" as "Acente Adı",
"Participant_1"."Participant Last Name" as "Acente Kodu",
"Plan Component"."Plan Component Name" as "Plan Bileşeni",
"Earning Transaction"."Output Achieved" as "Hakediş",
"- Attainment Summary"."Output Achieved ITD" as "Ölçü Sonucu",