Create a Custom Report Based on a Data Model

Now you can create a report based on the data model you have created.

1. Log in to Fusion Service as a user who can use Reports and Analytics.

2. Click Navigator > Tools > Reports and Analytics.

3. On the Reports and Analytics page, click Create, and then select Report.

4. Select Use Data Model, then click the search icon and locate the data model you previously created.

5. Click Next.

6. On the Select Layout page, choose the Landscape page option, and the Table layout option, and then click Next.

7. On the Create Table page, deselect Show Grand Totals Row and then click Next.

8. On the Save Report page, click Customize Report Layout.

9. Click Finish.

10. In the Save As dialog box, enter a name such as Migration Report, and then click OK.

11. Add a layout grid by doing the following:.

    1. In the report editor, click Drop a Data Item Here, and press the delete button on your keyboard.

    2. Click the Insert tab (if it's not already selected).

    3. Drag the Layout Grid from the Components list and drop it below the report title.

    4. In the Insert a Layout Grid dialog box, enter 1 in the Rows box, and leave the Columns box as 2, and then click OK.

    5. Click the Insert tab again, and from the Components list, drag a Text Item and drop it in the first column.

    6. Double-click the text item and enter the following: Job started on or after.

    7. From the Data Source pane, drag the JOB_START_DATE parameter to the second column.

    8. Reduce the width of the Job started on or after column.

12. Add a repeating section component by doing the following:

    1. Click the Insert tab, and then drag the Repeating Section component and drop it below the Layout Grid.

    2. In the Insert a Repeating Section dialog box, select JOB ID from the Element drop down list, and then click OK.

    3. Click the Insert tab, and drag a Layout Grid and drop it into the repeating section.

    4. Click the Insert tab, and drag a Text Item and drop it in the first column.

    5. Double-click the text item and enter the following: Job ID.

    6. From the Data Source pane, drag the JOB_ID parameter to the second column.

    7. Re-size the first column.

13. Now add a data table by doing the following:

    1. Click the Insert tab, and drag the Data Table component and drop it under the row in the repeating component,

    2. While the data table is selected, click the Show drop down list on the Table tab and select the first item that indicates no (darkened) summary row.

    3. From the Data Source pane, drag and drop the following fields into the data table:

       • Event ID

       • Contact Party ID

       • Login ID

       • Event Type

       • Event Status

       • Comments

14. Click the Save icon, and then click the Done button to access the report in View mode.

15. In the Start Date field, enter a job start date, and then click Apply to view the report.