In one embodiment the present invention includes a system for securing and authorizing access to multidimensional transactional data. The system includes online analytical processing (OLAP) system and a database system. The OLAP system accesses a selection of multidimensional transactional data from the database system according to a multidimensional request. The OLAP system aggregates the selection to form aggregated information. The OLAP system filters the selection according to the authorization for the user, to form a filtered selection. In this manner the user can see accurate aggregations yet not see unauthorized data.