Many approaches have been proposed to pre-compute data cubes in order efficiently respond OLAP queries warehouses. However, few solutions integrating all of the possible outcomes, and it is this idea that leads integration hierarchical dimensions into these responses. To meet need, we propose, paper, a complete redefinition framework formal definition traditional database analysis through prism...