Versions Compared

Version Old Version 26 New Version 27
Changes made by

Mercedes Rothwell

Mercedes Rothwell

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Guide Contents

Child pages (Children Display)
alltrue
pageDocupace Analytics

Click the Save icon after finished the report.

Types of reports 

 

Global Actions With the Reports

Depending on the particular role, the site configurator or back-office administrator assigns different access rights for the users. 

Converting an existing Open Report to Exago

 

Settings

 

Help

 

 

Rw ui tabs macro
Rw tab
titleDocupace Analytics
Tip

Prerequisites:

  • Core: 23.9

  • Connect: 4.63

Launch the Docupace Analytics Reports tool from the Docupace: click Reports.

Info

Information: Location of the item will be predefined and then deployed to each site.

Figure 1: Launch the Exago Reports tool

Getting Started screen is displayed. This is the starting place for the basic actions: creating, opening, and browsing reports; configuring the settings, getting help.

Figure 2: Getting Started screen

Opening a Report

 

Click Open (1) inside the Getting Started area, or Page icon (2) on the left toolbar.

A list of root folders is displayed on the left side. By default there are two folders: My Reports, and Public, but actual folders and reports can be different from site to site. Admins in the My Reports folder can have personal reports invisible for others. Reports in the Public folder are accessible for other users of the site. 

Figure 3: Open the Report

Expand the folders and choose the required report. To open a report, click Play icon.

Info

Note: The Man icon indicates that you are the owner of this record.

 

Figure 4: Open the Report

Some reports require parameters before opening.

Examples:

  1. Production Report parameters (Beginning Date, and Ending Date) (Figure 5)

  2. Event Detail Log parameter: Parent Work Item ID (Figure 6)

Set required parameters and click Run Report.

 

 

 

 

Figure 5: Productivity Report Parameters

 

Figure 6: Event Detail Log Parameter

You can do various actions depending on your access rights. Click on the folder and select the appropriate item from the list:

  • Add new root or child folder

  • Rename folder

  • Delete folder

  • etc.

  

Figure 7: Actions with folders

Creating a New Report

 

Creating the report is accessible for the users with report-creating rights. You can do various actions depending on your access rights (see the section Global Actions with the Reports).

See the Help section about how to create the contents of the reports.

1

Click Create (1) inside the Getting Started area, or + (2) on the left toolbar, and select the type of report from the list (3).

Image Removed

Figure 8: Create report

2Image Removed

Figure 9: Save report

3

Enter the name, description, and select location of the report, and click Save.

Image Removed

Figure 10: Save report properties

There are six different report types at all available in the application. Four are standalone types, and two are composite types that combine reports together. The system administrator can enable and disable other types of reports.

 

Image Removed

Figure 11: All report types

By default, there are three report types: ExpressView, Advanced Report, and Dashboard.

These type are marked with the corresponding icons in the Report list:

Image Removed

 

Image Removed

Figure 12: Default report types

ExpressView is a tool to quickly get insight into vertically expanding data records and groups. An ExpressView can optionally include a visualization.

Image Removed

Figure 13: Empty ExpressView Report

Example:

You can include interactive charts in the records.

Image Removed

Figure 14: Interactive chart

Use Advanced Report to build more complex report without requiring knowledge of SQL or the underlying data model. 

Note: Only users with a Report Creator SQL access rights can write specific functions by clicking the +Add SQL.

Advanced Reports are made using a spreadsheet-like cell-grid interface. The Advanced Reports can include geographic maps; CrossTabs; repeating groups; complex join, filter, and sort logic; drilldowns to linked child reports, and more.  

Example 1:

Select Advanced Report. There are a list of domains on the left side. Drag-and-drop to add them. (Advisor already added, Subfolder in the process, as seen in the example)

Image Removed

Figure 15: Adding a domain to the report

Example 2:

Use functions and add fields to the reports. (From the Advisors domain Advisor BD already added, Date of Birth field in the process, as seen in the example)

Image Removed

 Figure 16: Adding Date of Birth

Example 3:

Add sections to the report. Right-click sections area. In the pop-up menu you can select what to do with the report:

  • Modify, add, delete, move up or down the sections,

  • Add page or report header or footer, group them, etc.

(Footer, as seen in the example)

Image Removed

Figure 17: Adding the footer

Example 4:

You can create a sub-reports (like a reports inside the cells of upper report) to get a more detailed information about the items you are interested in.

