Data Export

The Data Export dashboard option opens the self-service Data Export Utility (Oracle Site Analyze required).

If you have a role with Data Export Management permission, you'll see the Data Export option in the global menu's Dashboards section. Data Export Utility for Oracle Site Select is a self-service tool that lets you design a CSV extract with specified data columns and filters. Currently, the extract includes data columns for site feasibility, survey response, notes, and study site users.

The Data Export Utility allows you to create new extracts based on:

• Cube (a multidimensional array of data) – The available data cubes are Note data, Site survey responses, Study site data, and Study-site users. You select one cube per extract.
• Columns (dimensions) – For example, PI Name, PI email address, Country, Study, etc. You can add columns in any order.
• Filters – For example, Study name, Country, etc. You can also add filters in any order and specify an operator (e.g., contains, equals, is null, etc.) for each filter.

The utility includes a preview mode that allows you to view a previously-created report. Preview mode provides pagination controls and page count to ensure acceptable response time for high-volume reports. Each page can include up to 10,000 rows, and the preview page displays the first 100 records. A "Total records" value displays to the left of the pagination controls to show you the total records returned based on the report's filters.

You can optionally share reports you've created with other users in your account who have permission to access the Data Export Utility. Shared reports are read only for all users except the report author, who has full access to edit, delete, etc. When non-authors view shared reports, they do not have the option to edit or delete; however, they can Preview and Export shared reports as preferred.