Which option describes how OBIEE Integrates with Planning?
A.
OBIEE primarily accesses Planning using standard Essbase integration techniques.
B.
OBIEE provides complete access to all Planning data through the Analytic Data Model (ADM)
layer.
C.
Planning is not a supported OBIEE source.
D.
OBIEE integrates with Planning directly through relational database access.
Explanation:
A:
* Combining Relational and OLAP Data Sources: Oracles Common Enterprise Information Model
allows users to combine data from a relational system and an OLAP source in a single calculation.For example, a user can compare sales forecasts from an Oracle CRM System with budget data
from an Oracle Essbase planning application. To clients of the Common Enterprise Information
Model, the forecast and budget data appear to be from the same logical source.
* The Essbase server provides advanced multi-user read and write capabilities, including data
update and multi-user recalculation. Business users with front-end tools can write data back to a
server and recalculate the data on a server using calculation scriptskey functionality to support
sophisticated modeling and planning applications.
* Using aggregate storage, Essbase serves a wide range of analytic needsfinancial analysis,
planning, budgeting, sales analysis, marketing analysis, supply-chain analysis, and profitability
analyticsall from a single analytic infrastructure.
Note 2: Data model for business intelligence
The most important component of business intelligence is the concept of ‘data model’. data model
determinde what kind of analysis that end user could do with the data. It is also an independant
concept that could span across different vendor ‘s product.
Unlike data model of the transaction system, the typical analytic data model is often denormalized
and store extra data for analytic query and better query performance while transaction data model
use is often normalized and optimized for a few data read and write, which is implemented by
jointing many tables.
The most common used analytic data model in business intelligence is call the ‘Star schema’ data
model.
With the Oracle business intelligence system, We could define star schema and dimension data
model in the ‘logical layer’ in the admin tools. The data model in OBIEE could span different data
source in physical layer, which means OBIEE have the capability of building one logical data
model which is actually connect to different database in the backend
A and B
Option or options ?
hypron essbase is the data side of hypron planning, actually the integration of obiee and planning is that of obiee and essabe, another integration manner is the excel smartview, which connects both essbase and obiee, and bridges the essbase and obiee
can i use these questions for my exam in 2017 June?
did these questions help u in your June 2017 exam ?
zamel, did these sample questions help you in your exam?