Image Removed

Figure 18: Sub-report

Dashboard combines one or more reports onto a canvas, providing a way to create a personalized arrangement and display of related reports.

Select Dashboard. Drag-and-drop the + icon to add a new title.

Image Removed

Figure 19: Empty Dashboard

You can add various objects (URL, images, charts, graphs, texts) as well as existing reports to the Dashboard.

Image Removed

Figure 20: Adding objects to the Dashboard

Example of the Dashboard.

Image Removed

Figure 21: Example of the Dashboard

You can do various actions depending on your access rights. Select the report and right-click the rigthmost icon. In the pop-up menu you can select what to want to do:

  • Run report

  • Export report to other types (Excel, PDF, RTF, and CSV) (Figure 22)

  • Duplicate report save time setting up similar reports

  • Modify report

  • Move record to the other folders

  • Schedule report being emailed or archived

  • Manage folders and report storage

Image Removed

Figure 22: Actions with the reports

Exago Report Creator 

The Creator has the ability to create standard object reports.

Exago Report Creator SQL

The Creator SQL has the ability to create reports of standard objects, and their own SQL specific reports (similar as open reports scheduler).

Exago Report Scheduler

The Scheduler can schedule or re-schedule existing reports.

Exago Report Scheduler Admin

The Scheduler Admin can see and schedule the reports with the Schedule Admin tool.

Exago Report User (e.g., Advisors)

The User can only run reports.

1

Launch Open Report.

 

2

Go to Admin > Reports.

 

3

Go to Administration tab.

Image Removed

Figure 23: List of the open reports

4

Select Reports and choose the report you want to convert.

Image Removed

Figure 24: Select the report

5

Copy the SQL in the Query section of the report.

Image Removed

Figure 25: Copy the SQL

6

Open Docupace Analytics, click Create, and select Advanced Report.

Image Removed

Figure 26: Select the Advandced Report

7

Select + Add SQL.

Image Removed

Figure 27: Add SQL

8

Enter a value for Object Name and paste SQL into the window.

 

9

Optional.

Change parameters if needed:

  1. Select parameter “$P{…}”

  2. Select corresponding parameter in Exago window

  3. Click +Add

  4. Add single quote before and after parameter (i.e. '@toDate@')

  5. Add a value to Unique Key fields (Figure 28)

Image Removed

Figure 28: Add a value to Unique Key field

10

Click Okay on the Add Data Object Reports window.

 

11

Expand Object Name on the left hand side.

 

12

Drag and drop values to where you want them in the report.

 

13

Name your columns, add title, and format report as you desire.

 

14

Save the report.

Image Removed

Figure 29: Save the report

Click the Wrench icon to display the User Preferences.

  

Image Removed

Figure 30: User Preferences

To assign an existing report to a startup, in the Startup Reports tab select the report, and drag and drop to the right side. Then click OK.

To change the order of startup reports, use the up and down arrows.

To delete the report, click the X icon.

To add a report to the startup, click +Add button, and select the report you want to run when starting the Reports Tool.

 

Info

Note: The administrator can limit the maximum numbers of startup reports.

 

Image Removed

Figure 31: Startup Reports

If reports have user adjustments (another user have made the updates) saved on top of them, they are displayed in the User Reports tab.

  

Image Removed

Figure 32: User Reports

Reports tool has Help system built in. To access Help, click Question mark icon (1) on the top right, or down arrow icon (2) under the Learn more.

Image Removed

Figure 33: Getting help

Help system supports contents view, indexed list of items, and search function.

Image Removed

Figure 34: Help contents

Rw tab
titleDocupace Standard Reports
1

To access reports, navigate to Administration > Reports.

Administration > Reports menu

2

The system displays a list of report groups and their descriptions. To access specific reports, click on the group name.

Report groups

3

The list of reports in the group appears. To open a report, click on the respective link.

Info

Note: If a report requires search parameters, the corresponding search page opens. Some reports are run directly without additional parameters, in such case the resulting report is shown.

List of General reports

4

To return to the full list of report groups, click either Reports in the main toolbar in the top part of the page, or click Back to Groups in the report toolbar above the parameters screen.

To return to the list of reports in the group, click Back to Reports in the report toolbar.

Note

Note: Additional buttons in the toolbar are available for users with Administrative access to reports. See Reports Administration section for more information.

Main toolbar

Report toolbar