Risk Violation Data Not found

[Former Member]

Dear Expert,

We are facing the problem where we are not getting data from ""Risk Violations by Process"

after compliting the batch risk analysis job successfully.

Thing is happening when we check Management Report View : See the following steps I have done properly :Select informer tab --> Management View --> Risk Violation

Month Year : 02/2009

System: ECQCLNT360

Analysis Type : Role

Clieck On Go

Got the result from "RISK VIOLATION BY PROCESS"

Z_Production Planning 22,339 16%

Z_Finance 4,493 3%

Z_Quality Management 39,988 28%

Z_Controlling 418 0%

Z_Project Systems 4,610 3%

Z_Order to Cash 12,570 9%

Z_Plant Maintenance 19,548 14%

Z_Procure to Pay 39,519 27%

Now the problem is that according to result we are getting the violation report also is in a Graphical Mode, and if I click on this graph it has been showing the result "No match nor conflict found" with respect of "Risk Violations by Process". But the graphical data has come properly and we got the successfull result in other case exccept via "Risk Violations by Process".

But when we have checked from the DB level we found DATA is already exist into table.

We ran bellow mention SQL Statement successfully and got proper result

SELECT MIN(S.YEARMONTH) AS YEARMONTH, MIN(S.VIOLTYPE) AS VIOLTYPE,

MIN(S.VSYSKEY) AS VSYSKEY, S.ANLTYPE, MIN(S.USERGROUP)

AS USERGROUP, S.RISKID, MIN(S.BZPRCID) AS BZPRCID, MIN(S.RISKLEVEL)

AS RISKLEVEL, SUM(S.RISKCOUNT) AS RISKCOUNT,

R.DESCN AS RISKDESC, B.DESCN AS BZPRCDESC

FROM SAPSR3DB.VIRSA_CC_MGRISKS S LEFT OUTER JOIN

SAPSR3DB.VIRSA_CC_RISKT R ON R.LANG = 'EN' AND S.RISKID = R.RISKID

LEFT OUTER JOIN

SAPSR3DB.VIRSA_CC_BUSPRCT B ON B.LANG = 'EN' AND S.BZPRCID = B.BZPRCID

WHERE (S.YEARMONTH LIKE '200901') AND (S.VIOLTYPE = 'PERMISSION')

AND (S.VSYSKEY LIKE 'ECQCLNT360') AND (S.ANLTYPE = 2)

GROUP BY S.ANLTYPE, S.RISKID, R.DESCN, B.DESCN

ORDER BY S.RISKID

But Anotther issue matter is that if I change User Account English to German from User Management Engine then I have got the data from RAR, again if I turn it back English again getting the same pprobs.

Whay does it happening. any one is there have experienced with the same issue. Pleas let me know the solution.

Thanks & Regards

Pavel Das

PwC - India

+919874886293

Edited by: Pavel Das on Feb 9, 2009 7:57 AM

Edited by: Pavel Das on Feb 9, 2009 8:03 AM

[Former Member]

Hello Pavel,

Management report save detail data for only one month, which is the latest one.

Apart from that can you confirm if you had not run any delete script to remove any Connector (System).

Regards,

Surpreet Singh Bal