Use the following procedure to open a kpi definition from a scorecard. I had issues with kpi comments in obiee but i have been able to resolved it. This chapter explains how to use key performance indicators kpis and kpi watchlists in oracle business intelligence enterprise edition. The ability to perform certain tasks when building kpis and kpi watchlists, or within oracle scorecard and strategy management such as, creating scorecards or. Another new part of obiee 11gr1 that you may have seen at the launch in london, is a new product called oracle scorecard and strategy management. Feb 05, 2016 dear readers, obiee 12c is very rich in ui in key features like visual analyser, enhanced map viewer, hd mobile development,integration with hyperion epm etc. Oct 27, 2014 levelbased measures in oracle business intelligence obiee if we want to view the revenue aggregated to the brand level then. Usage of key performance indicators in obiee welcome to. Oracle business intelligence enterprise edition plus, also termed as the obi ee plus, is oracle. Obiee 1measuring results with scorecards and kpis using oracle bi ee 11. Obiee advanced kpisorder by kpis obiee kpi oracle bi. Helping teams, developers, project managers, directors, innovators and clients understand and implement data applications since 2009. Obiee 11g allows you to define and customize kpis, and to then integrate them into your dashboard. Oracle business intelligence enterprise edition obiee 11g 4.
Posts about obiee scorecard and strategy management written by harikv. Kpi s can also be used to automatically trigger alerts to specific users using obiee s agent mechanism when kpi target values reach critical status levels. A kpi is a measurement of a particular business process which is compared against specific goals and objectives of an organization. Generally, an ebook can be downloaded in five minutes or less. In this section, you will create a number of kpis from the a sample sales subject area kpi concepts and terminology. With the launch of obiee 11g we can look at some of the key new features in this release.
Kpis can also be used to automatically trigger alerts to specific users using obiees agent mechanism when kpi target values reach critical status levels. Build key performance indicators and scorecards in your business intelligence metadata with oracle. Oracle obiee 11g has officially been launched to a very large fan base of both obiee and essbase on july 7. In this post, we will explain what is a kpi scorecard, when to use it, what is the difference between scorecard and dashboard, and kpi scorecard examples and templates from business scenarios that can be applied to different departments and organizations or used as a roadmap for online data analysis. Oac csv download limit 2 years ago camerons blog for essbase hackers. While the power kpi visual has been a necessary building block for us in the presentation of kpis, by itself it doesnt provide a scorecard layout. But both suspicions come with a fair level of uncertainity. For example, to a kpi called product sales, you can add the region and fiscal time dimensions to view product sales figures by region and time periods such as financial quarters. This action is necessary because you use kpis in scorecards to measure progress and performance over time. This course introduces you to kpi and scorecarding concepts, followed by detailed information on how to create both kpis and scorecards employed in the development of a strategy management plan. How to use kpis obiee online training tutorial firebox training. It also indicates cause and effect relationships between objectives and other objectives or kpis with connecting lines. It can also be used to automatically trigger alerts to specific users using obiees agent mechanism when kpi target values reach critical status levels. Obiee 11g scorecard error odbc driver returned an error.
Measuring results with scorecards and kpis using oracle bi. Obiee 11g creating key performance indicators kpi one of the important new feature is performance management objects in the new version of obiee 11g. Epm on premise hyperion obiee obiee 11g oracle oracle bi apps. A kpi is a visual indicator that quickly shows how actual measures are performing against targets. In the broadest sense, a kpi provides the most important performance information that enables organisations or their stakeholders to understand whether the organisation is on track or not.
Lift and shift of oracle biapps artifacts to oracle analytics. How to work with obiee 11g kpis and a kpi watchlist before you start. Download the rpd from the path technetworkissuearchive201010novo60bi170650. Sep 02, 2012 defining kpi, kpi watchlist and scorecard in obiee 11g aim. Mar 19, 2015 scores are consumed by applications such as oracle bi scorecard to drive cross kpi standard comparisons. You can also select variables or instruct the kpi to use the scorecard point of view. An overhauled and simplified user interface, integration of the oracle fusion middleware mapviewer. Kpis and scorecards using obiee 11g mark rittman, rittman mead. If you plan to use oracle scorecard and strategy management, it is a best practice to implement at least one time dimension in the oracle bi repository you are using for your kpis. Oracle business intelligence enterprise edition 11g introduces several new features that will be of interest to organizations using the previous 10g release of the product. Obiee oracle business intelligence enterprise edition. Apr 30, 2016 defining kpi, kpi watchlist and scorecard in obiee 11g.
Because kpis cannot be viewed directly from the catalog by end users, kpi watchlists are one of the ways, along with outputting a kpi to an analysis and including a kpi on a scorecard, that kpis are distributed to end users. Obiee scorecard and strategy management obiee step by step. Obiee 11gr1 kpis overview kpis are the building blocks of scorecards, and can be defined in the web catalog require an actual and target value, and can be linked to a time period for trending permissions and privileges associated with them read, write, create etc actions and agents can be linked to kpis for actionable intelligence. In the add kpi dialog box, you select any dimensions that are prompted in the kpi. Design and develop the interactive oracle bi dashboards. May 06, 2014 something related to enabling trending in the kpi is a top suspect. Create objectives assign kpis to objectives create strategy hierarchy define relationships between objectives kpis to begin with, lets create a scorecard. Kpi in obiee 11g datawarehouse architect kpi in obiee 11g kashif m. Creating the kpis and the kpi watchlists oracle business. This application gives you access to interactive dashboards, interactive queries. Usage of key performance indicators in obiee welcome to my.
Oracle business intelligence enterprise edition obiee 11g. Scorecards allow you to model the objectives and initiatives that comprise your corporate strategy, evaluate their performance by assigning kpis, and determine. Defining kpi, kpi watchlist and scorecard in obiee 11g aim. Jul 16, 2010 another new part of obiee 11gr1 that you may have seen at the launch in london, is a new product called oracle scorecard and strategy management. Kpis can be located in a scorecard s strategy tree or initiatives.
We are planning to create 2 kpis sales performance and margin maintenance. Now when i login to the application as weblogic i can access kpi s with. Mar 25, 2015 to assess your business performance, you must define success via key performance indicators kpis, benchmark metrics against which current performance can be measured. You can also open a kpi from a scorecard by using the catalog pane for scorecard. May 24, 2012 we will demonstrate how to create key performance indicators kpis. Hi all, while implementing usage tracking in obiee 11g,i came to know that the given default rpd and catalog is a bug in 11. Kpi is used to analyze dashboard to allow a user to view kpi performance and drill into the details to understand why a kpi value may be off target. Kpi s are typically tracked over time as a way to monitor performance and drive business decisions to help.
Obiee training obiee 11g kpis key performance indicators. Scores are consumed by applications such as oracle bi scorecard to drive cross kpi standard comparisons. Obiee 11g scorecards and strategy management gerardnico. You specify targets for a specific time frame, and kpi uses. I am particularly interested in the custom view as it opens up new possibilities of visualizations. This tool was developed to loosely resemble a balanced scorecard approach, but it is completely adaptable to any performance management methodology. Oracle business intelligence enterprise edition obiee 11g udemy. The purpose of this course is to gain expertise in the field of business intelligence using obiee 10g and obiee 11g. Its delivered as part of the overall obiee 11g technology stack, but like siebel marketing before it its likely to be separately licensed and not an automatic part of an obiee 10g upgrade. One of the latest features within edition 11g is scorecard and strategy management ossm.
Collaborate11 kpis and scorecards using obiee11g slideshare. This week i wanted to extend that scenario and create scorecards in obiee 11g. The 11g upgrade accelerator shows you the path of using the new improved bi platform, helps you upgrade the existing content and introduces you to new exciting features. Verify that use pointofview is selected for all of the dimensions of the revenue kpi, and then click ok.
Take advantage of the latest olap analysis, mapping, kpi, and scorecard features. Oct 24, 2014 obiee training obiee 11g kpis key performance indicators and kpi watchlist tutorial duration. Kpi s are typically tracked over time as a way to monitor performance and drive business decisions to help improve upon that performance. We will demonstrate how to create key performance indicators kpis. Kpis can be located in a scorecards strategy tree or initiatives. A kpi or key performance indicator is a measurement of a particular business process which is compared against specific goals and objectives of an organization.
Balanced scorecards in power bi microsoft power biblog. A strategy map shows how the objectives that have been defined for a scorecard and the kpis that measure their progress are aligned by perspectives. This course is primarily for business analysts or programmers utilizing obiee for analysis. All 3 kpi s are identical, except for the states step. Obiee 1measuring results with scorecards and kpis using. This course opens the doors of opportunity as obiee developer, obiee administrator, obiee architect and many more.
Jul 23, 2012 creating scorecards in obiee 11g posted by rajat rakesh on july 23, 2012 last week i had created a post for creating kpis. Some users, including executives, really wanted a tabular, scorecard style of kpis. Obiee 11g oracle business intelligence enterprise edition reports and dashboards livelessons introduces students to the querying and analytical capabilities of oracle analytics using the web interface. Kpi and scorecards in obiee 11g bi bi just another. Bicgs obiee task force provided an overview and demo of the new scorecard. An oracle 11g database that is installed and running. The recent release of oracle business intelligence enterprise edition 11g provides a means of defining kpis within your business intelligence bi metadata and of defining scorecards that make use of those kpis. Actual values are the current state of the measured performance for example, the number of units shipped or the service requests closed. Obiee 11g creating simple and self sustaining kpis kpis. I know that in defining watchlists and scorecard one can use the pov bar, and indeed it works perfectly, but when i put the watchlist or scorecard on a dashboard its not possible. It also explains kpi evaluation, dimensions and pinned dimension values, and target settin. Gain knowledge on concepts of data warehouse and business intelligence. Create and work with kpis, scorecards, and action links.
Scorecards allow you to model the objectives and initiatives that comprise your corporate strategy, evaluate their performance by assigning kpis, and determine and display overall performance. Note that you can modify the label or pinning for a particular usage of a kpi within a scorecard strategy or initiative tree. Oracle business intelligence suite enterprise edition wikipedia. Oracle business intelligence 11g action framework explained. Nov 21, 2011 kpi in obiee 11g can be used an analysis dashboard to allow a user to view kpi performance and drill into the details to understand why a kpi value may be off target. A threshold is defined or derived from a range of values against which a kpi is assigned a status. Obiee credentials with the appropriate level of permissions. Kpis and scorecards using obiee 11gmark rittman, director, rittman. Obiee scorecard and strategy management obiee step by.
Overview of creating analyses and dashboards in obiee 11g pdf. Build key performance indicators and scorecards in your business intelligence metadata with oracle business intelligence enterprise edition 11g. Kpis are measurements that define and track specific business goals and objectives that often roll up into larger organizational strategies that require monitoring, improvement, and evaluation. Measuring results with scorecards and kpis using oracle bi ee. Were going to create key performance indicators and watchlists in the first recipe. Later we will be using these kpis to create a scorecard. Oracle business intelligence enterprise edition 11g. An analysis that is created from a kpi can allow the user to drill into different levels of details based on the kpis dimensions.
Use enterprise manager to enable and disable cache. Dear readers, obiee 12c is very rich in ui in key features like visual analyser, enhanced map viewer, hd mobile development,integration with hyperion epm etc. Kpi in obiee 11g can be used an analysis dashboard to allow a user to view kpi performance and drill into the details to understand why a kpi value may be off target. Kpis are typically tracked over time as a way to monitor performance and drive business decisions to help improve upon that performance. Power kpi matrix supports an unlimited number of kpis in a single visual, along with.
May 20, 2014 iware logic resources services resources webinars implement new obiee 11g user interface through kpi and scorecard in this webinar, we will cover the following. To assess your business performance, you must define success via key performance indicators kpis, benchmark metrics against which current performance can be measured. Its a long overdue and lets see how the world receives it. Building blocks of scorecards you can create and assign kpis to measure the progress and performance of your organizations strategies. Kpis of any organisation is the variance of actual facts versus target facts. When using microsoft active directory as the identity store and also using the virtualizetrue option as described in the bi security documentation, the patch for bug 20188679 must be downloaded and applied. Key performance indicators kpis help organisations understand how well they are performing in relation to their strategic goals and objectives.
Properly installed and configured oracle business intelligence 11g obiee tools. As part of our ongoing obiee training curriculum tutorials we will discuss an example of how to use kpis in an obiee 11g analysis to assess your business performance, you must first understand how success is. Implement new obiee 11g user interface through kpi and scorecard. Oracle business intelligence enterprise edition 11g obiee is an allinclusive solution to meet your business intelligence bi needs. The sixth chapter in the bicg webinar series to focus on oracle bi 11g. We create another measure called brand revenue which is a duplicate of revenue in the repository rpd. This column shows how kpis are defined in this release and how they can be used to create a basic scorecard that measures progress.
In this way you can assess current performance at a glance. In this objective, added all 3 kpi s a few times, and in different order. Defining kpi,kpi watchlist and scorecard in obiee 11g geek ally. Besides the strategy tree obiee offers the possibility to create and cause and effect or fishbone chart. Oracle business intelligence obiee training tutorial. Upgrade to oracle business intelligence enterprise edition 11g. Otherwise some or all users may be unable to login to oracle business intelligence. Quickly define kpis and scorecards that use them oracle.
Obiee tutorial videos and books oracle business intelligence 11g. These kind of features were not implemented in the previous version. This obiee training program is a mix of practical and theoretical components. When oracle released the oracle scorecard and strategy management ossm component of the oracle bi foundation suite there were few questions and even less answers about the product offering than i think most oracle bi aficionados would have expected. Nov 27, 2012 another new part of obiee 11gr1 that you may have seen at the launch in london, is a new product called oracle scorecard and strategy management. Ossm gives the user an interface to store and track all of their performance data. Oracle biee 11g reports and dashboard hands on vlamis software solutions is one of the most respected training organizations in the oracle business intelligence community because our training programs and materials are informed by our experience leading implementations in many of the worlds foremost corporations. Apr 21, 2011 key performance indicators obiee 11gr1 provides support for kpis kpis are defined using presentation services and are stored in the web catalog requires measures for actual and target, thresholds for good, bad etc kpis can be dimensioned time, customer, product etct. Obiee training obiee 12c certification online training. Lift and shift of oracle biapps artifacts to oracle analytics cloud. If we want to keep it accountable and to have early warning signals about potential problems, we need to have a welldefined and balanced set of indicators.
The course is intended for a businessoriented audience who want an understanding of these components, which will enable them to utilize the newly. For this, we developed a second custom visual called power kpi matrix. After you build and save a kpi watchlist, it is stored as a catalog object and can be added to dashboards and scorecards. It also explains kpi evaluation, dimensions and pinned dimension values, and target settings. In the related items part drag the causes, effects and intiatives. Obiee 11g chart slider, obiee 11g chart zoom, obiee 11g disappointments, obiee 11g launch event, obiee 11g live pivoting, obiee 11g new features, obiee 11g new ui, obiee action framework, obiee bi publisher clustering, obiee bi search, obiee essbase clustering, obiee scorecard and strategy management. One problem ive run into is fairly simple in definition. Before building your obiee 11g analysis report, you will need.
665 396 740 526 1165 571 1275 98 559 1109 982 946 875 642 934 393 931 182 979 944 1063 552 1447 1486 182 1464 712 1442 1079 1159