SAP BLOG Using SAP BW authorization relevant InfoObject in SAP Profitability and Performance Management reporting

SAP Blog

Kayıtlı Üye
Katılım
22 Ara 2017
Mesajlar
1,442
Tepki puanı
7
Puanları
6
SAP Profitability and Performance Management (PaPM) is a unique tool which allows user to maintain their data in easy and robust way. Nevertheless, question that might came in customer’s mind is:

“Which kind of authorizations can I use?”

This question can be answered depending on the angle you are looking at or standing on. For example which environment should be allowed for user to change, which action should user perform.

In the blog post written by Irina Ivanova, she described the authorization concept seen from SAP Profitability and Performance Management point of view. In addition to this wonderful and clear blog post, you can check additional information in the official help documentation for authorizations in SAP Help Portal.

Now if you tend to focus on authorization related to Dual Control, it is being described in detail by Ivann Oriondo in this blog post.

Since there are still questions about PaPM authorization related to infoobjects, I came up with idea to write an authorization related blog post focusing on : authorization relevant InfoObjects in PaPM and how user can deal with it.

In my next few paragraphs below, let me discuss and explain to you the infoObject’s analytical authorizations. Let’ begin.

What is analytical authorization? To be quick in explanation let’s have an example which will visualize this thing.

You are chief of controlling department of company X. This company is parent company of 3 other child companies: A, B and C. In every of those companies there is also chief of controlling department, but he/she is responsible only for his/hers company. You (as higher in company hierarchy) would like to see every information, e.g.: Net result from company X, however you don’t want them to see result of each other, so: controlling dept. of company A should only see data from company A and so on, so net result report should be shown for every chief as on screen below:

fig1-1.jpg


Fig. 1 Example of results, which will be displayed for different companies.​

So you need to create 4 reports for every company member, which will have to be restricted by Company code for every specific company? The answer is: There is a better solution: You can use Authorization relevant InfoObject and create only one report and SAP BW backend will restrict data according to your authorizations and everything can happen on one report only. In this blog I will show you how to achieve such thing and how to combine this feature with SAP Profitability and Performance Query function.

So we need to create company code characteristic for those purposes:

  1. Company code characteristic:

fig2.jpg


Fig. 2 Authorization-Relevant checkbox on HANA Studio creation view.​

With given master data:

fig3.jpg


Fig. 3 HANA Studio Master data maintenance screen.​

Now we can log into BW client and go to Transaction RSECADMIN.

fig4.jpg


Fig. 4 RSECADMIN screen in SAP GUI.​

Individual maintenance and create new authorization named CC_A:

fig5.jpg


Fig. 5 RSECADMIN: Maintaining authorization CC_A.​

Now you can press the button in green square like on screenshot above. It will fill table with 3 InfoObjects that are necessary for analytic authorization to work. Since those are in the table you can add this particular authorization relevant InfoObject – in our case YBW_COMP. Double click this InfoObject.

New screen will pop-up. Add new line like and edit row : I – for include. Then you can select list of single values to be included for analytical authorizations like on screenshot below:

fig6.jpg


Fig. 6 RSECADMIN: Maintaining authorization CC_A: Selecting single values.​

Or you can select specific range of given values:

fig7.jpg


Fig. 7 RSECADMIN: Maintaining authorization CC_A: Selecting range.​

The third and last option is to select contains pattern and it can look like this:

fig8.jpg


Fig. 8 RSECADMIN: Maintaining authorization CC_A: Selecting by pattern.​

For this particular scenario we will select it as equal to “CC_A”:

fig9.jpg


Fig. 9 RSECADMIN: Maintaining authorization CC_A – Saved and activated authorization.​

After that you can save and activate authorization object. Next you can make authorization object for companies B and C, and then one more: for all companies: CC_ALL

fig10.jpg


Fig. 10 RSECADMIN: Maintaining authorization CC_ALL.​

Next thing is to assign authorization object to particular user. In our case user DBW_ATH_PAPM. To do that go to T-code RSECADMIN and select User tab and individual assignment:

fig11.jpg


Fig. 11 RSECADMIN: Assign authorizations for user.​

And fill name of particular authorization and click “Insert”.

fig12.jpg


Fig. 12 RSECADMIN: Selecting authorizations for user.​

In this scenario I will add CC_A and CC_B authorizations to this user.

Second idea is to add those authorizations to specific role:

fig13A.jpg


Fig. 13A Applying authorizations for role.​

fig13B.jpg


Fig. 13B Applying authorizations for role.​

And if you do so, those values are applied to tab “Role Based”

fig14.jpg


Fig. 14 RSECADMIN authorizations for user – Role-Based tab.​

Now on SAP Profitability and Performance Management side lets create Model Table function that will contain this characteristic and key figure: Net result. Then fill table with data given below:

Company CodeNet result
CC_A1.500.000
CC_B2.000.000
CC_C2.500.000



And simple query function with this Model Table as an input and query source as Environment. Definition of query should look like this: Net result in columns and Company code in rows. Last step is to restrict Company code characteristic with authorization variable as given in screenshot below:

fig15.jpg


Fig. 15 SAP Profitability and Performance Management Query function definition.​

And activate the query.

As user with no restrictions defined and full authorization this is how result would look like:

fig16.jpg


Fig. 16 Query result visible for user with all authorizations.​

As you can see – all results are available. Now how this query will look from this specific user for whom we managed authorizations? Answer in screenshot below:

fig17.jpg


Fig. 17 Query result visible for user with restrictions via authorization objects.​

As you can clearly see analytic authorization works for SAP Profitability and Performance Management query function. It can be relevant when you would like to restrict the results of your calculations for specific user. I encourage you to switch those authorizations to the one created before. If you would like to know more about those kinds of privileges please stay tuned for another blog in which I will describe advanced things that you can do with SAP BW analytics privileges feature!

Okumaya devam et...
 
Üst