Reporting Authorization in SAP BI 7.0

A BI Developer wants to limit access to a specific Data Set to the User when the user execute report the one has to put limit on the Data Access by the user which is called Reporting Authorization.

For example: A BI developer wants the user to only see the data belonging to her Controlling Area then the you can achieve this by Reporting Authorization

Implementation Steps:

Go to RSECADMIN – Authorizatino Tabl – Maintenance – Give name Hit Create
Install following Business Content:

0TCAACTVT – Activity-Read, Create,Change, Display etc.
0TCAIPROV – From which InfoProvider you want to select the data
0TCAVALID – How long this Authorization is Valid to the Particular User
0TCAKYFNM – limit the Key Figures value here

Make sure the Above  InfoProvider and all InforProvide that require Authorization as Authorizaton Relevent (0PROFIT_CTR)

Once you click Create..Start Inserting Above InfoObjects in the Characteristics/Dimension Column.
Double Click on each InfoObject and Limit the DataSet
Now Save.

Now you want to Assign this Authorization to User or a Role

In the RSECADMIN go to USER Tab – Assignments – Select User – Change – Insert the Above Create Authorizatin Object – Save.

Go to the Role Maintenance – and You can add this Authorization to a Specific Role

Key Points to remember at the time of Requirement Gathering for BPS Planning

1. What is the hierarchy of the people involved in the planning?
Based on this information, the creation of planning levels and the packages become easier.
Any vertical levels in the hierarchy will typically result in a planning level and any horizontal hierarchy can be converted into planning packages.
However, this is the simplest model I am talking about. The modelling procedure can be different also.

2. Who are the people involved in the planning and what is their area on which they work?
This explains the set of records, each of the person will be working on. Based on this detail, the selection criteria can be designed at the planning level and the planning package.

3. What are the different roles and responsibilities of each of the person?
This explains the authorizations that should be provided to the users.

4. What is the nature of work they do?
This information will be helpful to model different simulation models in BPS.