Obtaining secure code in SQL Server Analysis Services by using MDA and QVT

Data Warehouses manage historical information for the decision making process that could be found out by unauthorized users when security constraints are not established. Therefore, it is very important for OLAP tools to consider the security rules defined at early stages of the development lifecycle. Following the MDA approach we have created an architecture for developing secure Data Warehouses and in this paper we complete this architecture obtaining secure multidimensional code in SQL Server Analysis Services from our secure multidimensional conceptual model (SECDW) by using QVT transformations. We focus on automatically obtain code for the security constraints defined at upper abstraction levels.