For more information, please refer to this announcement explaining best practices for getting answers to questions.
When I add a specific filter that I need, my report errors
I have an analysis in Workforce Learning - Learning Records Real Time
Here is my SQL:
SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1',PREFERRED_CURRENCY='User Preferred Currency 1';SELECT
0 s_0,
"Workforce Learning - Learning Records Real Time"."Assigned Learning Item Information"."Assigned Learning Item Title" s_1,
"Workforce Learning - Learning Records Real Time"."Assigned to Information"."Assignee Display Name" s_2,
"Workforce Learning - Learning Records Real Time"."Assigned to Information"."Assignee Person Number" s_3,
"Workforce Learning - Learning Records Real Time"."Learner Activity Attempt Information"."Activity Attempt Completed Date" s_4,
"Workforce Learning - Learning Records Real Time"."Learner Activity Attempt Information"."Activity Attempt Status Description" s_5,