Report Building Process

You can use CDM to design your reports and to add content.

The report building process consists of the following tasks:

1. The administrator constructs a new report.
2. The administrator organizes the report by adding sections and report objects to the report.
3. Users add text and numeric data to the report objects, and can collaborate on content and further customize information displayed in the report.
4. A report can be produced in various formats.

Add a Report

You can create a financial report for internal or external publication. CDM can simplify and accelerate the process of submitting reports.

1. Click the Home tab, then in the Navigation Pane, click Administration.
2. Double-click Reports. The Reports tab opens in the work area.
3. In the report list, right-click the report group and select Add Report. A new row representing the new report opens in the table.
4. Type a name for the report, and press Enter.
5. If a workflow template in Administration > Workflow > Workflow Templates has been designated as the default workflow template, it is assigned to the new report.

Reuse Existing Reports with the Rollforward and Cascade Features

You can reduce the amount of time required to create a new report by reusing an existing report or report object.

You can use the Rollforward or Cascade feature to copy existing reports or report objects to new reports.

• The Rollforward feature creates a complete copy of a report or report object in the destination report. All report features, including the report structure, security settings, shared objects, data, and XBRL projects along with their associated facts are duplicated in the destination report.
• The Cascade feature converts shared objects to reference objects in the destination report.

The checkout and lock status of reports or report objects does not affect the ability to perform a Rollforward or Cascade operation. If a report object is checked out, the most recent version from the database is used.

For both features, the association between the source report and the destination report is recorded in the CDM database. The association record can include the path between more than two reports. For example, if you cascade Master 1 to Report 1, and then cascade Report 1 to Report 2, the association record would include the path between three reports. The report path appears in the Object Explorer status bar. The association records for reports support the Change Reference and Push Down features.

These records are also created for reference objects, which support the Break Reference feature and allows you to change which source object they reference in the Rollforward or Cascade wizard.

The following example describes the processing of report objects with Rollforward and Cascade features.

Report 1, the source report, contains Obj1 (a shared report object), Obj2 (a reference object to Obj1), and Obj3 (a non-shared report object). Obj1, Obj2, and Obj3 are associated with a defined query, Query1. Query1 depends on the query variable QueryVar1. QueryVar1 is defined at the report level (Report 1,QueryVar1) and for each report object (Obj1,QueryVar1, Obj2,QueryVar1, Obj3,QueryVar1).

The following diagram shows the results of Rollforward and Cascade actions. Report 4 and Report 5 show the results of subsequent Rollforward and Cascade actions.

The Rollforward and Cascade operations do not duplicate queries. Queries are not linked to a specific report. The associations between report objects and queries are copied to the destination report. The report-level and object-level query variables are copied to the destination report. In the Rollforward or Cascade wizard, you can modify the query variables. You can modify the value for object-level and data query-level variables.

If the report is associated with an XBRL project, when you roll forward a report, you can create a new XBRL project and can edit the time periods in the report. Any XBRL tags in the source report remain in the destination report. You must have application permissions to manage projects in order to do this.

To reuse an existing report using the Rollforward or Cascade feature:

1. In the Reports tab in the work area, right-click the source report and select Rollforward or Cascade.
2. Complete the steps in the wizard that opens.
3. The new report appears in the destination report groups.

Edit the Properties of a Report

You can edit the properties of a report. Properties are elements such as the name and owner.

1. In the Reports tab in the work area, select the report that you want to edit.
2. Right-click the report and select Properties.
3. In the Properties tab of the Properties and Comments window, edit the properties as you want. You can change any property that is not gray.
4. Click OK.

You can view or edit the following information:

Specify Report and Section Due Dates

A due date is applied to a report or a section to indicate a deadline for when work should be completed.

How Due Dates Are Used

Users granted the Modify Report Properties permission can assign a due date to a report. Users granted the Manage Report Object Properties permission can assign a due date to a section or to a report object.

The due dates are used to indicate the date on which all work should be completed. If the due date is equal to the current date or has passed, Current State Due Date in the Properties and Comments window is highlighted.

Manage Due Dates and Due Date Inheritance

Due dates can be managed at any level of a report (report, section, or report object).

• Create and apply report-level due dates to all sections and report
  • To set or change a due date for a CDM report, in the Report tab in the Navigation Pane, right-click the report and select Properties > Manage All Report Properties, then enter a date in the Report Due Date field.
  • To apply the due date to all sections and report objects in a report, right-click the report and select Properties > Apply Report Due Date. The descendant report objects and sections will now inherit the due date from the report due date setting.
• Create and apply section-level due dates to all descendants within a section
  You can set an explicit due date for a section by clearing the Inherit Due Date checkbox in the Properties and Comments window (right-click the section and select Properties > Manage All Section Properties) and setting a new due date. When set, the due date is inherited by any new objects or sections that are added as descendants to the section. At any time, you can apply the section due date to all sections and report objects within the section by right-clicking on the section and selecting Properties > Apply Section Due Date. Due dates for the descendant sections and report objects are discarded and they inherit the section due date.
• Create and apply report object-level due dates to an individual report object
  You can set an explicit due date for a report object by clearing the Inherit Due Date checkbox in the Properties and Comments window (right-click the report object and select Properties > Manage All Object Properties). You then enter a new due date for the report object in the Report Object Due Date field.

Workflow State Due Dates

Due dates can also be applied to workflow states to enforce when certain stages in the workflow must be completed.

When the due date for a workflow state has passed the workflow due date of the report object, the section or report will be highlighted in the Properties.

The workflow state due date for a report object, section, or report is calculated relative to its due date.

To learn more about how to set workflow state due dates and how they are calculated, see Workflow State.

Refresh a Report

When you generate a report, CDM reloads data from the application cache. You can choose to manually refresh the report to make sure that the data is up to date.

1. Open the report that you want to work with.
2. Click Home > Refresh Report > Quick Refresh Report or Full Refresh Report. Quick Refresh Report reloads data from the local cache while Full Refresh Report fetches data from external data sources.

Data and any modified settings are updated throughout the report. If the parts of the report are delegated to other users, the changes appear when the other user logs in to CDM or refreshes the report.

Delete a Report

If you no longer need a report , you can delete it. You can delete a report only if no report objects are checked out, and if the report does not contain shared objects that are referenced in another report.

Important: If you delete a report, you cannot undo your action. Proceed with caution. You should create the necessary database backup for future reference.

To delete a report:

1. In the Reports tab in the work area, select the report that you want to delete.
2. Right-click the report and select Delete.
3. In the confirmation window, click Yes.