Flat File Profiles vs Auth.Analysis : limited flexibility

19 Views

Hi,

How can I combine values of different characteristics - that belong together from a auhtorization point of view - into one profile?

The subject of this post may not be very clear, but let me explain what I need ...

Suppose I have a user that may only display data in MultiProvider 'MP1', for country 'BE' and company code '1000'.

That same user may also plan for country 'BE', but only for company code '2000' in MultiProvider 'MP2'.

You could maintain this manually by having 2 analysis authorizations:

analysis 1:

0TCAACTVT EQ '03'

0TCAIPROV EQ 'MP1'

0COUNTRY EQ 'BE'

0COMP_CODE EQ '1000'

analysis 2:

0TCAACTVT EQ '03' '02'

0TCAIPROV EQ 'MP2'

0COUNTRY EQ 'BE'

0COMP_CODE EQ '2000'

This is possible to achieve when you use t-code rsecadmin, maintain the values and assignments to users manually.

But we have about 100 users, all with different values they are authorized to (partially display, partially changeable). It goes without saying that this is not possible to maintain manually. Therefore we would like to continue the old way: loading authorizations to DSO's and generate the profiles afterwards.

How can I load files in the proper way that the right values are validated by the system together? This means that the system will allow the user to change/write data for country 'BE' and company code '2000', while the user will only be able to display data for 'BE' for other company codes (let's assume that the multiprovider does not matter in this case).

I hope someone can help here, it's been a brainteaser for a while now.

Please recall that it should be able to achieve this via flat file uploads!

Thanks in advance!

Kind regards,

Bart