Saturday, April 28, 2012

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 :


No comments:

Post a Comment

Thanks for your comment.