Opening Report Templates

In the Desktop Client:

Click the reporting task you want to use.
On the Basic Options tab, select the options for the template. The available settings and options depend on the task settings and may include, for example, data type, financial year, period, dimension and unit. For more information, see Basic Options.
If the Advanced Options tab is available, you can select additional options for the template. For more information, see Advanced Options.
Click Open Template.

In the Web Client:

Select the reporting task you want to use from the navigation bar.
All available task options are listed under the task heading. For descriptions of the options, see Basic Options and Advanced Options.
Click Open.

You can save reports to your Favourites (see Favourites). When you open the template from your Favourites view, it opens with the options you saved.

Basic Options

Location: Basic Options tab

The options available on the Basic Options tab depend on the task settings. They may include, for example, the options listed in this section.

In the Web Client, there are no separate tabs for basic and advanced options. All available options are listed under the task heading.

Different settings may have been defined in the template definition file. In this case, the definition file settings override the options you select in the user interface. In problem situations, contact your administrative user.

Option	Description
Data type	Select the data type for which you want to report data from. The data types to which you have user rights are available in the list. This option applies when the template contains the %DATA TYPE CODE% parameter as the value of the <dimensionudid> element in the data column settings. The unit tree is updated according to the data type connections. In other words, you can only select units that are connected to the selected data type.
Period	Select the period for which you want to report data from. The available periods depend on the task settings. If the content of the period list has not been defined in the task settings, all periods are included in the list.
Year	Select the year for which you want to report data from. The list contains all financial years included in the system. This option applies when the template contains the %YEAR CODE% parameter as the value of the <dimensionudid> element in the data column settings. The unit tree is updated according to the data type connections of the selected year. In other words, you can only select units that are connected to the data type of the selected year.
Hide Zero Rows	If you select this option, the account rows that contain no data in any data column (or the value in the cell is 0) are hidden on the template. The Hide zero rows option never hides rows where all definition columns (account number, unit ID, etc.) have no data. Subtotals in the retrievefromdata type templates are hidden if the value of all data columns is empty or zero (with this option, subtotals are not hidden in the predefined type templates).
Unit/Dimension	Select the dimension for which you want to report data from. The available dimensions depend on the task settings. If the dimension has already been selected, you can proceed directly to selecting units.To select a dimension, select the check box at the beginning of the dimension row. Select the hierarchy according to which the available units are shown. The list contains all hierarchies defined for the selected dimension. If the content of the account hierarchies list has not been specified in the task settings, all account hierarchies are selectable. The administrator may also have connected a specific hierarchy or hierarchies to the task selections. For the selected dimensions, select the units for which you want to report data from. Units are selected for each dimension separately. The dimension unit tree contains all units of the selected dimension for which you have 'Read and write' or 'Read' rights in the selected year. Depending on the task settings, it may be possible to select several units (by holding down the CTRL key). This setting is dimension-specific. Reporting for dimensions that you do not select depends on your user rights: If you have rights to the top-level unit of the dimension, reporting will be done from the top-level. If you do not have rights to the top-level unit of the dimension, reporting will be done from the BWNonAllocatedItem unit. You can also specifically select the BWNonAllocatedItem unit (BWNonAllocatedItem is the default name of the unit, but may be different in your system). To search for units, type a search term in the search field above the unit tree and click the magnifying glass icon or the Enter key. To move to the next match, click the Enter key again.
Accounts	Whether the accounts are available for selection depends on the task settings. To select accounts, select the check box at the beginning of the dimension row. If the content of the account hierarchies list has not been specified in the task settings, all account hierarchies are selectable. Select the accounts into which you want to enter data. The account tree contains all accounts connected to the selected data type. If you change the selected data type and the selected accounts are not attached to the newly selected data type, the account selection is set to the first summary level account available on the tree. Depending on the task settings, it may be possible to select several accounts (by holding down the CTRL key). To search for accounts, type a search term in the search field above the unit tree and click the magnifying glass icon or the Enter key. To move to the next match, click the Enter key again.

Advanced Options

Location: Advanced Options tab

The Advanced Options tab is available if it has been defined in the task's settings. The options available on the tab also depend on the task settings. They may include the options listed in this section.

In the Web Client, there are no separate tabs for basic and advanced options. All available options are listed under the task heading.

