Modules:FinancialDimensionalReports

Contents 1 Multi-Dimensional Financial Reports Infrastructure 1.1 Introduction 1.2 Setup 1.2.1 Requirements 1.2.2 Installation 1.2.3 Configuration 1.2.3.1 Generate Cubes 1.3 Tools 1.3.1 Utils 1.3.2 Translate Accounts 1.3.3 Generate Financial Cubes 1.3.4 Extend Dimensions

Multi-Dimensional Financial Reports Infrastructure

This module provides a set of tools that are used by other Multi-Dimensional Financial Reports such as the Multi-Dimensional Trial Balance and the Multi-Dimensional Profit And Loss. Also contains the Cube Definition Template for the Financial Cubes.

• License: Commercial
• Category: Module

Introduction

This Module acts as a bridge between Analytics and other Multi-Dimensional Financial Reports. It contains several common tools and utilities that can be used by other Multi-Dimensional Financial Reports, but does not provide any report by itself.

It does contain though the Cube Definition Template for the Financial Cubes.

Setup

Requirements

The Openbravo instance must be in MP25.1 or in a later one.

Installation

This Module is automatically installed when installing other Multi-Dimensional Financial Reports.

It can be installed without them though.

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 Financial Reports Infrastructure and install it. The system must be rebuilt after the installation.

Configuration

This Module does not need configuration. But the Financial Cubes based on the Template provided by the Module can be generated.

Generate Cubes

As System Administrator access the Window Cube Definition. There will be a record named FDR - Financial Dimensional Cubes. Click on it and click on the button Generate Cubes. The Module Multi-Dimensional Financial Reports Infrastructure must be flagged as in development.

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.

Tools

Utils

There is a Java class in this Module, named DimensionalReportsUtils, which contains several java methods that can be used when building a Dimensional Report, such as getCubeReportDimensionElements, or getDimensionName.

Translate Accounts

There is a Java class in this Module, named initializeTranslateTable, that is used by other Multi-Dimensional Financial Reports. This class is used to solve complex situations in the Account Tree, such as Operands, when building the reports such as the Profit And Loss.

Generate Financial Cubes

As explained above, this Module provides a Cube Definition Template for the Financial Cubes.

It also provides a Java class that extends the Process of generation of Cubes, as it is explained in the Analytics Documentation.

The peculiarity of this implementation is that it generates a Cube for each Accounting Schema the Client has, and replaces the parameter @c_acctschema_id@ with the actual Accounting Schema Id.

This implementation can also be extended, an example of it can be found in the Multi-Dimensional Profit And Loss Module.

Extend Dimensions

It is possible to extend the list of Dimensions shown in the Multi-Dimensional Reports by extending the Java class FinancialDimensionsHook and implementing the required methods.