Clausion Dynamic Reporting for FPM is an additional module available for the Clausion Financial Performance Management environment. With Clausion Dynamic Reporting for FPM you can create dynamic reports and analyze any data available in the Clausion FPM environment using Dynamic Reporting (DR) -specific Excel formula functions that are connected to the Clausion Financial Performance Management database. The reported and analyzed data is customer-specifically adjustable. For example, when organization, accounting period, document series or account chart is modified in the application, the changed dimensions and IDs are dynamically usable in the reports defined in Clausion Dynamic Reporting for FPM.
The Clausion Dynamic Reporting for FPM functionality is available on a separate tab in the Excel ribbon.
Figure 104: Clausion DR in Excel ribbon
If the Clausion DR tab is not visible in your Excel workbook, contact your Clausion Financial Performance Management administrative user for information on the location of the installation package.
Installing Clausion Dynamic Reporting for FPM add-in
Double-click the setup.exe file and click Install. If there are problems with the Clausion Dynamic Reporting for FPM functionality, check from the Configuration drop-down list that the correct configuration is in use.
Using Clausion Dynamic Reporting for FPM
Note! If a user who has "read and write" rights to unit A has saved a DR Excel file and a user who does not have rights to the unit opens it, the user without the rights can see the data of unit A but cannot update it. When a user without the required rights tries to update and refresh the workbook, the data is replaced by 0 values. In addition, when the Automatic Calculation option is selected, the data is not shown if the user does not have the required rights.
Click •DRData: Retrieves data for the selected combination (period, year, unit (dim00dimxx), data type, periodic/cumulative, currency, document series, document number) from the Clausion FPM database. If something is incorrect in the entered argument values (for example, the value cannot be found from the database or you do not have sufficient rights to retrieve the data), the result of the function will be 0. •DRAccountName: Retrieves the name of an account from the Clausion FPM database. •DRAccountDCCode: Retrieves the debit/credit code of an account from the Clausion FPM database. The debit value is 1 and credit value -1. •DRDatatypeName: Retrieves the name of a valid data type from the Clausion FPM database. •DRCurrencyRate: Returns the currency rate used for converting currency amounts to or from the group currency when saving to and reporting from the Clausion FPM database. •DRUnitCurrency: Returns the currency code of a unit from the Clausion FPM database. •DRUnitName: Returns the unit name from the Clausion FPM database. More information about the functions and their arguments is shown in the Insert Function dialogue box. The following sections include lists of DR functions based on their arguments. Notes:
|
To make the example work in Excel, delete the apostrophe (') from the beginning of the cell. Note! Use correct separator for function arguments (',' or ';') =DRData("ACT";"10000;20000";"979989P";"2019";"12";TRUE;"EUR";"UNIT1") =DRAccountDCCode("994989P") =DRAccountName("994989P";"EN") =DRDatatypeName("ACT";"EN") =DRCurrencyRate("USD";"OPENING";"ACT";"2019";"0") =DRUnitCurrency("DIM00";"UNIT1";"2019") =DRAccountDCCode("979989P")*DRData("ACT";"10000;20000";"979989P";"2016";"12";TRUE;"EUR";"UNIT1") |
The |
You can select, whether you want the values of the formula(s) to be calculated every time you enter a DR formula, or if you want to do this manually. To have values of the formula(s) calculated automatically, select the Automatic Calculation check box. To calculate values manually: 1.Deselect the Automatic Calculation check box. 2.Select an option from the Refresh Mode drop-down list: •Workbook: All functions in the workbook are calculated. •Sheet: All functions on the sheet are calculated. •Selection: All functions in the selected range are calculated. Multiple ranges can be selected on one sheet. Note! This option only applies within the active sheet, not on multiple sheets. 3.Click When Automatic Calculation is selected, copy-pasting to several cells retrieves data to all included cells and also the formatting is copied. When Automatic Calculation is not selected, copy-pasting to several cells only copies the formula and the additional formatting. By default the Automatic Calculation check box is not selected. Data is not automatically retrieved from the database when the Excel workbook is opened. If local Excel settings are set to automatically update external links, the formula results saved previously are not shown when the file is opened (instead, the DR formula is shown as text). Note also that if the Calculation Options setting in Excel is Automatic and the Automatic Calculation option has been selected in DR, all reference values are updated even outside a selected Refresh Mode range when you click |
The Configuration drop-down list contains the available configurations. You can change your DR environment by selecting another configuration from the list. •If no configurations are found, check that the path to the configuration folder is valid, you have the required permissions to the folder, and a configuration file exists. •If there is an error reading a configuration, the XML structure of the configuration file may be invalid. •For further assistance, contact your administrator. |
Dynamic Reporting logging is not on by default. To start or stop logging, click The |
