Working with Table Reports

Reporting Domains (also called sub-domain schemas) define tables fields used in reporting. The reporting domain name is typically the same as the product name, but some products might have more than one reporting domain available for the purpose to query different parts of the module or application. Most domains are available across Table Reports and Canvas Reports, and Tiles.

When you use a Reporting Domain, you are indicating the high-level data in the system on which you would like to report.

For example, to run a report on a certain year's Goals, you start by using the Goal Management Reporting Domain.

Note: the current list of possible available reporting domains can be viewed on the help portal: Available Product Schemas for Live Data | SAP Help Portal. Domains available in your system will vary by configuration and permissions.

The first decision you need to make when creating a Table Report is its Type. There are three possible Report types:

1. Single Domain (default)
2. CrossDomain
3. Multi-Dataset

Single Domain allows you to query data from one Reporting Domain and is the default Report type option.

Multi-Dataset Reports and Cross Domain Reports allow you to query data from two or more Reporting Domains.

• Multi-Dataset Reports do NOT join data together. The report results from each selected Reporting Domain will appear on separate tabs in the output. There are separate tabs in the output which exports as an Excel spreadsheet and cannot be a CSV file.
• Cross Domain Reports join data in the query from multiple Reporting Domains. This information is displayed in one output list. When you create a cross-domain report, there are two options to join the domains: Inner Join, Left Outer Join.

Cross Domain is a query that contains multiple domains in a single list report. This implies linking data into a single record. In the example, Employee Profile details are listed in the Cross Domain Table Report along with their Compensation details and Performance ratings. When you are creating a Cross Domain report, you have several unique options.

Report Viewers and Creators have the same options available when running a report. Reports may be generated in two ways:

Running on-demand produces your file immediately, but may take up to several minutes depending on the size of the file. While the report generates, you may not navigate to other areas of the software.

• Run Online - This option runs the report and generates it onscreen
• Download (CSV) - This option creates a downloadable .csv file
• Export - This option allows you to generate a downloadable file in PDF, Excel, or PPT format

Running offline gives you the flexibility to attend other activities while the report processes in the background.

Run Offline - This option allows you to create a named, downloadable file in any of the above formats. The report runs in the background while you are free to do other things. You will be notified through email upon the completion of the report. It may be accessed by navigation to Report Center → View Schedules → My Jobs.