Modules:Dimensional Profit And Loss
Contents |
Multi-Dimensional Profit And Loss
This module provides the Window and configuration required to run the Multi-Dimensional Profit And Loss Report.
- License: Commercial
- Category: Module
Introduction
Multi-Dimensional Profit And Loss Report is an enhanced version of the basic Profit And Loss Report.
This report has been redefined to make use of the features provided by the new Integrated Business Analytics module, such as OLAP Cubes.
The result is a report that provides a solution for analytical analysis over the Profit And Loss.
- Example:
Setup
Requirements
The Openbravo instance must be in MP25.1 or in a later one.
Installation
As System Administrator access the Window General Setup || Application || Module Management. There, it is possible to install new modules by clicking on Add Modules.
Search for this module, named Multi-Dimensional Profit And Loss Report and install it. The system must be rebuilt after the installation.
Configuration
Correctly configuring this module requires to follow three steps:
- Configure Profit And Loss Accounts.
- Generate Cubes.
- Schedule background Process for inserting data into Multi-Dimensional Profit And Loss Table.
- Schedule background Process for caching queries.
Generate Cubes
As System Administrator access the Window Cube Definition. There will be a record named DPL - P&L Template. Click on it and click on the button Generate Cubes.
In the pop up, select the Clients for which the Cubes are going to be generated.
If there exists already a Cube generated for a particular Client, it will not be generated again by default. In order to do so, the Delete Previous Cubes check must be checked.
Configure Profit And Loss Accounts
As Client Admin Role go to Cube Definition Window.
- Select the Cube that has been generated previously. A Cube is generated for each Accounting Schema, and each for each Cube the Profit And Loss Accounts must be configured.
- Move to the Cube Reports Tab and select the record with Process Definition: Multi-Dimensional Profit And Loss Process.
- Move to the Cube Reports Dimension and select the record with Obanaly_Cube_Dimension_ID: account -.
- Move to the Cube Report Dimension Element.
In the Tab below, the Profit And Loss Accounts must be defined. It is necessary to define which Accounts are going to be shown, including or not their children. Also it is possible to exclude accounts to be shown. For example, select an account to show with it's children, and then exclude one of the children accounts.
More information about how to do it can be found in the Analytics Documentation
Schedule background process for inserting data into Multi-Dimensional Profit And Loss Table
Before being able to launch the Multi-Dimensional Profit and Loss Report, it is necessary to insert data into a specific table.
This is due to the fact that this report does not retrieve data from the FactAcct, but uses another table instead that needs to be filled. This in done in order to improve performance, in this other table only the information from the FactAcct that is relevant for the report is stored.
The insertion of the data in this table is done by a background process. It is necessary that this process is scheduled regularly (each day for example), for keeping the information up to date.
Keep in mind that this process is very demanding. It can take a considerable amount of time to finish in an instance with lots of records in the FactAcct, that is why is advised to run it at a moment when the activity is minimum, for example at night.
For scheduling the background Process
As Client Administrator access the Window Process Request and create a new record for the Client and the Process Generate Profit And Loss Fact Acct.
The recommended parameters for configuring the background Process are:
- Organization: *
- Timing: Schedule
- Frequency: Daily
- Daily Option: Every n days
- Daily Interval: 1
- Start Date: At some time when the activity is minimum, for example at night.
As a tip, for being able to see the report without waiting for the background Process to be scheduled the first time, it can be launched right away by setting the Timing as Immediate.
Schedule background Process for caching queries
Schedule background Process for caching queries
This step is not required, but recommended, in order to greatly improve the performance of the Report.
By scheduling this background Process, the application will learn how the Cubes are used. Meaning that the application will learn which queries are fired more often, and which ones requires more time to load. With this information, the Process will pre-load the results of this queries in the cache, so they are stored before the user asks for them.
The result is that the user will experience a significant reduction of loading times for the queries that are more often used. For example, a query that might take three minutes to load the first time, it will take around a second to load the next one.
Keep in mind that this process can be very demanding. It can several minutes to finish, that is why is advised to run it at a moment when the activity is minimum, for example at night.
For scheduling the background Process
As Client Administrator access the Window Process Request and create a new record for the Client and the Process Mondrian Cache Preload. The recommended parameters for configuring the background Process are:
- Organization: *
- Timing: Schedule
- Frequency: Daily
- Daily Option: Every n days
- Daily Interval: 1
- Start Date: At some time when the activity is minimum, for example at night.
User Guide
Parameters Window
Through the Window Financial Management || Business Intelligence || Multi-Dimensional Profit And Loss the report is launched.
The parameters to configure before launching the report are:
- Organization (Mandatory).
- General Ledger (Mandatory).
- Name For Saved View. It is possible to save the output of the Report by setting a name in this field. By doing so, other users can access the result of the Report without setting the Parameters again. This feature is more extensively explained in the Analytics Documentation
Date Filters
- Year (Mandatory).
- Period From and Period To. The year can be filtered to show only information between two different Periods.
- Use Fiscal Calendar. By default the Multi-Dimensional Profit And Loss uses the Natural Calendar. If this check-box is checked, the Fiscal Calendar will be used instead. It is advised not to use the Natural Calendar if it does not match the Fiscal Calendar.
- Reference Year (Mandatory).
- Reference Period From and Reference Period To. This fields are used to compare the results obtained for the selected Year against the selected Reference Year.
Dimensional Analysis
This section of the Parameters Window is used to configure the dimensional analysis for the report. It consists in three different columns, Dimensions, Column and Row.
In the Dimensions Column are contained all the available Dimensions for dimensional analysis.
Each dimension can be placed in either of the other two columns. By doing so, the report will split the data using that dimension, and placing it in the columns or the rows of the report.
Dimensional Filters
This fields are used to filter the results of the report. All of the fields support multiple selection.
Multi-Dimensional Profit And Loss Output
The output of this report is generated using the analysis suite Saiku. More information can be found in the documentation of Analytics module and in the documentation for Saiku. In this document only a couple of basic features are going to be explained.
Tool Bar
- Clicking on the first icon from the left allows to show empty cells.
- Clicking on the second icon from the left allows to swap the axis, the dimensions on the rows will be shown in the columns and the dimensions on the columns will be shown on the rows.
Options when clicking in a dimension in rows or columns
A pop up is shown with the options:
- Keep only. Keeps the selected member of the dimension. For example, if there are two years in the header, by clicking over one of them and then selecting keep only, only that year will be shown.
- Show Children. Shows the children of the selected member. For example, if a year is shown, by clicking on it and selecting Show Children, the Quarters will be shown.
Right hand side options
Some options to show graphics to represent the information shown in the table.
Limitations
As of now, it is not supported the definition of an Account with Show Value Condition as positive only or negative only.
The results shown in the report always assume that all the Accounts are defined with Show Value Condition as Algebraic.
Therefore wrong results due to this fact are to be expected.