Option	Description
Documents	You can filter the data by documents, either by defining the maximum and minimum document number limits or selecting document series. Only the data that has been entered to the selected documents/document series is then shown on the template. By default, all document series are included in the template. Document range: If you select this option, select the lower and upper limits of the range from the drop-down lists. Document series: If you select this option, select the document series from the list. You can use Ctrl+a to select all available series, or Ctrl+u to unselect all the series. The document and document series options apply when the template definition file does not contain document series definitions for the data columns. Document series selection applies also, when data column definitions contain the %DOCUMENT ADVANCED CODES% parameter.
Type of Data	Periodical: If you select this option, the data in the template is change during the period. Cumulative: If you select this option, the data is shown in the template as cumulative figures.
Other Options	All entries allocated to unit This check box is available if defined in the task settings. Depending on the settings, you may be able to change the default selection. If the option is selected, all entries allocated to the selected organization unit are displayed regardless of the counter unit of the entry. You must have at least 'read' rights to the unit. If the option is not selected and the selected unit is a consolidation unit, only entries such as internal transactions and other eliminations between sub-units of the selected consolidation unit are displayed (that is, the entries with units from other consolidation levels are not displayed). If the option is not selected and the selected unit is an input unit, the entries are not displayed. Note that when the template includes counter unit as a definition column, this option must be selected to see entries where the counter unit is different than the unit. In these cases, the template settings define which counter units are shown. See below for examples on using the All entries allocated to unit option.
Other Options	All internal transactions for unit This check box is available if defined in the task settings. Depending on the settings, you may be able to change the default selection. If the option is selected, all internal transactions in which the selected unit or any of its sub-units is used as the unit or the counter unit are displayed. You must have at least 'read' rights to either the unit or the counter unit. If the option is not selected, internal transactions of type 2 document series are displayed according to the selection of the All entries allocated to unit option (see above). This option has effect only on type 2 document series entries, DIM00 and report data columns. If data is retrieved from other document series, the All internal transactions for unit option is ignored. In other words, for these series the data is displayed the same way as if the option was not selected. When All internal transactions for unit is selected, the All entries allocated to unit option is irrelevant for type 2 document series. See below for examples on using the All internal transactions for unit option.
Scaling factor	If you want to use scaling, select the check box and type a scaling factor in the Scaling factor field. For example, a scaling factor of 1000 will display the figures as thousands. This option applies when the template contains the %USERSCALINGFACTOR% parameter as the value of the <scaling> element in the data column settings.
Currency	Select the currency in which you want the data to be shown in the template. The available options are: Group currency Unit currency (currency of the unit selected in Basic Options) All currencies available in the system This option applies when the template contains the %USERCURRENCY% parameter as the value of the <currency> element in the basic area or data column settings. Input and reporting is possible in a third currency (some other currency than group currency or the currency of the unit(s) defined for the template) when the <currency> element is defined in the basic area or data column settings of the template. If the definition is missing, no conversion is done even if you select a third currency from the list. The data is converted into the selected currency using the currency rates defined for the currency table of the data type used for the data. If a currency rate is missing from one or more periods, a warning message is shown. To view the message, click the Warnings link under the ribbon. Currency conversion is made when data is saved to or retrieved from the database to a report or input template. The entered data is saved into the database both in the unit and group currency.
Show all drill-down input rows	Select the Show all drill-down input rows option if you want all input-level drill-down rows to be shown by default when opening the template. If this option is not selected, you need to click drill-down rows open one by one. Note that sum account levels are not opened automatically, and this option does not have an effect on other drill-down functions (viewing sub-account data and drilling down to figures on reports).

Examples: All entries allocated to unit and All internal transactions for unit options

Basic Report

Unit hierarchy:

A1

A2

B1

B2

Entry rows for type 2 document series:

A1-A2
A2-A1
A1-B1
B1-A1
A2-B1
B1-A2

Example 1: You have 'read' rights to units A, A1, and A2. The selected unit is A, and the All entries allocated to unit option is not selected (All internal transactions for unit is not selected).

A1-A2
A2-A1

Example 2: You have 'read' rights to units A, A1, and B1. The selected unit is A, and the All entries allocated to unit option is selected (All internal transactions for unit is not selected). The following entries are displayed:

A1-A2
A1-B1

Example 3: You have 'read' rights to units A, A1, and B1. The selected unit is A, and the All internal transactions for unit option is selected (All entries allocated to unit is not relevant). The following entries are displayed:

A1-A2
A2-A1
A1-B1
B1-A1

Unit rights are checked only from the selected unit or its sub-units. Therefore, you would not have access to rows A2-B1 and B1-A2 even though you had 'read' rights to B1.

Generated Report

Unit hierarchy:

A1

A2

A3

B1

B2

Entry rows for type 2 document series:

A1-A2
A2-A1
A1-A3
B1-A1

When the report is generated from level A, entries are generated as follows when All internal transactions for unit is selected (All entries allocated to unit is not relevant):

For A1:

A1-A2
A1-A3
B1-A1

For A2:

A2-A1

In drill down, the entries are generated as follows:

For A1:

A1-A2
A2-A1
A1-A3
B1-A1

For A2:

A1-A2
A2-A1

Filtering Data by Unit Extra Fields

Location: Extra Fields: <dimension name> tab

Data can be filtered to templates by unit extra field values. If this function is enabled in the template, there are separate tabs for each dimension. If the dimension is not attached to the selected data type, the selections on the tab are not available.

There may be default selections for the filtering options. Depending on the task settings, you may be able to change the default options. In case of problems, contact your administrator.

