Variables

Variables:

1. Why variables are needed  in OBIEE11G?

A) Variables are useful to handle dynamic scenarios in OBIEE11G.

2. How many types of variables are present in OBIEE11G?

A) We have mainly four types of variables

1. Repository variables.

2. Session variables.

3. Presentation variables.

4. Request variables.

3. What variables are defined in RPD?

A) Repository and session variables are defined in RPD

4. Where is the use of repository and session variables?

A) The repository and session variables are used in

a.RPD calculations.

b.RPD filters.

c. Report calculations.

d. Report filters.

e. Dashboard prompts.

5. Where are the presentation and request variables are defined?

A) Presentation and request variables are defined in Dashboard prompt.

6. Repository variables are also called as?

A) These variables are also called as Oracle BI server variables.

7. When we can update the repository variables?

A) Repository variables values will be updated whenever oracle BI server is restarted or started and based on schedule.

8. What is the syntax of repository variable?

A) syntax:VALUEOF(<VARIABLE_NAME>).

9. How many types of repository variables are present in OBIEE11G?

A) There are two repository variables in OBIEE11G:

a. Static.

b. Dynamic.

10. When we will go for static repository variable?

A) If we want to use a constant value in 'n'  no of  places then we will go for static variables.

a. Static variables are initialized in static repository variable dialog box.

11. What are the static predefined syntax variables for date?

A) The three static pre-defined syntax for date are:

a. Date.

b.Time.

c. Timestamp.

12. What variables are associated with initialization blocks?

A) Dynamic repository variables will be associated with initialization blocks.

13. What is an initialization block?

A) A SQL query is called an initialization block.

a. These initialization blocks will be executed with oracle bi server refresh and based on schedule of initialization block.

b. schedule option is available only for dynamic repository variable initialization block.

14. What is ROW WISE initialization blocks?

A) They are used to retrieve and initialization a list of values to a non system session variables.

a. Returns list of values separated by column.

Ex:CA:TEXAS

a. Used for implementing data security when one user normally belong to more than one group.

15. What is the difference between repository variables and session variables?

A)

REPOSITORY VARIABLES	SESSION VARIABLES
Thses variables are same for all users	Change from one user to user
These IB will run with OBIS start or restart based on schedule	These IB run at the time of user login
Static and dynamic	System and non system
Syntax:VALUEOF(VARIABLENAME)	Syntax:VALUEOF(NQ_SESSION.VARIABLE NAME)
These things are useful to capture max year,max month etc from database	Data security or row level security

16. What is a presentation variable?

A) Presentation variable is used to capture" user response".

17. Where we will use the presentation variables?

A) We will use the presentation variables in variable prompt.(upto 11.1.1.6) version only presentation variable.

18. What is the syntax for presentation variable?

A) presentation variable syntax:@{variable name}{(value)}{(format)}.

1. Here value and format are optional.

2. variable name is the name of the PV.

3. value is by default value.

4. Format is to convert one format to another format.

19. What is a request variable?

A) It is useful to to override  session variable values.

a. The name of the request variable must be same as the session variable.

20. Where we will define the request variable?

A) We will define the request variable in Dashboard prompt.

a. It is useful to send the values from report to RPD.

21. what is a session time?

A) Log out-Log in is called as session time.

a. Any application will support ‘N’ no of sessions.

b. Session variables will be populated separately for each and every session or user.

c. Receives values when users establish their sessions.

22. What is the syntax of session variables?

A) Syntax is VALUEOF(NQ_SESSION.Variablename).

23. How many types of session variables are present in OBIEE11G?

A) Session variables are divided into two types:

1. System variable.

2. Non-System variable.

24. What is system session variable?

A) These are predefined session variables used by oracle bi server for specific purpose such as authenticating users.

25. What are different types of session variables?

A) We have below system variables (CASE SENSITIVE AND MUST BE CAPITAL)

1. USER.

2. PASSWORD.

3. DISPLAYNAME.

4. GROUP.

ETC

a. These variables are useful in special cases such as authenticating user. These variables should not used for any other purpose(as a static variable name or dynamic variable name or non system session variable).

26. What is non system session variable?

A) These are application specific customized variables.

a. These variables required session initialization blocks.

b. Session initialization blocks will be executed when ever user login into analytic applications.