InterviewSolution
| 1. |
What Are Different Types Of Variables? Explain Each. |
|
Answer» There are two classes of variables:
Repository variables: A repository variable has a single value at any point in TIME. There are two types of repository variables: Static: This value persists, and does not change until a Siebel Analytics Server administrator decides to change it. Dynamic: The values are refreshed by data returned from queries. When defining a dynamic repository variable, you will create an initialization BLOCK or use a preexisting one that contains a SQL query. You will also set up a SCHEDULE that the Siebel Analytics Server will follow to execute the query and PERIODICALLY refresh the value of the variable. Session Variables: Session variables are created and ASSIGNED a value when each user logs on. There are two types of session variables:
There are two classes of variables: Repository variables: A repository variable has a single value at any point in time. There are two types of repository variables: Static: This value persists, and does not change until a Siebel Analytics Server administrator decides to change it. Dynamic: The values are refreshed by data returned from queries. When defining a dynamic repository variable, you will create an initialization block or use a preexisting one that contains a SQL query. You will also set up a schedule that the Siebel Analytics Server will follow to execute the query and periodically refresh the value of the variable. Session Variables: Session variables are created and assigned a value when each user logs on. There are two types of session variables: |
|