Sunday, January 31, 2016

How to understand an association on report in IBM OpenPages

1. Problem

OpenPages


  1. Analysis



[GOR2_REL].[RISKASSESSMENT].[RA_RISKASSESSMENT_ID]
[GOR2_REL].[SOXPROCESS].[PR_PROCESS_ID]
[GOR2_REL].[RISKCAT].[ZR_RISKCAT_ID]



SELECT RISKASSESSMENT_ID,
 REPORTING_PERIOD_ID,
 PROCESS_ID,
 HIER_INSTANCE_ID,
 IS_PRIMARY,
 DISTANCE
FROM RT__RISKASSESSMENT_PROCESS ;


SELECT RESRELATIONSHIPID,
 SETID,
 PARENTID,
 CHILDID,
 ACTORID,
 CREATIONDATE,
 PARENTCONTENTTYPE,
 CHILDCONTENTTYPE,
 IS_NOT_PRIMARY,
 IS_PRIMALITY_AUTO_ASSIGNED
FROM RESRELATIONSHIPS
where PARENTCONTENTTYPE=92 and CHILDCONTENTTYPE =77;
92  = RiskAssessment
77=SOXProcess

Once lost, and then reload

No comments:

Post a Comment