BI Publisher (MOSC)

MOSC Banner

Cannot correcting my Query in Data Model

edited Jan 17, 2019 8:58AM in BI Publisher (MOSC) 6 commentsAnswered

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",

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center