Data Infrastructure Management Software Discussions

OCI 7.3.4 DWH Cognos Analytics

sstrznwra

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

Re: OCI 7.3.4 DWH Cognos Analytics

sstrznwra

Hi,

 

I think I have found the solution

 

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

Earn Rewards for Your Review!
GPI Review Banner
All Community Forums
Public