One of the major changes we had RPAS 13.3 or later, was the introduction of the concept Cardinality and Re-Indexing Threshold. This concept was developed to solve big issues about space management and capacity of dimensions within the RPAS.
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).
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