Using BRF+ DB lookup to create complex msmp rules
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
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).
Hi Harinam,
Please visit http://scn.sap.com/thread/3360665 for solution.
Regards.
Shahid.
Its great today i tried it, for initiator with different attribute, amazing
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
Hi Amanjit,
Thank you very much for posting this document, This is indeed the one document I have been looking for.
Ameet
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
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
Thanks,
Sabrina
Hi,
I am also facing the same issue as Sabrina.
Could anyone please help us.
Regards
Sabrina, did you have luck finding a solution?
Tony