A customer needs to create a product share calculation. What are the two ways that they would get the revenue for all products to use in the denominator?
Correct Answer: A,C
Note: A level-based measure is a column whose values are always calculated to a specific level of aggregation. The calculation of this measure is independent of the query grain and used always the aggregation grain of the logical column. Level-based measures allow : * to return data at multiple levels of aggregation (the query grain and the level-based column grain) with one single query * to create share measures (percentage), that are calculated by taking some measure and dividing it by a level- based measure. For example, you can divide salesperson revenue by regional revenue to calculate the share of the regional revenue each salesperson generates.
Question 12
The administration tool is the developer's interface to the repository file. It allows the development of and changes to the metadata repository file. Which statement is true?
Correct Answer: B
Explanation The Oracle BI repository development process adheres to the classic Software Configuration Management (SCM)process, which utilizes a three-way merge to manage concurrent development. The merge process involves three repositories: * The (Original|Received|Master|Parent) repository. The repository that you received before changed. You must keep it preciously unchanged. * The Modified repository. The repository that contains the customizations you made to the original repository. * The Current repository. Generally, the repository that is in production and where some customisations could have been performed by other people. In a multiuser environment (MUDE), Developers check out the file and make changes locally. Then, these changes are automatically reconciled and merged into the master repository.
Question 13
Which component is responsible for determining the device that receives the alerts for a given user account?
Correct Answer: D
------- In an Ibor or Agent, in the 'Destinations' tab you can set the 'Specific Devices' However, it is a Device or Delivery Profile the one used for alerts, see this OBIEE guide: ---------------x-------------- User's Guide http://download.oracle.com/docs/cd/E21764_01/bi.1111/e10544/toc.htm http://download.oracle.com/docs/cd/E21764_01/bi.1111/e10544.pdf page 218 What Are Devices and Delivery Profiles? Devices and delivery profiles control how you will be reached when an alert is generated by an agent and which devices receive the content: | Device - A device is the medium used to deliver content to you. The content of an agent can be delivered to a range of devices as an e-mail or SMS message. | Delivery profile - A delivery profile specifies which devices to use to deliver content to you, based on the priority of the content. You can define several delivery profiles to meet your needs, and switch ---------------x--------------
Question 14
Which resource identifies the OBIEE Web Catalog (webcat)?
Correct Answer: C,E
Explanation/Reference: C: Oracle Business Intelligence authenticates users and get groups using an Oracle WebLogic Server authentication provider against user information held in an identity store. Incorrect answers: A: On 10g, Instanceconfig.xml is THE parameter file of the BI Presentation server. With the advent of 11g, instanceconfig.xml is also the configuration file of Oracle BI Scheduler The instanceconfig.xml file stores the configuration settings that affect Oracle BI Presentation Services. B: If you want to install the OBIEE Server you have to create some schemas in the database which will keep the OBIEE repository. For working, OBIEE needs some schemas to be created. This work is dome automatically by using rcu (Repository Creation Utility). In order to create the OBIEE schemas with the RCU, you must have installed an Oracle database (11g). D: NQSConfig.ini is the main configuration file of Bi Server and contains a lot of parameters. The file is located in this directory : 11g: ORACLE_INSTANCE/config/OracleBIServerComponent/coreapplication_obisn All changes made to this file require that you restart the Oracle BI Server Service. Note: OBIEE 10G/11G - The (Web|Presentation) Catalog (Webcat) The Web Catalog becomes in 11g the Presentation Catalog. publisher objects (such as reports and templates). Each object is composed of two files: * its own file. For example, an analysis called Analysis 1 would be stored in a file named Analysis1. * a attributes file. For example, the analysis called Analysis1 would have a corresponding attributes file named Analysis1.atr. The attributes file contains: the object's full name, access control list (ACL), description, and so on. To access an object in the catalog, users must have appropriate ACL entries for that object. All objects in the catalog use ACL entries. In 11g, the Everyone group has been replaced with the AuthenticatedUser role The webcatalog is located: on 11G: ORACLE_INSTANCE/bifoundation/OracleBIPresentationServicesComponent/catalog/
Question 15
Which option describes how OBIEE natively integrates with HFM?
Correct Answer: A
BI EE uses the ADM driver to extract the data from HFM. Note: HFM (Hyperion Financial Management) Example: I EE connects to HFM through JavaHost. So, the setup for configuring the connectivity is to basically make the EPM environment variables available for access to BI EE. Before making the changes, there are a couple of things to be aware of 1.Ensure that DCOM is enabled on the BI Server machine. This is needed for HFM client to work/connect properly with HFM Server. 2.Ensure that HFM Client is installed. The above assumes EPM 11.1.2.x version. If you are on Hyperion 9.3.3, then you need to have the ADM drivers installed manually. All of this is documented clearly. So, rather than re-iterating that i will just point to the link here. Ensure that you follow all the steps mentioned in the docs else you will have issues in the connectivity. Once all the pre-requisite steps are done, we start off with the metadata import process. NewImage
