www.iwarelogic.com
GoldPartner© Copyright 2005-2011 iWare Logic Technologies Pvt. Ltd.
PresentsImplement new OBIEE 11g User Interface through KPI and
Scorecard
Webinar
www.iwarelogic.com
GoldPartner© Copyright 2005-2011 iWare Logic Technologies Pvt. Ltd.
Disclaimer
All other trademarks, service marks and logos used in this webinar are the trademarks, service marks or logos of their respective owners.
The views expressed in this webinar are views of the speakers and do not necessarily reflect the views of iWare Logic Pvt. Ltd
www.iwarelogic.com
GoldPartner© Copyright 2005-2011 iWare Logic Technologies Pvt. Ltd.
Agenda
Introducing OBIEE 11g
New Features introduced in OBIEE 11g
Key Performance Indicators & Watchlist
Creating KPIs and Watchlist
Working on Scorecards
Refining results through Selections
www.iwarelogic.com
GoldPartner© Copyright 2005-2011 iWare Logic Technologies Pvt. Ltd.
Introducing OBIEE 11g
www.iwarelogic.com
GoldPartner© Copyright 2005-2011 iWare Logic Technologies Pvt. Ltd.
New Features introduced in OBIEE 11g
OBIEE 11g uses Web Logic Server as the application server as compared to Oracle AS or OC4J in OBIEE 10g.
The clustering process in much easier and automated in OBIEE 11g.
We can now model lookup tables in the repository.
The new UI called Unified Framework now combines Answers, Dashboards, and Delivers.
A new column called the hierarchical column in introduced.
BI Publishers is fully and seamlessly integrated with OBIEE 11g.
www.iwarelogic.com
GoldPartner© Copyright 2005-2011 iWare Logic Technologies Pvt. Ltd.
Contd….
New time series functions PERIOD ROLLING and AGGREGATE AT are introduced.
In OBIEE 11g we can create KPIs to represent business metrics.
The aggregate persistence wizard creates indexes automatically.
The session variables get initialized when they are actually used in OBIEE 11g unlike OBIEE 10g where they were initialized as soon as a user logs in.
OBIEE 11g now supports Ragged (Unbalanced) and Skipped Hierarchy.
You can also define Parent-Child hierarchy in OBIEE 11g as well.
SELECT_PHYSICAL command is supported in OBIEE 11g.
www.iwarelogic.com
GoldPartner© Copyright 2005-2011 iWare Logic Technologies Pvt. Ltd.
Key Performance Indicators
www.iwarelogic.com
GoldPartner© Copyright 2005-2011 iWare Logic Technologies Pvt. Ltd.
Measuring Performance by KPIs & Watchlist
Key Performance Indicators (KPIs) are high-level snapshots of a business or organization based on specific predefined measures and represent the results of these business measures.
A KPI Watch list is a collection and performance status report of KPIs to measure the progress of objectives or initiatives.
KPIs typically consist of any combination of analyses, spreadsheets, or graphs..
KPIs always include the metric to be monitored
KPIs can be calculated by using formulas or by entering literal values.
www.iwarelogic.com
GoldPartner© Copyright 2005-2011 iWare Logic Technologies Pvt. Ltd.
Creating KPIs and Watchlist
Demo
www.iwarelogic.com
GoldPartner© Copyright 2005-2011 iWare Logic Technologies Pvt. Ltd.
Balanced Scorecard
www.iwarelogic.com
GoldPartner© Copyright 2005-2011 iWare Logic Technologies Pvt. Ltd.
Scorecard
Scorecard is a performance management tool that lets you describe and communicate your business strategy.
Balanced Scorecards provide a mechanism for Organizations to:Define their vision, mission, goals and strategyGauge their performance in achieving their goals
KPIs are used as the building blocks for Balanced Scorecards in OBIEE 11g
By default, there are four perspectives used to classify Balanced Scorecard “Objectives”:
FinancialCustomerInternal ProcessLearning and Growth
www.iwarelogic.com
GoldPartner© Copyright 2005-2011 iWare Logic Technologies Pvt. Ltd.
Working on or creating Scorecard
Demo
www.iwarelogic.com
GoldPartner© Copyright 2005-2011 iWare Logic Technologies Pvt. Ltd.
Refining Searches through Selection
Refining Searches through Selection
www.iwarelogic.com
GoldPartner© Copyright 2005-2011 iWare Logic Technologies Pvt. Ltd.
What is Selection?
Selections are used to limit the members displayed when an analysis is run.
Based on the selection steps and criteria that you define, Oracle Business Intelligence shows only those attribute or hierarchical members that match your criteria.
Selections are defined on a per-column basis. Initially, a default selection step containing all attribute or hierarchy members is created when you add a column to the selected columns of an analysis.
In this sense, member selections are made whenever you add an attribute or hierarchical column to your analysis. You can then add additional steps and refine the membership criteria to refine your results. Selection steps are used to refine the definition of your query.
www.iwarelogic.com
GoldPartner© Copyright 2005-2011 iWare Logic Technologies Pvt. Ltd.
Working on Selection
Demo
www.iwarelogic.com
GoldPartner© Copyright 2005-2011 iWare Logic Technologies Pvt. Ltd.
QuestionsAnswers
www.iwarelogic.com
GoldPartner© Copyright 2005-2011 iWare Logic Technologies Pvt. Ltd.
About iWare Logic
iWare Logic is an Enterprise Business Applications Consulting company, specializing in Oracle Applications and Technologies. iWare Logic is an Oracle Gold Partner providing IT Services in areas like Oracle E-Business Suite, OAF, ADF, BI DW and DBA.
iWare Logic offers Application Development delivery with focus on application customizations, workflows, integrations, and data conversions. We also provide skilled resources for on-site/off-shore projects for Oracle Enterprise Applications' Implementations and Support.
For any queries, feel free to drop a mail to [email protected]
www.iwarelogic.com
GoldPartner© Copyright 2005-2011 iWare Logic Technologies Pvt. Ltd.
iWare Logic Technologies Pvt. Ltd. Aditi Samruddhi, Baner, Pune, India - 411045
Email: [email protected]: www.iwarelogic.com