17 Technical Documents

This chapter covers the following topics:

• Reporting Data Model: Please refer to the Doc ID 3077248.1 to retrieve the FCCM Monitor Cloud Service's Glossary of the Reporting Data Model (RPD Documentation).

Create custom reports

Follow these steps to create a workbook from a dataset using ATP source tables:

1. Navigate to the Oracle Analytics Server home page.
2. Click the Create button at the top right corner, then select Dataset.
3. In the Connections pane, choose FCCM Analytics - Public - ATP.
4. When the New Dataset page opens, drag the Manual Query option into the blank area on the right.
5. Once the Manual Query widget appears, right-click it and select Edit Definition.
6. In the query editor, enter your SQL statement in the provided space. Click Get Preview Data to view the results, then select OK.
7. Choose the data access type: Automatic Caching or Live, based on your requirements.
8. Save the dataset using the Save option at the top right corner.
9. After saving the dataset, the Create Workbook option is enabled.
10. Click Create Workbook. A new canvas opens with the Data Panel displaying all attributes from your SQL query.
11. Right-click on an attribute and select Create Best Visualization or Pick Visualization from the available options.
12. You can adjust visualization properties from the Properties tab.
13. Finally, save the workbook to the catalog under Shared Folders > Monitor CS > MONITORCS Ad-hoc Analysis.