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 LOB='APD' SELECT item.item 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 'LOB'. (HY000)
SQL Issued: {call NQSGetLevelDrillability('SET VARIABLE LOB=''APD'' SELECT item.item saw_0, valueof(nq_session.LOB) saw_1 FROM OLEM')}




 This is the common error, the developers get, when he try to change the value of session variable using request variable in request prefix field. ( refer how to change the value of session variable using Request Variable ).

Solution :
 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.



Now, check the request in presentation service. Log out from that session and again login to presentation services and the same report. If you get the same error again, please let me know by your comments.

Comments

Post a Comment

Thanks for your comment.

Popular posts from this blog

Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P:OI2DL65P

-
Image
User gets the below shown error in Presentation Services when he try  to issue any requests to OBI Server. Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P:OI2DL65P State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43081] Illegal operation attempted on a closed session. (HY000) The most possible reason for this error is :  The BI Server Administrator might have disconnected the current user's session and that user might be still sending request to the BI Server. Solution : When the BI Server Administrator disconnects USER from the current session, then such user can not send request to the BI Server. Because that user in no more in the session to request. Solution : Log out from the Presentation Services (just click on the Log Out button) and again Log in and check the same request.
Read more

Connection Pool

-
Image
The connection pool is an object in the Physical layer, it contains information about the connection between the Oracle BI Server and that data source. The Physical layer in the Administration Tool contains at least one connection pool for each database. When you create the physical layer by importing a schema for a data source, the connection pool is created automatically. You can configure multiple connection pools for a database.It is recommended that you create a dedicated connection pool for initialization blocks. About Connection Pools for Initialization Blocks It is recommended that you create a dedicated connection pool for initialization blocks. This connection pool should not be used for queries. Additionally, it is recommended that you isolate the connections pools for different types of initialization blocks. This also makes sure that authentication and login-specific initialization blocks do not slow down the login process. The following types should
Read more

Alias Table in OBIEE

-
Image
Alias table means it is a reference table for the physical Table. When you create any alias table, then the alias table will inherit all the properties of the physical table. We can not modify the alias table properties, like 1. can not rename the column name. 2. Can not change the  column data type . 3. Can not delete the columns But we can only change the alias table name according to our naming convention. Steps to create Alias table : 1. Right click on the physical table, New Object -->Alias 2. Give the name for alias table. Then click on OK. Advantages of Alias Table : 1. OBIEE does not support Circular join in BMM layer, so we can overcome from this problem by creating alias table for one of the table in that circular join. 2. OBIEE does not support self join, so we can overcome from this problem by creating alias table. 3. If a fact table having relationship with dimention table on more than one key, then we can create aliases for the dimension talbe, t
Read more