We face many challenges in our BI projects in terms of creation of Analysis Authorizations in a bulk. Users always expect outstanding security of our BI reports. No matter what ever we do in the back end (Modeling and Query Designer). I am going to share very important tips & techniques which I have learned through out my experience which consists of some standard thumb rules too.
This blog is going to explain you about "Creation of bulk analysis authorizations". I am not going to talk about standard Steps to be carried out. For example we need to create Profit center wise analysis authorizations and respective roles wherein the no.of analysis authorizations will at around 200 to 500. In such situation i created a program in that we need to just upload the profit center numbers in CSV format.
The program will create the required Technical names of analysis authorization along with customized descriptions (whatever we want) within a fraction of second it will create all Analysis Auth. objects.
Please go through the screenshots mentioned below, as it contains how we create one Analysis authorization in our system.
1 :- Enter the Tcode 'RSECADMIN' and later click on "Ind. Maint.".
2 :- Specify the Tech.Name of AA and click on "Create".
3 :- Specify the Short, Medium and Long Text and then click on infoprovider icon and select your info objects. For example i want to create profit center wise AA objects including Cost center and Controlling Area.
4:- Click on Profit Center intervals and maintain the value of Profit center.
5:- Maintain the info provider values as mentioned below.
6:- Save and activate.
The above six steps will take time at least a minute time to create one analysis authorization. So for this i explored a lot and i found three tables are updated when we are creating one AA object. RSECVAL, RSECBIAU, RSECTXT.
I just want to share this program to all of you, so that it can helps us to create bulk AA objects.
NOTE:- Please be take care of this program before running. If 'text.csv' file is not there in our C:\ then it will not do any harm to our AA objects. As i did not add any checks before updating these values.
It is always better to keep an eye on above points while developing / creating AA objects. This blog will help us to skip our 3 man days work and will give the output within seconds. I have tried my level best to make it very clear to achieve this peculiar requirement. I am sure this is going to help us, as many clients does this kind of analysis authorizations.