6. The method of claim 1 , further comprising constructing the one or more security filters to include a reference to a second security filter.
1. A method of providing restricted access to data contained in a business intelligence system using a database and having an application with user input, the method comprising: defining one or more security roles; defining one or more security filters associated with one or more query subjects of a relational database of business intelligence information that are to be secured by restricting access to the one or more query subjects, each of the security filters providing a mapping between at least one of the one or more security roles and a filter expression, expressed in a structured query language, that grants access to a subset of rows in the one or more query subjects; selecting one or more user security roles from the one or more security roles and thereby selecting one or more user security filters from the one or more related security filters; accepting user input defining an original data access language statement, expressed in the structured query language, to determine information required to be selected from the one or more query subjects of the database; combining, by a computer, the one or more filter expressions of the one or more security filters with the original data access statement to produce a modified data access statement expressed in the structured query language, the modified data access statement limiting the requested information to the rows with access granted by the filter expressions mapped to the user security roles through the security filters; accessing, by the computer, the data stored within the database by interpreting the modified data access statement; and presenting business intelligence data accessed by the modified data access statement.