To use extra fields for filtering data:

Select the operator from the drop-down list. The options include some of the following depending on the type of the extra field:
- Equal to: Retrieves the units whose extra field value is exactly the same as the comparison value.
- Not equal to: Retrieves the units whose extra field value is something else than the comparison value, including units with no value for the extra field.
- Less than (numeric fields): Retrieves the units whose extra field value is smaller than the comparison value.
- Greater than (numeric fields): Retrieves the units whose extra field value is bigger than the comparison value.
- Equal to or less than (numeric fields): Retrieves the units whose extra field value is exactly the same or smaller than the comparison value.
- Equal to or greater than (numeric fields): Retrieves the units whose extra field value is exactly the same or bigger than the comparison value.
- Between (numeric fields): Retrieves the units whose extra field value is included in the comparison value range, including also the defined values.
- Not between (numeric fields): Retrieves the units whose extra field value is not included in the comparison value range, excluding also the defined values and including units with no value for the extra field.
- Contains (text fields): Retrieves the units whose extra field value contains the comparison value.
- In (text fields): Retrieves the units whose extra field value is one of the comparison values.
- Not in (text fields): Retrieves the units whose extra field value is none of the comparison values, including units with no value for the extra field.
For drop-down and check box type extra fields: Click and select the options you want to use. Note that if at least one of the selected values has been selected for a unit in Unit Management, the unit is included in the template. It is not possible to filter units by the exact combination of values selected in the template extra field options.
For text type extra fields: You can type the values directly in the field on the Extra Fields tab or click and type a value to the text field in the dialogue box. To add more values, click Add.

If you want to retrieve the units that have an empty value for a specific extra field, select an operator and leave the value field empty. If you do not select an operator, all units are retrieved regardless of their extra field value.

You cannot delete the last free text field of text type extra fields in the dialogue box. If you want to delete all values, delete the value from the field in the dialogue box or select and delete the values in the field on the Extra Fields tab.

Warnings

In the cases listed in the following, warnings are shown when an input template is opened:

The input template definition file contains invalid dimension definitions. It is not possible to report or enter data for a data type that uses units of a dimension which is not connected to the selected data type.
You do not have 'read and write' rights for a data type included in the template.
- If you do not have 'read and write' rights for a data type, you cannot enter data for it. In this case, the cells in question will be locked.
- If you have 'read' rights for a data type, you can view the data entered to it.
- If you have no rights for a data type, the data is not shown.
You do not have the 'read and write' rights for the unit.
Unit defined in the template or selected in Basic Options is not in use in the year defined in the template.
Data is locked for the combination of data type, year, period and user role. Note that data is not saved for locked periods.
Currency rate is missing from one or more periods.
The template contains units that are not connected to the defined/selected data type in the defined/selected year.
The template contains a consolidation unit which cannot be used as an input unit (if unit and data type connections would otherwise allow it to be used as an input unit).

Note that warnings are shown only for input columns, not for reporting columns.

For more information about the warnings, click the Warnings link under the ribbon of the input template window.

Note that also accounts are connected to data types which means that data can only be entered to accounts that are connected to the selected data type. Those accounts that are not connected to the data type are locked.

Data cannot be saved to a calculated account. The calculated values are shown in normal input cells in 'predefined' type input templates, in 'retrieve from data' type templates calculated values are shown if the 'inputtype' value has been defined for a definition column in the template definitions, or if a data column has the value 'calculated' for 'inputtype'.

Updating Report Options

Different settings may have been defined in the report definition file. In this case, the definition file settings override the options you select. In problem situations, contact your administrative user.

Updating options in report window

In the Clausion Desktop Client:

To update the selected options (for example, data type, year, dimensions, hide zero rows) in report, select new options and click Refresh. If you want to add new options to the report, update the options in the main application window (see the following section).

Searching for a dimension

In the Clausion Desktop Client's report view there is now a possibility to search for a unit in the dimension drop-down list. The search works on typing a character or string and selecting manually with a mouse-click or by using the Up/Down arrow keys.

The Enter key for accepting the tapped in unit code does not select the unit.

If the user refreshes the report without selecting a unit from the drop-down list, the data retrieve is executed based on the unit that was previously selected, but the selection field shows another value. No error message is displayed. After this the list is empty. By typing a character, units containing the typed characters are displayed. So, the whole list is available.

After selecting a unit with the search functionality, and when opening the drop-down list the next time, the list gets populated with units according to the previous search. By typing a character, units containing the typed characters are displayed. So, the whole list is available.

In the Clausion Web Client:

Click Selections on the Home tab to view the current options, make your new selections, and click OK to update the task.

Updating options in main window (Clausion Desktop Client)

When you have several reports open at the same time, you have two options to open the settings you want to edit:
- In the report window, click Return to Options. The Basic Options view of report is shown in the main application window.
- In the main application window, select the report from the drop-down list in the upper part of the window.
Select new options.
Click Update Open Template.