Managing Data Source Parameters

To manage parameters of express report data sources, use the Data Sources Parameters side panel tab.

Make sure that the side panel is displayed.
Select the data source with parameters on the Data Sources tab.
Go to the Data Source Parameters tab.

Select a data set that will be displayed in the express report in the Display Versions drop-down list.

NOTE. Display versions of data source in the express report are available only if a single data source is used.

Available versions depend on the data source type:

Standard cube. The display versions determined on cube creation are available.
Calculated Cube. The following options where N is calculated cube name are available:

N. Cube data.
Formulas N. Cube data calculated by formulas determined in the formula editor for calculated cube.

Time Series Database. The following options where N is time series database name are available:

Attributes N. Time series data as for the last revision by the Fact scenario with the Attributes additional dimension. As elements, the dimension contains all attributes of series level and observation level except for system attributes with multiple values.
If attribute is a link to a dictionary, all attributes the used dictionary will be displayed as children elements for it.
Value editing is available only for observation attributes.
Complete Data N. Time series data with the Revisions and Scenarios additional dimensions. The Revisions dimension provides access to the time series data as for various revisions. The Scenarios dimension provides access to time series data of various scenarios.
Value editing is not available.
Scenario Data N. Time series data as for the last revision with the Scenarios additional dimension. The Scenarios dimension provides access to the time series data of various scenarios.

NOTE. The Scenario data N option is available, if a time series database supports scenarios. For details see description of IRubricator.HasScenarioDimension.

Actual Data N. Time series data as for the last revision by the Fact scenario.
N. Time series data by the Fact scenario with the Revisions additional dimension. The Revisions dimension provides access to the time series data as for various revisions.
Value editing is not available.

NOTE. Additional dimensions are displayed in the Selection side panel group of tabs.

Set values of data source or express report parameters in the Parameters area.

NOTE. Parameters are available if data source is a parametric cube, or express report’s active sheet contains proper parameters.

To copy a data source, select the Copy item in the data source's context menu. After this the data source copy is added to the list of data sources, and separation of parameters is activated if the report was not created based on several data sources.

Name of the data source copy is generated in the format: <Data source name> copy N, where N - copy number.

To rename the data source, select the Rename item in the data source's context menu. After this the cube will be renamed in the report and in the object navigator.

To remove a data source from the list, select the Remove item in the data source's context menu. Source data will be excluded from the report.

To update express report data according to the set values, click the Apply Parameters button.

Separating Data Source Parameters

To separate parameters of several data sources or to use a single data source with different parameter sets, use the Separate Parameters checkbox. The checkbox is enabled and selected by default:

The appearance of the Data Source Parameters tab when data source parameters are separated:

To change express report data, set parameter values of corresponding data sources.

If the Separate Parameters checkbox is deselected, parameters of different data sources are combined into one list without separation.