Creating dashboards for usage statistics oracle business. The example in this video is from hcm but applies to all applications that use otbi. Sampleapp is a complete bi virtualized environment for showcasing oracle bi solutions. Briefing books have the same look and feel as a dashboard page. Select the customize option and click add to briefing book. You will create kpis and add them to the dashboard, as well as use oracle bi briefing books. Oracle bi servers repository is now ready to create reports regarding usage statistics. Download briefing books to your computer in mhtml format and then share them for offline viewing. How to create users and groups in obiee11g obiee by. Briefing books provide a way to archive the information in a dashboard and can be saved locally on a users desktop. The recommended sequence for creating logical levels is to create a grand total level and then create child levels, working down to the lowest level. Another type of view is the gauge view, which can be easily added to the analysis. Oracle bi publisher is fully integrated with obiee 11g, it can also be deployed separately.
The most common case is when the analysts are working with a dashboard, using prompts and find list of interest, they would like to investigate. Obiee briefing books reports the captured series of snapshots of oracle bi dashboards. The briefing book folder appears in the selection pane in oracle bi answers and oracle bi delivers. Click page options and select add to briefing book. Our development team has initially installed the sample app v511 for obiee 12c on their windows machines in order to implement all proof of concepts, including obiee 12c new features, to fulfill our client requirements.
Obiee tutorial a beginner guide by obiee professionals. Oracle business intelligence enterprise edition obiee is a business intelligence bi tool by oracle corporation. Go one step further than dashboards and create briefing books to present online or export to virtually any document form. Through the vm you can explore a working obiee set up the key things to examine are. It provides a fully selfcontained and configured environment with comprehensive out of the box collection of examples to demonstrate oracle bi capabilities, product integrations. Briefing books in obiee 11g datawarehouse architect. The directory is called deliveries by default and is located in the oraclebidata\web\catalog.
Oracle bi briefing books 1 oracle bi cluster controller 1. To add the results of an individual analysis to a briefing book. This type of view is also very useful to improve the visual appearance in the dashboards. It is used to read the information of the reports with the static and dynamic image of pages and requests. Creating a simple obiee report and a bi publisher report on an obiee dashboard page. Obiee 11g installation sample application version 825. Participants create kpis and add kpis to a dashboard. Joins in oracledifferent joins in oracle with examples. Oracle business intelligence enterprise edition 12c. A levelbased measure is a column whose values are always calculated to a specific level of aggregation. For the love of physics walter lewin may 16, 2011 duration. Briefing book table of contents page in obiee11g tips. I am using the sampleapp that is delivered with obiee 11g.
It must provide a broad set of capabilities, from selfservice monitoring of performance and processes to driving action based on insights. This book is also a guide that explains how to use an existing obiee 12c system, and shows end users how to create. Obiee 11g creating column selector and view selector views a column selector view adds a column selector to the results. If you want to create a new user and assign that user to a new group that you have created, do the following. It consists of a powerful backend engine with a repository and a highly customizable graphical web interface. In 10g, the deliveries directory is a special directory used for data such as dashboard snapshots used by briefing books. Finally, they explore the use of oracle bi briefing books. Obiee pivot measures the filter function obiee installation. The obiee full sample app is independent of the default sample app that comes with the obiee product. Right click on the briefing book from dashboard and select further option to edit or download the briefing book.
A column selector is a dropdown list from which users can dynamically change the columns that display in results. If your organization licensed oracle bi briefing books, then you can work with. Ill cover today a saved analysis and saved filter option and discuss the advantages of each. Obiee 11g download briefing book issue with bi publisher. We can add content into briefing books by two ways. Organizing dashboard pages in briefing books oracle docs. So, any process that can be called via java can be directly called from obiee 11g as well. Adding the gauge view oracle business intelligence 11g. Its proven architecture and common infrastructure producing and delivering enterprise reports, scorecards, dashboards, adhoc analysis, and olap analysis provides a rich enduser experience. In the select bi content for action dialog box, navigate to shared folders2.
Briefing books provide a way to archive the information in a dashboard and can be saved locally. Report are apprehended or stored from oracle bi dashboards as a book like pdf. How can i schedule briefing books to be sent via email periodically. How to create a basic obiee 11g repository oracle bi 11g. Adding a list of briefing books to a dashboard using briefing books with.
You will create oracle bi dashboards, including basic analyses and more advanced features, such as pivot tables, maps, graphs, gauges, navigation links, prompts, embedded content, and kpis key performance indicators on the. In this course you will learn how to use the oracle bi presentation catalog and build obiee analyses. The purpose of a join is to combine the data across tables. The briefing book provides a way to create snapshots of dashboard pages, view them offline, or share them with others. Enterprise business intelligence must give managers and staff much more than tools that access information. For example, a user can compare sales forecasts from an oracle crm. First we have to check the privileges for the briefing book. The pdf version of a briefing book contains an automatically generated table of contents. Use new briefing book button to create new book or select from drop down where do you want to add snapshot. Obiee 11g create analyses and dashboards obi401 4 days. Creating an analytics briefing book in oracle fusion hcm cloud. The briefing book provides a way to see content offline, or share it with others. Click the add to briefing book link that appears with an individual request on the dashboard. Download briefing books in pdf format and print them.
Were going to create some sample analyses and publish them in the dashboard for bi administrators. You can set up columns to measure countryrevenue, regionrevenue, and. Download the obiee 11g versionfrom here or from oracle edelivery site and extract all the four disk into a single folder and click setup. Creating an xml sample in obiee 11g datawarehouse architect. The issue occurs when placing the bip report on a dashboard in obiee while downloading to briefing book at the dashboard page level. In obiee 11g, every condition is evaluated on every row, and the last true condition will be the one applied to the data cell. In this video you learn how to create an analytics briefing book. Exporting bi publisher report to pdf from the bip controls without a problem. I just realized my previous post is probably overwhelming, buy the kimball book, and start reading it. Design and configured dashboards, analytics requests. This book will take you from one feature to another in a stepbystep manner and will teach how you can create effective business intelligence using oracle business intelligence enterprise edition. Use new briefing book button to create new book or select from drop down.
Click page option and then click the add to briefing book button, available as 4 th option of page option in dashboard page. Copy results to the file system using vb scipt windows. For example, a company might want to measure its revenue based on the country, based on the region, and based on the city. Users have the option to make briefing books updateable so they can be refreshed. If not add the user or role to give rights to access the briefing book. Were going to create another analysis that consists of. Oracle bi briefing books are used to storecapture a series of static images of. The administrator can modify the template for the table of contents so that the. Obiee 11g creating column selector and view selector views. Rowlevel security is where groups of users have access to a set of reports, but they all see different sets of data within the reports due to filters being applied silently in the background.
Download the obiee 11g example vm and get it up and running. For example, you can download a briefing book that contains all the brand revenue analyses for the year. Obiee pivot measures the filter function obiee installation configuration. You can define the front page of pdf briefing books by editing toctemplate. Navigate to a dashboard in oracle bi interactive dashboards and then perform one of the following actions. Obiee 11g sample app v107 gerardnico the data blog. Multipage briefing books have paging controls and are wellsuited for presenting information to others. So well start this weeks focus on obiee 11g security with the topic that most people associate with security around reports rowlevel security. Multipage briefing books have paging controls and are. After the vm is setup one of the first things to do is to create a shared folder between your local machine and vm.
Oracle bi briefing books are used to storecapture a series of static images of pagesrequests at server, allowing the information to be viewed offline and shareable with. Usage of briefing books in obiee 11g working with oracle bi briefing books oracle bi briefing books are used to storecapture a series of static images of pagesrequests at server, allowing the information to be viewed offline and shareable with others users or we can keep track of changes offline. Edit the dashboard, and select tools, then page report links. Upgrading oracle business intelligence from 10g to 11g. Click the cancel button to return to oracle bi interactive dashboards. Oracle business intelligence 11g r1 cookbook provides all the key concepts of the product including the architecture of the bi server. Obiee training obiee 11g kpis key performance indicators and kpi. Functional examples demo, select the order details analysis, and click ok. Obiee 11g analyses and dashboards training obi401 4 day request a class date. To add the contents of the dashboard page to a briefing book. Obiee 11g sample app v107 reporting and data access tools oracle business intelligence. Create the prompt using this screenshot as a guide.
Create dashboard prompts and assign to multiple reports created on different subject areas. Implementing obiee write back obiee online training tutorial duration. The briefing book appears in the current briefing books list at the save briefing book content page. Obiee 11g is a reporting tool that satisfies all the business requirements regarding complex reporting. Action framework of obiee 11g opens up direct integration with java. Explain about the types of hierarchies in obiee with example. Implement the change based on business requirements. Get to grips with the obiee 11g suite for analyzing and reporting on your. Type a name and a description for the briefing book, and then save the briefing book.
1206 1121 684 1195 1201 348 419 416 1216 1487 1556 1312 315 242 474 174 312 1605 1381 239 200 1469 936 1 1491 3 438 1187 849 1263 682 875 1179 270 1330 538