Skip to Content
author's profile photo Former Member
Former Member

Authorization checks for filter values

Hi,

I'd need to apply authorization checks to filter values in web reporting. The authorizations should be limited with an attribute of the characteristic, not the characteristic itself.

A practical example:

There are two companies A and B. The companies are not allowed to see any data from each other.

There is a report that displays sales orders. It is used by both companies. The selection of sales orders is limited with the characteristic 'distribution channel', so the initial display is fine.

customer sales order

cust1 so1

cust1 so2

cust2 so3

cust2 so4

...

Users should be able to filter the sales orders by customer. As filter values, the users should only be able to see and select customers from their own company.

Access to customers should be limited with an attribute of the customer, e.g. company code, because it would be impossible to maintain authorization profiles that contain lists of customers.

However, it seems that BEx and web reports don't care about the authorization restrictions applied to the company code. When a user from company A clicks on the characteristic 'customer' and selects filter values (e.g. with F4), he can choose from all customers.

So, how could we apply authorization checks to filter values?

Message was edited by: Arto Pihlaja

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Feb 07, 2005 at 03:44 PM

    I'd try the following one:

    Define company code from 0CUSTOMER as navigational attribute and include it in your cube. Define a variable on the navigational attribute and fill it from authorizations. Drag the variable into the filter.

    Best regards

    Dirk

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.