Syntax for Repository Variables in different places

-
We can use Repository variables in Title view, Narrative view, Fx of Answers, Text box in Dashboard and SQL statements.

We can  refer Repository variables in two ways :
1. VALUEOF(VARIABLE_NAME)
2. @{biServer.variables['VARIABLE_NAME']}

VALUEOF(VARIABLE_NAME) - We can use this syntax in fx of Answers, SQL statements in Administration Tool and Direct Database Requests.


We can not use this syntax in any other places. If you this syntax in title view or Narrative view you will get abnormal results.

@{biServer.variables['VARIABLE_NAME']} - We can use this syntax in all places (fx of report, title view, narrative view, text box of dashboard and in SQL statements).

In fx of Answers : 


In Title View :

In Narrative View :



In Text Box of Dashboard :


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