1. In the Reports tab of Alfabet Expand, right-click the Reports folder or a sub-folder thereof and select Create New Report. You will see the newly configured report listed below the selected folder.
  2. In the attribute window, select Custom in the Type field.
  3. Define the following attributes:
    • If an attribute is not described in the following, the attribute is not applicable to Sankey diagrams.
    • If you have already created Sankey diagrams, you can copy and paste settings of an existing configured report to your new configured report and make modifications, as needed. Right-click the existing configured report and select Copy. Right-click the new configured report and select Paste

    Required settings:

    • Template: Select SankeyReport.
    • Name: Change the default to a meaningful technical name.
    • Caption: Enter a caption for display on the Alfabet user interface.

    Optional description: Descriptions for configured reports are displayed in data workbenches and can be included in the property groups of the content area for reports. A description defined in the Description attribute is additionally available in the Configured Reports standard view. Descriptions can be defined in the Description and Technical Comment field. You can alternatively use the Technical Comment attribute exclusively in Alfabet Expand to provide information that is useful for solution designers working with Alfabet Expand to better understand the configured report from a technical perspective.

    Optional base class specification: If you define a configured report to a base object to open it with information specific for a selected object. In the configured report attributes, you must specify the base object with one of the methods listed below. In the queries defining the content of the configured report, you can then refer to the REFSTR object class property value of the base object with the Alfabet parameter BASE.

    • Apply to Class: When the configured report is applied to a class, the base object is evaluated in two ways: .
      • If the configured report is added to the content area of the selected class, the base object is automatically the object the user is currently working with.
      • If the configured report is opened anywhere else, a filter for selection of a base object will automatically be added to the filter panel of the configured report.

        If the configured report is applied to an object class stereotype, the filter field for selection of the base object will use the caption of the object class stereotype as caption of the filter field and the selector defined in the class settings for the object class stereotype for selection of the base object.

    • Base Object Query: If you define a base object query for the configured report, a base object will be evaluated for the configured report at runtime. and define either a native SQL query or an Alfabet query that returns a single object. As the base object query is executed at runtime, you can use Alfabet parameters referring to the current working environment in the query. This also includes the Alfabet parameter BASE referring to the object the user currently works with.

    Settings for execution:

    • Execute on Enter: If you set the attribute to True , the configured report is executed with empty filter settings when a user accesses it. If you set the attribute to False , the user opens without content unless the user sets the filter. By default, this attribute is set to True . It should only be set to False when a configured report would result in an exceedingly big dataset when executed with empty filter settings.
  4. In the explorer, right-click the configured report and select Create Configured Report View. The report view editor opens in the middle pane. In the explorer, the custom report view is displayed as a subordinate object of the configured report. The attributes for the custom report view are displayed in the attribute window. You can optionally edit the following attributes:
    • Name: Optionally you can change the name for the custom report view. The Name must be unique for custom report views.
    • Can Create Bookmark: Select True if a bookmark may be created for the configured report. Select False if a bookmark may not be created for the configured report.
  5. In the explorer, right-click the configured report and select Start Alfabet Report Assistant.

    The custom report view initiates the report assistant. A custom report view shall never be deleted from the configured report after the report assistant was already used to define the configured report. When you delete the custom report view of an existing template-based configured report and create a new one, the report assistant is reset to the example specified by default and your configuration is lost.

  6. Define the configured report as described below in the sections for the configuration of the Sankey report.
  7. Click OK to save the configuration.
  8. In the toolbar, click the Save  Save_Expand button.
  9. In the explorer, right-click the configured report and select Set Report State to 'Active'.
  10. In the explorer, right-click the configured report and select Review Report. The configured report opens in a web browser. If the results are not as expected, you can re-set the report state to Plan and edit the configured report until the output of the configured report meets your expectations. The final report state must be Active . Only active configured reports are displayed on the Alfabet user interface.