Hello all,
I'll elucidate the analytic privileges in this documentation by creating a graphical view(Calculation view).
let us start...
First, what is Analytic privilege?
Analytic Privileges:
Analytic privileges grant different users access to different portions of data in the same view based on their business role. Within the definition of an analytic privilege, the conditions that control which data users see are either contained in an XML document or defined using SQL.
In this document, I'm not going to use SQL statements. So it's the XML-based Analytic privilege.
Note: Analytic Privileges can be used only activated once. If you need to change the Analytic Privilege after it has been successfully activated, you will have to delete it and re-create it from scratch.
In the following we are going to grant Analytic Privileges to user K2885 which will finally allow reporting off the Analytic and Calculation Views. We are restricting access to only Company Code ‘1000’.
Procedure:
1. Create a Calculation view under the “Material” package.
- Right Click on Calculation View > New
Figure1
2. Enter “ZCV_MARA” for the name of the view
- Select EKKO as a table and choose some field.
- Because it's a Calculation View, any measure field is mandatory.
- In this, I'm using Classic Analytic Privilege.
3. Save and Activate the Analytical View.
Figure2
4. Create an Analytic Privilege under the same package “Material”
- Right Click on Analytic Privilege > New
Figure 3
5. Enter name ZAN_EKKO_1000
- Enter a description
- Click “Next”
Figure 4
6. Select the ZCV_MARA Views
7. Implementing the privilege is now done in three steps:
1) Select further views for which this privilege should be valid (optional).
2) Select the validity from and to date.
3) Select attributes on which a restriction shall be defined.
4) Define value restrictions for the attributes selected in 3.
Figure 5
8. Add the field “BUKRS” to the list of “Associated Attributes Restrictions”.
- Click the corresponding “Add” button
- Select field “BUKRS” from the presented field list
- Click “OK”.
Figure 6
9. Define the value restriction for field “BUKRS”
- Click the “Add” button for “Assign Restrictions” (this increases the counter for the number of restrictions for BUKRS)
- Click into the “Value” field in “Assign Restrictions”. Click the “…”-icon.
- In the search window, search for Company Code 1000
- Select the Company Code from the search list
- Click OK
Figure 7
10. Save and Activate Analytic Privilege.
That's all guys, we have successfully completed an analytic privilege.
Assign Analytic Privilege ZAN_EKKO_1000 to user K2885.
11. Open the User Editor for user USER01 under Security > Users
- In that Editor, switch to tab “Analytic Privileges”
Figure 8
12. Click the green “+”-icon
- From the list of “Matching items”, select privilege “Material/ZAN_EKKO_1000”
- Click “OK”
Figure 9
Regards,
Akash Kannan K
Reference:
Analytic Privilege