Additional Blogs by SAP
cancel
Showing results for 
Search instead for 
Did you mean: 
Former Member

1.)  Some of the common attributes on which you will base your BRF msmp rule are alredy available in context( like priority,criticality      etc.) but there  are few other attributes which are not available in the context like role sensitivity etc. To create your rules based on these attributes you can create expression of type DB lookup and read these attributes realtime from database table. Following example will provide mode details of creating an initiator rule based on availablity of role owners

1.) 

1.)     

C     Create a new expression of type ‘DB Lookup’ in your existing initiator rule

1.)      Provide name and description to your DB lookup and fill in following details

2.)

3.)    

      Once DB lookup is created and activated. Open your decision table and click on ‘Table Settings’ button. In your table settings ‘Insert Column’ as shown below

4.)

4.)     Select the newely created DB Lookup as a new column

5.)      Now in your decision table you can have first row for roles without role owners and rest of the table can remain same as your existing rule

2

10 Comments
Former Member
0 Kudos

Amanjit,

Thank you for this blog post, much appreciated. I do believe that within GRC, a routing can be set up as default to cater for roles with no approvers. However, pertaining back to your comment on a recent discussion, I am interested to know how having 2 DBLOOKUP's (one for Manager and another for Role Owner) may look in the decision table to catch the scenario of where "Manager" = "Role Owner". This would be very useful in a small/medium sized business where the Manager is more than likely to be the Role/Risk owner. Such a solution would create efficiency in the approval process and avoid repeated approval by same person (but taking into consideration they do indeed have the 2 different responsibilities).

former_member193066
Active Contributor
0 Kudos

Its great today i tried it, for initiator with different attribute, amazing

Former Member
0 Kudos

Hi Harinam,

Please visit http://scn.sap.com/thread/3360665 for solution.

Regards.

Shahid.

Former Member
0 Kudos

Hi Amanjit,

Thank you very much for posting this document, This is indeed the one document I have been looking for.

Ameet

former_member204204
Active Participant
0 Kudos

Hi Amanjit,

Thanks for such a informative document.

I am looking for your guidance where I have created a agent using role attribute(Bus Proc & Comp Code). I am able to determine single approver(User id)  but not able to return multiple User id in same case. I tried using DBlookup but it is not working.

Please check the below link where i have posted my query

MSMP-PFCG Agent rule help required

It would be great if you could throw some light on this.

Your earliest reply will be highly appreciated.

Regards,

Neeraj Agarwal

Former Member
0 Kudos

Hi Amanjit,

thank your for this document! I also was looking for that. I am having just one problem: Can you advise me please how I can get the ROLE GUID from context? Here is my screehshot.

When I am looking unter "Select Context Parameter" I am not able to find this Role Guid....

Thanks in advance,

best regards

Sabrina

Former Member

Hi Prasant,

by  trying to implement this solution, I am facing one small issue: How can I get in the DB Lookup this ROLE GUID from context? I woul really appreciate your help! thanks,

regards

Sabrina


Former Member
0 Kudos

Hello all together, can someone Help me to get this ROLE GUID from context? Can opyu please have a look.  Am I on the right way?

Thanks,

Sabrina

Former Member
0 Kudos

Hi,

I am also facing the same issue as Sabrina.

Could anyone please help us.

Regards

0 Kudos

Sabrina, did you have luck finding a solution?

Tony