XQE-PLN-0148 - Error

[hrk551]

All,

While trying to create a new query subject in FWM I am getting "XQE-PLN-0148 User defined SQL is not permitted". I am getting this error only when I write a SQL with conditions in the query sunject. But If I just use Select * from YYYYY then no issue.
Any idea. Thank you.

Hrk

[tjohnson3050]

Can you post the sql statement you are trying to use?

[hrk551]

For example: If we take
Select
   DIM_DISBURSEMENT.DIMENSION_KEY,
   DIM_DISBURSEMENT.SOURCE_UNIQUE_IDENTIFIER,
   DIM_DISBURSEMENT.EXPIRATION_DATE,
   DIM_DISBURSEMENT.CASHOUT,
   DIM_DISBURSEMENT.RENEWAL_MEMO,
   DIM_DISBURSEMENT.LAST_UPDATE_DATE,
   DIM_DISBURSEMENT.ID,
   DIM_DISBURSEMENT.DISB_FLAG,
   DIM_DISBURSEMENT.EFFECTIVE_DATE,
   DIM_DISBURSEMENT.COMMENT,
   DIM_DISBURSEMENT.APPROVAL_DATE,
   DIM_DISBURSEMENT.LAST_USER,
   DIM_DISBURSEMENT.DISB_NO
From
   [IICCMD-11G-Rac].DIM_DISBURSEMENT as DIM_DISBURSEMENT"

And If I test data I get" This query contains an error and can not be executed.

It is recommended that you view the query feedback on the "Query Information" tab.

XQE-PLN-0148 User defined SQL is not permitted."

But If I just replace it with * then no problem in accesing test data in the model. But I cannot use * in all the cases for some I need to write some conditions.

[tjohnson3050]

The only place I have seen this error is on the reporting side.  There is a sub capability under the report studio capability for running user defined sql.  Just to rule it out, make sure you have this capability:

1. Open Cognos Connection.
2. Click Tools -> Capabilities
3. Set Properties of "Report Studio"
3. Click the Permissions tab.
4. Add the user/group who needs the capability and grant Traverse rights.