Multi-Dataset table reports (formerly Ad Hoc reports) in SAP SuccessFactors are designed to pull data from multiple, distinct data domains into a single output file. The system executes a separate query for each dataset included in the report; therefore, the data from different domains is not joined at the query level. When such a report is run without the BIRT template, the standard output is a single Microsoft Excel workbook. Within this workbook, the results from each dataset are presented on a separate worksheet (tab), reflecting the un-joined nature of the underlying data queries.

B. Report results are shown on a single tab in the output.

This is incorrect. The standard behavior is to place each dataset's results on a separate tab to maintain data separation.

C. Data is joined in the query.

This is incorrect. Multi-Dataset reports run independent queries for each dataset. Data joining is a feature of other tools like Canvas (Report - Story) reports.

1. SAP Help Portal, Implementing and Using Reporting and Analytics in SAP SuccessFactors HXM Suite, Document Version: 2H 2023.

In the section "Creating a Table Report", the subsection "Creating a Report with Multiple Datasets" states: "When you run a report with multiple datasets, the output is an Excel file with one worksheet for each dataset." This directly supports answer A.

The fundamental design of Multi-Dataset reports, as described in the same guide, involves selecting distinct data "domains". This architecture implies that separate, independent queries are run for each domain, rather than a single, joined query. This supports the conclusion for answer D.

2. SAP Training Courseware, THR92 - SAP SuccessFactors Reporting and Analytics.

The module on Ad Hoc / Table Reporting explains that the Multi-Dataset functionality is for reporting across different subject areas that cannot be joined directly in the query engine. It explicitly contrasts this with single-domain reports where related data is joined. This confirms that data is NOT joined in the query (D) and is presented separately (A).