Skip to Content
0
Former Member
Nov 10, 2004 at 09:41 PM

Reporting authorizations with the : (summary) operator

23 Views

Help! We are implementing security on several dimensions of a cube. In order to properly summarize each of the dimensions (company code and profit center) each authorization includes the summary operator : for company code and profit center. This all works fine as long as we force users to use a variable with mandatory entry required but it is conceivable that a user will create a query on account with no company code or profit center display and will be able to see enterprise net income.

Wew know we can solve this with multicubes. With a multicube secured on profit center and another multicube secured on company code we wouldn't need the summary operator and users would be restricted to companies and profit centers that they were authorized to use.

But management is resisting the multicube approach thus the summary operators (:).

Does anyone have any suggestions?

1. can we force users to use a variable and set it as entry required?

2. can we force them to use an authorization variable in their queries?

3. any other good ideas?

Thanks

Corwin