RPAS Configuration Tools (Part 3) – Hierarchies definitions

After a little vacation, we back our activities! In this post, we will explain some settings of the hierarchies within the ConfigTools and some care that is needed during this step.

As we explained in RPAS Configuration Tools (Part 2) – Details about project components, when we created the project, the tool creates 5 (five) default hierarchies, they are: CLND (calendar/time), LOC (location), PROD (product), ADMU (user administration) and LNGS (languages).

ConfigTools – Hierarchies details

ConfigTools – Hierarchies details

Continue reading

Multi-Dimensional Database Concepts (Part 1)

One of the great difficulties in working with the RPAS is to understand how  multidimensional database works, operates and manipulate their data. For thus, it is very important to understanding some concepts related to help during various activities related of database.

The model most well known and used is the relational database model. The relational model uses a two-dimensional structure of rows and columns to store data; these structures are connected or related by common fundamental values​​, often defined as keys.  Continue reading