Question 6 of 120
Query limits tab can be accessed through________.
Correct Answer: C
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.
C
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.
CQuestion 7 of 120
One of the most common uses of Dynamic Repository Variables is to setup filters for use in reporting. Which variable below is a valid example of a Dynamic
Repository Variable?
Repository Variable?
Correct Answer: D
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; D
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; D
Question 8 of 120
WLS Embedded LDAP Server is managed by the Admin Server Console and supports which three options?
Correct Answer: A, C, D
Question 9 of 120
Point-and-click generation of case statement logic can be accessed via which option?
Correct Answer: A
The "Edit Column Formula" dialog box has a second,
very tiny tab called, "Bins." You can use this tab to have OBIEE build a CASE statement for you in a formula (you can also create a CASE statement yourself by using one of the functions that appears under "Expressions" if you want). A CASE statement is a lot like an IF-THEN-ELSE statement, except that its a little easier to read when you have multiple options. Basically, it puts values in different buckets that you define.
Note:
Figure:
Incorrect answers:
C: The "Conditional Format" tab lets you set formatting when specific conditions are met. A
very tiny tab called, "Bins." You can use this tab to have OBIEE build a CASE statement for you in a formula (you can also create a CASE statement yourself by using one of the functions that appears under "Expressions" if you want). A CASE statement is a lot like an IF-THEN-ELSE statement, except that its a little easier to read when you have multiple options. Basically, it puts values in different buckets that you define.
Note:
Figure:
Incorrect answers:
C: The "Conditional Format" tab lets you set formatting when specific conditions are met. A
Question 10 of 120
Which task can be performed after the Administrator link has been reached through logging into OBIEE?
Correct Answer: B, C, D
B: BI Server Security Manager accessed through the BI Server Administration Tool.
* Set permission to business model, tables, columns and subject areas
* Specify filters to limit data accessible by users
* Set authentication options
C: Enable the SSO through the FMW Control.
D: You have three methods to start the managed server:
* with the console (recommended)
* with FMW control
* with the command line. BCD
* Set permission to business model, tables, columns and subject areas
* Specify filters to limit data accessible by users
* Set authentication options
C: Enable the SSO through the FMW Control.
D: You have three methods to start the managed server:
* with the console (recommended)
* with FMW control
* with the command line. BCD