29 Ekim 2011 Cumartesi

Oracle Business Intelligence 11g - Dashboard Prompts

Dashboard prompt is very useful object which can be published in the dashboard in order to filter the data. In this example, I have created 3 reports and published them in the dashboard. Of course, the last object I’ve created is the dashboard prompt.  When the users accesses the dashboard for the first time, the default values are used like defined in the analysis. 













Once you select the new value from the drop down list, you can see that all the analysis which have a filter defined are effected. 
















28 Ekim 2011 Cuma

Oracle Business Intelligence 11g Performance & Strategy Management

It was again very busy days for last couple of months. To be honest, it was as usual. I had to deliver some trainings in different locations and I had a chance to deliver seminars in SIOUG 2011 and HROUG 2011. I deliver 2 sessions in SIOUG 2011 and they were about OBI 11g. I was invited to HROUG 2011 as a keynote speaker about applications and delivered a session about “Business Automation Features of  Siebel CRM”. Both of the events were really great and I’m very glad to a be a part of these events. In addition, I’ll be delivering 2 sessions in BGOUG 2011. 
As a result I want to share an article about the performance and strategy management feature of Oracle Business Intelligence 11g.
The first object type is the KPI. It is a measurment of business process and compares against a specific goal and it has a trending option which is optional. Also you can create “KPI Watchlists” to have a group of related KPIs and access all the details from a single user interface. 
Here is how a KPI looks like: 























And if you have multiple KPIs which is obvious then you can gain benefit of using KPI watchlists. When you create the KPI watchlist, you’ll be able to define the dimensionility and then add the KPIs that you’re interested:







Another important feature of Oracle Business Intelligence 11g is you have a solution to implement strategy management techniques like Balanced Scorecards.
First you create a Scorecard. 













Then it’s better to define the vision and mission documents by using the Scorecard Documents menu item:
Vision Document: A statement what your organization wants to be in the future. 
Mission Document: A statement specifies the key business goals and priorities that are required to achieve the vision.




















In order to manage the defined strategy, you’ll need to understand the performance lenses which are called “Perspectives”. There are 4 different default perspectives. New ones can be also created in the case of requirements. So these are the categories in your organization with which to associate initiatives, objectives and KPIs.
Financial, customer, internal processes and learning & growth are the default perspectives.













Maybe the most important object type in the scorecards is the “Objectives”.  Objectives are desired outcomes of your organization and can be organization based or organized for each department seperately.  KPIs are assigned to them so that you can easily measure its progress. They are created hierarchically. 













To monitor the progress in the scorecards, you can use “Initiatives”. They are time specific tasks like milestones:













There are 3 different types of objects more in order to support the scorecards:
1- Strategy Trees: They are created based on the objectives and helps to navigate to entire strategy in the scorecard and provides supporting information such as owners and KPIs.
2- Strategy Maps: A map shows how the objectives that have been defined for a scorecard area aligned by perspectives and indicates the relationship between the objectives.
3- Cause & Effect Map: It shows the cause & effect relationship between objectives. It helps identifying other objectives that impact the objectives and other objectives that this objective impacts.
Strategy Tree:













Strategy Map:













Cause & Effect Map:













And the big picture of the scorecard:






















23 Ekim 2011 Pazar

HrOUG 2011











I’ve attended to Croatian Oracle User Group event in Rovinj, Croatia for the first time. The conference was taken in place called Red Island very closed to Rovinj. You can only go by ferry.  It was great to attend this conference and I was invited as keynote speaker. My keynote speech was about Siebel CRM application. The main subject was about business automation features of Siebel CRM application.  You can access the details from:

http://www.hroug.hr/hr

SIOUG 2011








Just before the Oracle OpenWorld, I’ve attended to Slovenian Oracle User Group event which was in Portoroz like the previous year. I had a chance to deliver 2 sessions. Both of them were related to Oracle Business Intelligence 11g. One of the session was about the “Performance Management and Scorecards” and the other one was about “Creating Custom Actions in OBI 11g”.
Portoroz is also very nice city in the south part of Slovenia.

http://www.sioug.si/

Oracle OpenWorld 2011










I have attended to Oracle OpenWorld 2011. It was a great experience to attend different kind of sessions and meeting with colleagues from all around the world.
You can easily access the presentation details and the content itself from the link below. So even if you couldn’t have time to attend OOW 11, you still have an option to download the content and read them. The link is below: (from TOOLS and Content Catalog).
http://www.oracle.com/openworld/index.html
I’m also going to publish some pictures about my trip to San Francisco in the coming days.