You built your workbook with all metrics and calculations, but now the end user makes the final analysis and realize you forgot a metric! (Now you’re pissed!) According to the user, this new metric has to bring the parental participation of a measure to the total of the company or at the highest level of the hierarchy.
So now you need go back to the whiteboard to analyze what you need to change to meet this need! Perhaps you may not know, but exist a feature in RPAS can solve your problem without many impacts in your configuration.
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 →