Explain about the variables in RPD
The variables in RPD are divided into two classes
1. Repository variables
a. Static variable
b. Dynamic variable
2. Session variable
a. System variable
b. Non-System variable
1. Repository Variables:
A Repository variable has a single value at a point of time. They are divided into two types
a. Static: This value persists and does not change until we change it manually
b. Dynamic: The values are refreshed by data returned from queries. When creating a dynamic repository variable, you will create an initialization block or use preexisting one that contains a SQL query. You will set up a schedule that the BI server will follow to execute the query and periodically refresh the value of the variable
2. Session variables:
Session variables are created and assigned a value when each user logs in. They are divided into two types
a. System: these are session variables having reserved names. Ex: User, group, proxy,etc
b. Non-System: these are session variables having the names other than system session variables
The variables in RPD are divided into two classes
1. Repository variables
a. Static variable
b. Dynamic variable
2. Session variable
a. System variable
b. Non-System variable
1. Repository Variables:
A Repository variable has a single value at a point of time. They are divided into two types
a. Static: This value persists and does not change until we change it manually
b. Dynamic: The values are refreshed by data returned from queries. When creating a dynamic repository variable, you will create an initialization block or use preexisting one that contains a SQL query. You will set up a schedule that the BI server will follow to execute the query and periodically refresh the value of the variable
2. Session variables:
Session variables are created and assigned a value when each user logs in. They are divided into two types
a. System: these are session variables having reserved names. Ex: User, group, proxy,etc
b. Non-System: these are session variables having the names other than system session variables
No comments:
Post a Comment