Where as in obiee 11g there is no briefing book reader and no. Java project tutorial make login and register form step by step using netbeans and mysql database duration. If your organization licensed oracle bi briefing books, you can store a static snapshot of dashboard pages or individual requests in one or more briefing books. Select the customize option and click add to briefing book. In 10g, the deliveries directory is a special directory used for data such as dashboard snapshots used by briefing books. Work with architecture, installation, configuration and managing obiee 11g. Oracle obiee 11g online training obiee 11 g training. The briefing book provides a way to see content offline, or share it with others. Add business model and at least one subject area 5. Obiee 11g create analyses and dashboards obi401 4 days.
The basic unit of organization for an obiee 11g system is called an oracle bi domain. The directory is called deliveries by default and is located in the oraclebidata\web\catalog directory. I tried doing it from the bmm layer by creating a dimension on the calendar year so that the link appears on the fy2008 etc. We can then download and share briefing books for viewing offline. Change the style and description of the dashboard add hidden named prompts to the dashboard and to its pages specify which links analyze, edit, refresh, print, export, add to briefing book, and copy are to be included with analyses at the dashboard level. This example configures a java script for the oracle bi scheduler that copies the results of an agent to another directory.
Obiee 11g em ports so the data source that we need to configure to connect the rpd in online mode should use 9514 instead of 9703. We can add content into briefing books by two ways. An obiee 11g briefing book is a collection of static or updatable snapshots of. Normally we will have the scenarios like to get data for last n no. Rather than this normal scenario if the user wants the same report but with the year and month prompts only instead of the calendar date. Last n monthsrolling months data by yearmonth prompt in. Click page options and select add to briefing book. To reorder content, click the move up and move down arrows. Use new briefing book button to create new book or select from drop down where do you want to add snapshot. I record all issues and finding in oracle bi, that i can refer back later, or others can use for troubleshooting. 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. Go to bin tab, click on add bin button next add values what ever thevalues you want to be a group.
Select the use a condition radio button and then click on create or browse. Creating links to dashboard pages working with briefing books what are briefing books. Working with oracle business intelligence briefing books. Helping teams, developers, project managers, directors, innovators and clients understand and implement data applications since 2009. Navigate to a dashboard in oracle bi interactive dashboards and then perform one of the following actions. Use this option to give authority to run an object, such as an action, agent, or a briefing book. Both functions aim is to define the bin bucket the specific data entry belongs to. First we have to check the privileges for the briefing book.
Multipage briefing books have paging controls and are wellsuited for presenting information to others. Right click on the briefing book from dashboard and select further option to edit or download the briefing book. How can the end user assign the values of revenue into groups he invents and then count the number of. Click the cancel button to return to oracle bi interactive dashboards. Oracle bi briefing books are used to storecapture a series of static images of.
Briefing books in obiee 11g datawarehouse architect. Edit the dashboard, and select tools, then page report links. Briefing books provide a way to archive the information in a dashboard and can be saved locally. Navigate to the briefing book in the selection pane in oracle bi answers, and then click it.
We developed this approach in the following procedure i myself worked on sample sales. Click on administration a manage privileges under security 3. Use new briefing book button to create new book or select from drop down. Briefing books provide a way to archive the information in a dashboard and can be saved locally on a users desktop. This guide will take you through the basics of setting up an obiee 11g analysis and adjust the display to make the results more. To add the results of an individual analysis to a briefing book. About the table of contents in a pdf version of a briefing book. Obiee grouping measures and counting group members few days ago i was asked for something like this. Using bins in o biee posted on december 8, 2010 by naveen kumar if any one want to group markets in a region and their sales. Obiee send content to ftp server network folder oracle. The purpose of this course is to gain expertise in the field of business intelligence using obiee 10g and obiee 11g. You will create kpis and add them to the dashboard, as well as use oracle bi briefing books. How to create an obiee 11g analysis the data you store in your oracle database is only useful if you can retrieve and display it in a helpful format.
Upgrading oracle business intelligence from 10g to 11g. This post can help people who are new to obiee 12c to easily find the paths. If we have a licensed version of oracle bi briefing books, we can store a static snapshot of dashboard pages or individual requests in one or more briefing books. Type a name and a description for the briefing book, and then save the briefing book. The oracle application layer or popularly known as the fusion middleware layer is built upon a common domainbased architecture that can support as a set of common core functionality like security, scalability etc across various oracle products. So, any process that can be called via java can be directly called from obiee 11g as well. In this post we will know how to create the sample data model with the dsn oe which we have created in data sources in the previous post create data source in release of obiee 11g, oracle bi publisher introduces the data model editor, a graphical user interface for building data models within the bi publisher interface. Briefing books have the same look and feel as a dashboard page. It allows that content to be viewed by anyone with briefing book reader software. The right pane displays the contents of the briefing book. Use this option to give authority to change the objects permissions. Hadoop data lake a hadoop data lake is a data management platform comprising one or more hadoop clusters used principally to process and store nonrelationa.
Click page option and then click the add to briefing book button, available as 4 th option of page option in dashboard page. There are some issues in the obiee 12c installation as the default port should have changed in the dsn also after the installation. How to create an obiee 11g analysis obiee training tutorial. When using bins, obiee generates a custom case statement for us. Bi tools this location contains scripts to startstopstatus of the server. The diagram above shows obiee application layer architecture. In this course you will learn how to use the oracle bi presentation catalog and build obiee analyses. After im done creating all my bins, there is a checkbox at the bottom of the bins window where i can create a custom bin for all other values. Obiee briefing books reports the captured series of snapshots of oracle bi dashboards. To add the contents of the dashboard page to a briefing book. Includes briefing books reports that capture a series of snapshots of an oracle bi dashboard or report allowing the information to be viewed offline.
Briefing books in obiee 11g datawarehouse architect briefing books in obiee 11g kashif m. Pull two columns region and sales which will give you the sales in each andevery region. Essbase and epm integration improvements in obiee 11. When you download a briefing book in pdf format it is successful in some of your environments for example, in the development environment on the ms windows 2003 platform, but fails in other environments for example, in the. Create data source odbc bi solutions by shankha bhattacharya. A briefing book is a collection of static or updatable snapshots of dashboard pages, individual analyses, and bi publisher reports. This course opens the doors of opportunity as obiee developer, obiee administrator, obiee architect and many more. Upgrade obiee 11g to 12c march 8, 2017 by santosh bhairi in business intelligence as you may be aware, oracle released its latest bi techstack version 12c during october 2015 which is packed with abundant new enhancements and. We can achieve thisby using bin with out writing long case statements.
Obiee tutorial a beginner guide by obiee professionals. 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. Obiee 11g biplatform schema gerardnico the data blog. By default obiee 11g agents do not have the option to deliver the content to an ftp server or to a network folder to accomplish this purpose, we can use a server script which will allow us to take the generated file from obiee and send it to a ftp server. Over time, you can scaleout this weblogic domain to include additional managed. You can define the front page of pdf briefing books by editing toctemplate. Installation of obiee 11g software setup and configure. How to schedule a report in obiee 11g using agents. Obiee 11g case insensitive search on dashboard prompt to make case insensitive search on dashboard prompt, follow below steps to c. Action framework of obiee 11g opens up direct integration with java. The briefing book provides a way to create snapshots of dashboard pages, view them offline, or share them with others. Organizing dashboard pages in briefing books oracle help center. We can download briefing book as pdf or mhtml format. How to create a basic obiee 11g repository oracle bi 11g training duration.
1140 768 744 840 803 447 93 1067 225 913 1384 821 628 893 541 1085 395 1447 319 1184 57 1164 352 149 92 424 710 305 172 720 834 654 162 114 948 708 672 86 1181 1102 666 610 110 1189 340