How to implement multidimensional security into OLAP tools

Data Warehouses (DWs) manage historical information for the decision-making process and for enterprises. Online Analytical Processing Applications (OLAP) tools are the most used tools for implementing and consulting DWs and it is necessary to define security measures to avoid the accessing of unauthorised information by users by executing queries. It is vitally important to consider security requirements from the earliest stages of the development process. We have created a Model-Driven Architecture (MDA) to develop a secure DW and in this paper, we propose how to implement the security measures that are defined at upper abstraction levels using our approach to SQL Server Analysis Services (SSAS).