Configure the report to fetch Workers Historical performance review information.
Procedure
-
Create the calculated fields.
-
Create Aggregate Related Instances Calculated Field named CF_Competencies_all.
-
Create Aggregate Related Instances Calculated Field named CF Content Evaluation - Accomplishments all.
-
Create Aggregate Related Instances Calculated Field CF_Content Evaluation - Areas for Development all.
-
Create Aggregate Related Instances Calculated Field named CF_Content Evaluation - Career Interests all.
-
Create Aggregate Related Instances Calculated Field named CF_Content Evaluation - Goals all.
-
Create Aggregate Related Instances Calculated Field named CF_Content Evaluation - Responsibilities all.
-
Create the report.
-
Access the Create Custom Report task.
-
Enter a report name.
-
Select report type as Advanced.
-
Deselect the Optimized for performance option.
-
Select Data Source as Workers by Organization.
-
Deselect the temporary report box and then click ok.
-
Select the report business object and report fields.
-
In the Group column heading section, select all business object as given below.
Group Column heading for each business object will be blank.

-
In the Sort section, select the value.
-
In Sort section, under Sub level sort, select the value.
-
In the Filter section, select the value as given below.
Add parenthesis as given in the image.

-
In Sub-Filter section, select the value.
Add parenthesis as given in the image.



-
In the prompt section, click on populate undefined prompt defaults check box.
-
Select the value of prompts as given below under Prompt default section.
Confirm that the Label For Prompt XML Alias of all prompt fields is the same as the image below.

-
In the advanced section, select enable as webservice, and click OK.
-
Select the three dots icon and go to web services> view URLs option.
-
Select the organization for which you want to run this report and check the box if you want to include subordinate organization and managers.
-
In the View URLs Web Service page, click on marked icon under CSV section.
A new browser tab opens.

You can see the RaaS URL of the report in new browser tab.