Governance, Risk, and Compliance (GRC)

Hi @Gabriele Meneguzzi. Right now this can be done through custom queries only. The tags are available in Cognos, not in the reporting framework, but through direct SQL today. 

Hi,

The information is held in the RESOURCE_TAGS and RESOURCE_TAG_ASSOC tables.

The following SQL will pull out all assigned tags per resource (ie per IOpenPages object).

You can add this SQL as a query to a Cognos report and then join it to other Framework based queries such as for Risk Event, Issue, Risk etc

select rta.resource_id         "Resource ID", 
       listagg(rt.name,',')    "Tags"
  from resource_tags rt, 
       resource_tag_assoc rta
 where rta.tag_id = rt.tag_id
 group by rta.resource_id

Hope this helps.

Regards

Chris Jones

Crystal Computing 

http://www.ccsl.uk.com

Thanks a lot, Julie very clear we find and test it. thanks a lot