Active IQ Unified Manager Discussions

OCI 7.3.4 DWH Cognos Analytics

sstrznwra
2,244 Views

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

 

 

1 REPLY 1

sstrznwra
2,223 Views

Hi,

 

I think I have found the solution

 

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

Public