Skip to Content
0
Former Member
Feb 08, 2007 at 04:08 PM

Question about analysis authorization

21 Views

Hi together,

I hope you can help me with the following issue.

I need to setup a restriction concept that makes it possible to give a user the authorization to see specific projects (0PROJECT) regardless of the profit center the project belongs to. Over that he should be able to see all projects that belong to a specific profit center

e.g.:

Line  PROJECT     PROFIT_CTR    VALUE 
1     P-A         PC-01        100
2     P-A         PC-02        200
3     P-A         PC-03        50
4     P-B         PC-01        70
5     P-C         PC-01        80
6     P-D         PC-02        30

So a user might be authorized for Project P-A. That would mean he could see lines 1, 2 and 3.

Over that he should get the authorization for Profit Center PC-01.

This would include lines 1,4 and 5. So in total he should be able to see 1,2,3,4 and 5 but not 6

When I setup 2 authorizations like that

1.

PROFIT_CTR PC-01

PROJECT *

and

2.

PROFIT_CTR *

PROJECT P-A

The user is allowed to see everything

When I set it up like that

1.

PROFIT_CTR PC-01

and

2.

PROJECT P-A

the user sees only row number 1

and this setup

1.

PROFIT_CTR PC-01

PROJECT :

and

2.

PROFIT_CTR :

PROJECT P-A

does not help because I only could get a query like this

Line  PROFIT_CTR    VALUE 
1     PC-01        100
4     PC-01        70
5     PC-01        80

or like this

Line  PROJECT     VALUE 
1     P-A         100
2     P-A         200
3     P-A         50

Hope someone might help me with this issue

best regards

Stefan