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
Can you post the sql statement you are trying to use?
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.
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.