Saturday, December 15, 2012

Variables in RPD

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

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...