View source | Discuss this page | Page history | Printable version   

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.


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.

DPLIntroduction2.png

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.

DTBInstallation.png

Configuration

Correctly configuring this module requires to follow three steps:

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.

DPLConfiguration1.png

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.

DTBConfiguration2.png

Configure Profit And Loss Accounts

As Client Admin Role go to Cube Definition Window.

  1. 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.
  2. Move to the Cube Reports Tab and select the record with Process Definition: Multi-Dimensional Profit And Loss Process.
  3. Move to the Cube Reports Dimension and select the record with Obanaly_Cube_Dimension_ID: account -.
  4. 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

DPLConfiguration3.png

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:

DPLConfiguration2.png

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:

DTBConfiguration3.png

User Guide

Parameters Window

Through the Window Financial Management || Business Intelligence || Multi-Dimensional Profit And Loss the report is launched.

DPLParameters.png

The parameters to configure before launching the report are:

Date Filters
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.

DPLOutput.png

Tool Bar
Options when clicking in a dimension in rows or columns

A pop up is shown with the options:

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.

Retrieved from "http://wiki.openbravo.com/wiki/Modules:Dimensional_Profit_And_Loss"

This page has been accessed 8,639 times. This page was last modified on 10 June 2015, at 14:42. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.