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

Modules:Dimensional Trial Balance

Contents

Multi-Dimensional Trial Balance

This module provides the Window and configuration required to run the Multi-Dimensional Trial Balance Report


Introduction

Multi-Dimensional Trial Balance Report is an enhanced version of the basic Trial Balance 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 Trial Balance.

DTBIntroduction.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 Trial Balance Report and install it. The system must be rebuilt after the installation.

DTBInstallation.png

Configuration

Correctly configuring this module requires to follow two steps:

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 Financial Multi-Dimensional Reports must be flagged as in development.

DTBConfiguration1.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

Schedule background Process

Schedule background Process for caching the 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.

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 Trial Balance the report is launched.

DTBParameters.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 Trial Balance 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.

DTBOutput.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_Trial_Balance"

This page has been accessed 5,861 times. This page was last modified on 30 January 2014, at 16:10. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.