OCI 7.3.4 DWH Cognos Analytics

sstrznwra — Wed, 04 Jun 2025 12:46:12 GMT

Hi,

OCI DWH 7.3.4 ( Cognos Analytics 11.0.9) when I create a user defined SQL Query the error

RQP-DEF-0326 User defined SQL is not permitted for the user who has the identity '{ReportingAdminCM, ReportingProAuthorCM, Everyone, All Authenticated Users, Portal Administrators, Metrics Administrators, Readers, Report Administrators, Express Authors, Cognos Insight Users, Statistics Authors, Authors, Consumers, Directory Administrators, PowerPlay Administrators, Query Users, Planning Rights Administrators, Controller Administrators, Adaptive Analytics Administrators, Server Administrators}'.

occurs.

I found on IBM Support Site http://www-01.ibm.com/support/docview.wss?uid=swg21342307

Resolving the problem

Modify the end user's Cognos security permissions to allow both of the following:

But which groups must now be justified ??

My user is Member of ReportingProAuthor group .

Thanks

Michael

Re: OCI 7.3.4 DWH Cognos Analytics

sstrznwra — Wed, 06 Mar 2019 13:52:03 GMT

Hi,

I think I have found the solution

https://www-01.ibm.com/support/docview.wss?uid=ibm10732343

topic OCI 7.3.4 DWH Cognos Analytics in Active IQ Unified Manager Discussions

OCI 7.3.4 DWH Cognos Analytics

Resolving the problem

Re: OCI 7.3.4 DWH Cognos Analytics