Enhancing Data Coverage for Queries

Objective

After completing this lesson, you will be able to enhance data coverage for queries in SAP SuccessFactors Story Reports.

Report Schema Join Manager

The schema joins in reporting enable you to navigate from one module schema to another, so you can include columns from multiple schemas in story reports. Default Joins are system-defined and cannot be altered.

The Report Schema Join Manager tool allows you to view default joins. All the default joins are available to all users who build story reports. On the Report Schema Join Manager tool, the predefined joins are available under the Default Join tab.

Screenshot of the Default Join tab.

Note

The tool contains a Custom Join tab, which is disabled. If there are any joins within the Story schemas that are missing, SuccessFactors requests you to raise an Influence Request with the business reason for the joins.

Custom Objects with Story Reporting

By default, all the standard MDF objects are available for reporting in Story. Custom MDF objects are also reportable by default, but they appear in the Available Data section of the Query Designer page only after you associate them with one or more schemas. You need to identify the schemas you want to link with the custom MDF object. You can also create a custom schema, if needed.

Screenshot of the Available Data section.

To add an Object to a Schema, complete the following steps:

  1. Navigate to Manage Data.
  2. In the Report Object Configuration Entity type, search for the custom MDF object.
  3. Choose Take Action→Make Correction.
  4. In the Sub-Domain Schema List section, select the schemas you want to link with the custom MDF object instance.
  5. If you want the object to be selectable as the first table of a query, set Is Root to Yes.
  6. Choose Save.

    Note

    If a record does not exist, create a record of the Report Object Configuration Entity type for the MDF object to make it reportable.
  7. Add an object to a schema, as described in the preceding text.

Custom Schema Creation

To create a Custom Schema, complete the following steps:

  1. Navigate to Manage Data.
  2. In Create New, select Report Schema Configuration Entity.
  3. Enter the name of the Sub-Domain Schema in Schema ID.
  4. In Schema Label, enter a label for the schema that appears in the Available Data section of the Query Designer page.
  5. Choose Save.

    Note

    A custom schema must have at least one root object to appear in the Available Data section of the Query Designer page.
Screenshot of a custom schema, as described in the preceding text.

Custom Blocks on People Profile in Story Reporting

You can use Story Reports to retrieve data from custom blocks created using custom MDF objects in People Profile (Employee Profile). To achieve this, administrators create a generic object with an externalCode of datatype user, and create a custom UI. They then utilize that UI in People Profile

Custom MDF objects configured as custom blocks in People Profile are accessible as related tables of Basic User Information in the User schema. If it is linked to multiple schemas, it appears as a related table for the Basic User Information table multiple times (once for each linked schema).

To make the custom MDF object auto-joined to the Basic User Information table, ensure that you link the object to at least one standard or custom schema as its root object.

A custom MDF object titled Company Car displayed in Carla Grante's People Profile and demonstrates an auto-join feature in the Query Designer interface for data integration.

Summary

Report Schema Join Manager: View default joins between schemas in Story Reports; custom joins require an Influence Request.

Custom MDF Objects in Reporting: Link custom MDF objects to schemas to make them available in Query Designer.

Custom Schema Creation: Create custom schemas in *Manage Data* to expand reporting options.

Custom Blocks in People Profile: Retrieve data from custom blocks by linking them to the Basic User Information table.

Query Designer Actions: Use filters, calculated columns, and related tables to enhance data coverage in reports.

Learning

SAP FacebookSAP YoutubeSAP LinkedIn