Error : [nQSError: 13015] You do not have the permission to set the value of the variable
| View Display Error | |
Error getting drill information: SET VARIABLE LEDGER-ID='02' SELECT ledger.ledger_id saw_0, valueof(nq_session.LOB) saw_1 FROM OLEM
Error Details
Error Codes: YQCO4T56:OPR4ONWY:U9IM8TAC:OI2DL65P
Odbc driver returned an error (SQLExecDirectW).
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 13015] You do not have the permission to set the value of the variable 'LEDGER_ID'. (HY000)
SQL Issued: {call NQSGetLevelDrillability('SET VARIABLE LOB=''LEDGER'' SELECT ledger.ledger_id saw_0, valueof(nq_session.LEDGER_ID) saw_1 FROM LEDGER')}
| |
Go to properties of session variable all check the option "Enable everyone to set value"
Follow the below steps :
1. Open Administration Tool. Go to Manager > Variables.
2. Select System or Non-System variable (depends on type of your variable) under the Session from left pane. Then the corresponding variables will be listed on right pane.
3. Right click on the variable(for which your getting error in presentation service when you tried to change its value) and select properties.
4. check the option "Enable everyone to set value" (by default this option is unchecked) and click OK.
Log out from that session and again login to presentation services and the same report.
