Report editor

A report is a compilation of one or more charts that have a common technical context.
You can, for example, assign your own titles, switch automatic updating on or off or specify the order of the charts contained. In addition, access rights can be assigned for individual reports and variables can be made available to allow consumers to make their own adjustments.

User interface

User interface in the report editor
  1. Report overview

  2. Configuration of a report (see Configuration of a report)

  3. Preview area of the selected report

Adjust areas

The width of the individual areas can be adjusted or completely collapsed, e.g. to make hidden information visible.

Adjust the width of areas:
Reduce and enlarge areas
Collapse or expand areas:
Collapse and expand areas

Live Update

Live Update
What is the "Live Update" function used for?

Activating the Live Update ensures that changes in the chart are visible directly in the preview area.

When should the Live Update be deactivated?

If comprehensive charts with many data points are to be displayed, rendering and visualizing the charts requires more capacity. Depending on your individual resources, the performance of the application may be affected.
Therefore, if you notice or expect limitations during configuration or a slow image build-up in the preview area, deactivate the live update.

Add/manage reports

Button/icon Description

Add

Creates a new element.

Duplicates the selected report including all configurations and adds the copy to the list.

Removes the selected element.

Execute

Creates a report based on the existing configurations.

Save

Saves the configurations or changes.
If changes are not saved, a message appears.

Configuration of a report

Here you will find the possible settings for reports. Adjustments are possible in the following areas:

General settings

General settings
  1. Naming of the report.

  2. Switching the automatic reload of a report on/off.

  3. The interval in seconds at which the automatic update is repeated.
    If the auto-update is switched off, this setting has no function.

Layout configurator

You can determine the arrangement of the charts in the layout configurator.
The following options are available:

Layout configurator
  1. Vertical: Each chart occupies the full width and shares the height with the other charts.
    See ExtJS documentation for the configuration of horizontal layouts.

    Example of vertical arrangement
    Vertical layout
  2. Horizontal: Each chart occupies the full height and shares the width with the other charts.
    See ExtJS documentation for the configuration of horizontal layouts.

    Example of horizontal layout
    Horizontal layout
  3. Column layout.
    See ExtJS documentation for the configuration of column layouts.

    Example of column layout
    Column layout
  4. Tab layout.
    See ExtJS documentation for configuration as tabs.

    Example of tab layout
    Tab layout
  5. Accordion layout
    See ExtJS documentation for configuration as accordion layout.

    Example of accordion-style layout
    Accordion layout

Selected charts

The selection of charts in the report is realized via a tabular view.
The table contains the following columns:

Chart selection
  1. Selection of all charts created for the current module component.

  2. A title can be assigned as an alternative to the chart name. This can be seen as a heading in the tab layout, for example.

  3. Chart type of the selected chart, which is displayed as an icon (cannot be changed).

  4. JSON field for assigning additional 'ExtJS' layout Parameters to individual components (e.g. \{"flex" : 2}).
    Varies depending on the layout type (see Layout configurator).

  5. Edit chart.
    Opens the chart editor for editing.

  6. Remove chart.
    Removes the selected chart from the report.

  7. Add chart.
    Adds a new chart to the report.

Variables

Report variables can be defined in the Variable Configurator to make charts customizable for consumers. These variables are created at report level and can be associated with charts and their underlying data set variables (see Data set variables).
Consumers can thus determine the time intervals or date periods considered themselves, for example.

Variables
  1. Naming of the report variable.
    The name can be changed directly in the cell by double-clicking.

  2. Value of the variable.
    The value can be changed by clicking in the field or in Variable detail view.

  3. Variable type that was defined in the Variable detail view when it was created.
    Should be identical to the variable type of the data record variable when linked, see Data record editor (cannot be changed).

  4. Activates/deactivates access to the variable for consumers.

  5. Activates/deactivates the global link (see Global variables)

  6. If the global link is active, you can click on a global variable can be selected by clicking.

  7. Each data set variable used in the report receives exactly one report variable to which it is linked. This report variable receives the default value from the data set variable associated with it.
    All changes made by the user to the report variables are reset by this action.

  8. Opens the Variable detail view. A window opens in which user-specific variables can be added and existing report variables can be linked (i.e. associated) with data set variables.
    The detailed view also offers a preview of all existing charts with their associated data set variables.

Global variables

Global variables are already available in the BPC context, including:

Global variable Type Description

Bpc User

Text

The logged-in user in the BPC

Global Date Range Start

Date

Start value from the "Global Date Range Filter" (see Global date filter)

Global Date Range End

Date

End value from the "Global Date Range Filter" (see Global date filter)

These variables can be bound to report variables of the same type. This transfers the value from the global variable to the report variable.
If a global variable is not available, the value that is set on the report variable is used.

Variable detail view

The detail view is divided into two areas:

Variable detail view
  1. Listing of all report variables

  2. Listing of all charts with associated data set variables
    The variables are grouped by chart

The following information is also visible:

variables detail 2
  1. Name of the report variable

  2. Current value of the report variable

  3. Type of report variable

  4. Selection of the visibility of the report variable

  5. Selection of whether the report variable is globally active

  6. Info on whether a global variable is active + whether a global variable is active

  7. Selection for linking the data set variable with the selected report variable

  8. Name of the data set variable

  9. Value of the data set variable

  10. Type of the data set variable

Add report variable

  1. Click Add.

    Add variable

    A window opens:

    Define variable
  2. Enter the name and select the type.

  3. Click Add.

The variable is created and appears in the overview of report variables.

Association of report variables with data set variables

The following conditions must be observed when associating variables:

  • The data set variable to be linked must have the same type as the selected report variable:

    association1
  • The data set variable to be linked must not already be linked to other report variables:

    association2
Link report variable with data set variable
  1. Select the report variable to be linked.

    Select report variable
  2. Select the data set variable whose checkbox is active (only then is a link possible):

    association3
  3. Select the checkbox:

    association4

    The link is now active and the value of the report variable is transferred to the data set variable.

  4. If necessary, add further associations.

  5. Click Save.
    The detail window is closed and the variable configuration and the entire report are saved.

A report variable can be linked to any number of data set variables.

If you want to restore the previous report configuration, click Cancel.

Access rights for consumers

Here you can restrict the access rights of reports for the report consumers. The "Rights/Roles/Organizations" principle is used for this, see Mapping of organizations, roles and rights.

Set access rights
  1. Allows consumers to enable or disable the automatic reload of the report.

  2. Allows consumers to adjust the frequency of the automatic reload.

  3. Enter the rights designation or (if available) select an entry from the drop-down list.

  4. Enter the role name or (if available) select an entry from the drop-down list.

  5. Enter the organization name or (if available) select an entry from the drop-down list.

Save the settings.

You can now continue at Catalogue editor.


Keywords: