Download Oracle Business Intelligence Foundation Suite 11g Essentials.1z0-591.PracticeTest.2019-02-13.71q.tqb

Note 1: There are four types of variables that you can use:Session Repository Presentation Request Note 2: Session VariablesA session variable is a variable that is initialized at login time for each user. When a user begins a session, the Oracle BI Server creates a new instance of a session variable and initializes it. There are as many instances of a session variable as there are active sessions on the Oracle BI Server. Each instance of a session variable could be initialized to a different value. There are two types of session variables:System — A session variable that the Oracle BI Server and Oracle BI Presentation Services use for specific purposes. System session variables have reserved names that cannot be used for other kinds of variables (such as static or dynamic repository variables and non-system session variables). Non-system — A system variable that the administrator creates and names. For example, the administrator might create a SalesRegion non-system variable that initializes the name of a user's sales region. The administrator creates non-system session variables using the Oracle BI Administration Tool. Incorrect answers:A: ETL Load Date is a DAC Source System Parameter.C: OLAP DSN is a Repository variable.

Query environment can be managed by setting query limits (governors) in the Repository (RPD) for particular Application Roles. You should always set query limits for particular application roles rather than for individual users. Steps:1. Login to Repository using OBIEE Admin Tool 2. Navigate to Manage > Identity 3. Go to Application Role tab, choose the role and double click on it to open.     4. Click on Permissions tab     5. Set the Query Limits. You can limit queries by the number of rows received, by maximum run time, and by restricting to particular time periods. You can also allow or disallow direct database requests or the Populate privilege.    

CurrentMonth can be calculated by a sql statement. Note:REPOSITORY VARIABLE(DYNAMIC) Initialized when BI server is started Assigned value dynamically based on the result of a query Value is dependent of the sql provided in Initialization Block Create a dynamic variable and provide a Name and Default Initializer.Create a new initialization block by clicking on the New button in the above screen.     Provide Intialization Block variable Name     Click on “Edit Data Source” button and provide the sql to be used for the variable, e.g. select lower(sys_context('USERENV','SESSION_USER'))||        '@'||        lower(sys_context('USERENV','DB_NAME'))   from dual;