Configure a report to access it in data workbenches

  • A data workbench configured report group exists.
  • The State attibute of the configured report is set to Plan.

Define the queries for the report with a reference to the objects in the data workbench. Use the @BASES parameter to refer to the objects currently displayed in the data workbench. Use the operators IN or NOT IN with the parameter @BASES in WHERE clauses.

  • SELECT NAME, VERSION
  • FROM APPLICATION
  • WHERE APPLICATION.REFSTR IN (@BASES)

Assign the report to a data workbench configured report group. In the attributes of the configured report, define the attributes in the Data Workbench Settings section:

  1. Go to the Report tab in Alfabet Expand.
  2. Click the configured report and set the following attributes.
    • Accessible for Data Workbenches: Set this attribute to Access.
    • Data Workbench Configured Report Group: Select the data workbench configured report group the report shall belong to.
    •  Apply to Class: If the attribute is set to an object class, remove this setting. The Alfabet@BASES parameter does not work if the configured report is applied to an object class.

If applicable, disable the Export button. Change the state of the configured report to Active. Open the user interface and open the configured report via the Visualize button in the data workbench. Check whether the export options are working for the configured report. If export is not working, hide the Export button:

  1. In the explorer, expand the report node and the underlying report view node.
  2. Click the PO_<report name> node.
  3. Set the Has Export Button attribute to False.