Steps to Create Custom Report in Fusion Cloud Apps:
1) Login into Fusion Cloud Applications.
2) Navigate -> Report and Analytics under Tools
Click on Create -> Report as shown in below screen
We need to create a Data Model . So click on Create Data Model link as shown in below screen.
Click on New Data Set icon as shown in below screen . Select SQL Query.
Give a Name for Data Set and write query SQL Query Section. select Data Source . I have Selected Data Source as ApplicationDB_HCM.
Click on OK Button.
Click on Data Tab and click on View Button to see the sample data for the query which you have written.
Click on Save as sample data button and click on save icon also to save the data model.
Once the data model creation is completed Click on Create Report icon to create a layout for report
Click on Next Button for below screen
select layout as Table and click on next button.
Drag the column from source and drop on the layout .Click on Next button
Click on Finish button
1) Login into Fusion Cloud Applications.
2) Navigate -> Report and Analytics under Tools
Click on Create -> Report as shown in below screen
We need to create a Data Model . So click on Create Data Model link as shown in below screen.
Click on New Data Set icon as shown in below screen . Select SQL Query.
Give a Name for Data Set and write query SQL Query Section. select Data Source . I have Selected Data Source as ApplicationDB_HCM.
Click on OK Button.
Click on Data Tab and click on View Button to see the sample data for the query which you have written.
Click on Save as sample data button and click on save icon also to save the data model.
Once the data model creation is completed Click on Create Report icon to create a layout for report
Click on Next Button for below screen
select layout as Table and click on next button.
Drag the column from source and drop on the layout .Click on Next button
Click on Finish button
No comments:
Post a Comment