Create a measure using the periodrolling function in obiee rightclick the f1 revenue logical table and select new object logical column. If you are new to obiee, you might be wondering what the term rpd stands for. Copy the rpd, and catalog files from obiee \ rpd \ and obiee \catalog folders to a machine where the obiee is installed. To put changes to production from development, in case of rpd you can make use of the option of merge that is present in the admin tool. It contains all the metadata, security rules, database connection information and sql used by an obiee application. On the general tab, name the new logical column revenue 3period rolling sum.
Thanks for informationflax it online training began online training for software program and sap courses. So the data source that we need to configure to connect the rpd in online mode should use 9514 instead of 9703. Most developers refer to rpd as the repository file, while some people refer to it as rapid file database. We can all the reports to single briefing book by clicking add to briefing book below of every report. For this walk through, you will need a physical database connection where you can create and populate tables and the obiee scheduler to schedule the automatic creation. Blog archive 2019 14 august 14 2018 8 may 1 april 7 2017 96. Create a measure using the periodrolling function in obiee. Sampleapplite rpd and catalog file for obiee 12c oracle epmbi. So if we want to change the current running rpd and catalog in obiee 10g we are opening the file and we are changing the rpd name and catalog name into these files. The single most important thing to know about the obi rpd. Obiee i about the tutorial oracle business intelligence enterprise edition obiee is a business intelligence bi tool by oracle corporation. Use the arrows or the menu options to navigate the content.
Now we are ready with the data lineage information. Obiee briefing books siebel analytics briefing book. Here is the curl script to call obiee web service and get rpd file. Dimensional hierarchies in obiee are used for a variety of important features in the rpd, many of which you may not know about. The following whitepaper describes techniques for monitoring and optimizing the performance of oracle business intelligence enterprise edition obiee 12c components. In the utilities dialogue box select repository documentation and click execute. Oracle business intelligence enterprise edition obiee is a business intelligence bi tool by oracle corporation. This avoids rewriting the same logic into your etl. In this article i try to explain you the concept of obiee rpd and basic development of obiee rpd. Deploying rpd and catalog in bi 11g in obiee 10g the current running rpd and catalog files are configured in two files called i and instanceconfig.
Bi solutions from different suppliers were combined to form the obiee suite. The bi applications rpd provides an excellent reference for obiee best practise. Obiee 12c infrastructure tuning guide oracle business. You can see the briefing book on dashboard look like a briefcase. Obiee stores its physical and logical schema in a repository. Introduction this document is for oracle business intelligence enterprise edition obiee developers and designers.
I used the samplesales rpd as my testing ground so the vertical dashboard prompts are not what i am truly using it for. Create or edit the agent to be used to deliver the briefing book. To upload the rpd back into obiee you need to reverse the process for downloading above. You can edit oracle bi repositories using the oracle bi administration tool. Obiee is a well established product, having been around in various incarnations for well over a decade. In previous articles i have explained the architecture of obiee,components of obiee, concepts of business intelligence. Q10 for reports, dashboards, rpd in obiee, mention the method of putting changes to production from development.
All the skeleton of the data modeling is done through server side. Obiee creating an obiee repository and importing a. Rpd deployment in obiee12c server welcome to my creative. To revert to a previous version, you must reupload the specific version of the repository to use. How to use a web service as a data source in bi publisher duration. Dec 07, 2015 so the data source that we need to configure to connect the rpd in online mode should use 9514 instead of 9703.
What is the use of rpd in obiee 11g datawarehouse architect. Business intelligence suite enterprise edition version 12. Obiee stands for oracle business intelligence enterprise edition and is the bi solution from database supplier oracle. We can directly give the table name in the hint or this obiee physical table id which can be obtained from by querying rpd. To access briefing books user needs to have access to answers access apart from briefing book related access. There are some issues in the obiee 12c installation as the default port should have changed in the dsn also after the installation. Use this option to give authority to run an object, such as an action, agent, or a briefing book. Obiee 12c rpd consistency warnings kevin tullyoracle dec 23, 2016 5. Manual deployment of obiee 11g rpd obiee by shiva molabanti. This blog contains the solutions and suggestions for obiee 11g dashboards, repository development, security and ui customization. Jul 29, 20 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. The reader of this document should have knowledge of server administration, oracle fusion middleware fmw, hardware performance tuning fundamentals, web servers, java application.
The rpd file is password protected and you can only open or create rpd files using oracle bi administration tool. This version number is incremented each time that the repository is uploaded. Obiee 12c uploadrpd and downloadrpd log file oracle epmbi. The content is refreshed whenever the briefing book is downloaded, or when it is specified as the delivery content for an ibot in oracle bi delivers. The pdf version of a briefing book contains an automatically generated table of contents. Obiee oracle business intelligence enterprise edition. Which package to use for an exalytics x34 release 2. Feb 08, 2017 37 videos play all obiee complete tutorials tutorials for beginners kubernetes for beginners docker introduction in 15 minutes duration. There is also online documentation from the oracle web site. But mostly well discuss the single most important thing to know about the rpd. I initially had an rpd configured and now have made some changes to some view in the oracle database added on column. Setup a obiee odbc connection that connects to obiee and dislays a list of presentation layer subject areas setup a data source in tableau which then brings up a sujbect area dsignated with a list of all of the tables and data objects within the subject area, which i can select into a report tableau workins using the odbc connection.
There are also other names like repository design, repository dictionary etc. Briefing books provide a way to archive the information in a dashboard and can be saved locally. Obiee design and development best practices perficient blogs. Related posts to what is the use of rpd in obiee 11g newer post older post. This video tutorial shows you how to upload rpd in obiee 12c. For follow briefing book navigation links, choose one of the following options. To deploy an obiee application, the rpd file must be uploaded to oracle enterprise manager. Sep 10, 20 dimensional hierarchies in obiee are used for a variety of important features in the rpd, many of which you may not know about.
After uploading the rpd, the rpd password then must be entered into enterprise manager. Obiee repository can be accessed using the following path. They acquired applications such as siebel, hyperion, peoplesoft and j. Explain about obiee repositoryrpd and how to modify. Exalytics and obiee which package to use for an exalytics x34 release 2. Enterprise data warehouse for telco giant rpd standards naming standards all object naming will follow business friendly conventions except the physical layer. To download the briefing book, click the get now button and specify the location in which to save it. Once thats done, click on tools and then utilities. For example, you can download a briefing book that contains all the brand revenue analyses for the year. Obiee 12c online mode rpd bi solutions by shankha bhattacharya. Bi working with briefing books in obiee description of briefing books and how to create, edit, download, etc. The oracle bi repository rpd file stores bi server metadata. I created a new measure on the booking line amount.
In excel, there are 2 things you can use to connect to odbc, under data tab, theyre called microsoft query and data connection wizard. To write a formula using case, select that and click ok. Briefing books also provide a way to archive the information in a dashboard, or they can be saved locally on a desktop. Briefing book navigation links will not be followed. Download briefing books in pdf format and print them. The briefing book provides a way to see content offline, or share it with others. When ever user desire to access snapshot he has to navigate to my briefing books then select which ever briefing book user needed. Open the command prompt and type cd \to change the directory and press enter. Add the group rpdadmins in the application role rpdadmin. Obiee will create, model and populate aggregate dimensions and facts based upon the intelligence you have built into the rpd. Exporting bi publisher report to pdf from the bip controls without a problem. The truth is that there is no definition for the abbrevation in any oracle. To expand this further, obiee uses this file to store the metadata, physical sources of data, access rules, aggregation rules, and all other relevant information that transitions the physical raw data into meaningful views to. We can then download and share briefing books for viewing offline.
In a nutshell, rpd is the name of the file extension that is used by obiee to store the details of the semantic model. The rpd file is password protected and the whole file is encrypted. Multipage briefing books have paging controls and are wellsuited for presenting information to others. Oracle sample application sampleapplite this will install the sampleapplite files sampleapplite. Creating a simple obiee report and a bi publisher report on an obiee dashboard page. The bi suite is the result of several of oracles acquisitions. Rpd column usage in reports obiee by shiva molabanti. If you use the rowwise initialization, the result of the query can be cached in the main memory cache of obiee server. Open the rpd admin tool in offline mode from the following path. Options s, n,ssl are needed when command is executed on client machines. The issue occurs when placing the bip report on a dashboard in obiee while downloading to briefing book at the dashboard page level.
There are still issues with obiee rpd merging that arent rectified by the 3way merge and so must be handled manually if and when they occur. We should be using weblogic scripting command uploadrpd to upload repository to oracle bi server. When the agent runs, the briefing book is delivered. In 12c, em does not have any option for deployments of rpd. Briefing books in obiee 11g datawarehouse architect.
Creating briefing book in obiee 11g december, 2012 briefing book. The contents of this blog are completely based on my work experience in obiee 11g. Rpd consistency check consistency check is a feature of the administration tool that checks whether a repository has met certain requirements, such as the following. A briefing book is a collection of static or updatable snapshots of dashboard pages, individual analyses, and bi publisher reports. All logical columns are mapped directly or indirectly to one or more physical columns. The obiee repository database, known as a rpd file because of its file extension, defines the entire obiee application. Repository is downloaded using datamodelcmd script with downloadrpd option. Online training is the better option to study software products as well as programs, which are sap modules, like sap hr, sap fscm, sap basis, sap abap, sap bw, sap ed admin, sap security, sap srm, sap scm, sap grc etc. Obiee 11g rpd file is too large obiee by shiva molabanti. Download briefing books to your computer in mhtml format and then share them for offline viewing. Obiee 11g download briefing book issue with bi publisher. Open rpd in online mode obiee 12c bi solutions by shankha.
The rpd file is the one of the obiee metadata that exists in physical file format, the other being the presentation catalog. Downloading rpd in obiee 12c obiee training youtube. Use the later version of obiee to do the comparison if you compare the two releases, and the two releases need different versions of obiee. It is used to store information about the application environment such as. In general, the recommended approach for uploading the metadata repository is to use the repository tab of the deployment page. In all of this time however, one thing it has never quite nailed is the ability for multiple developers to work with the core metadata model the repository, known. This launches the oracle bi briefing book reader application. The metadata defines logical schemas, physical schemas, physicaltological mappings, aggregate table navigation, and other constructs. In obiee 10g the current running rpd and catalog files are configured in two files called i and instanceconfig. Delivery content tab, click browse to select the briefing book.
Jan 31, 2017 rpd deployment in obiee 12c server is unlikely different from 11g. Jan 11, 2017 modern computer technologies offer us a lot of tools to build guis, but we wanted to keep it as simple as possible and because obiees front end is webbased, use of html for our rpd tool was the obvious choice too. But you might encounter specific situations in which you must upload the repository using a different approach. Obiee repository database is also known as a rpd because of its file extension. The obiee sample application is a great reference point. Uploading repositoryrpd in obiee 12c obiee training. This post will explore the fundamental reason for their existence and some specialized features that require their existence. The value sets the transaction isolation level on each.
Briefing books have the same look and feel as a dashboard page. Jun 10, 2014 this blog contains the solutions and suggestions for obiee 11g dashboards, repository development, security and ui customization. For example, there are two releases, lets say release 1 and release 2. Modifying an rpd under source control management updates many xml files and causes missing navigation space errors doc id 2267695. Obiee oracle bi server contacts data base using connection pool. Comment for what is the use of rpd in obiee 11g 0 comments post a comment. There is a little help available when you select that function to tell you about how to use it. Im new to obiee and looking for a way to update my repository file rpd i. The obiee rpd is where all the metadata related to a data warehouse or a data source is stored.
You will be able to login successfully for more detailed steps regarding creating user,groups,application roles. Export obiee rpd documentation data lineage from the. Jan 10, 20 obiee briefing books reports the captured series of snapshots of oracle bi dashboards. Obiee briefing books reports the captured series of snapshots of oracle bi dashboards. Please use the attached pdf to learn more about briefing books in bi. Avoid obiee rpd deployment mistakes by using admintool. I know that for many business intelligence implementation teams the extent of preparing an oracle business intelligence enterprise edition obiee repository for deployment is putting the repository rpd out on a network share. Now what can i do the get my rpd file updated with this change so that i can see this change i need to work on the rpd file through administration. 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.
One such example is that if a change has occurred on the physical layer which does not have any representations at all in the business or presentation layers, it may be lost during a 3way merge. Deploy this rpd and configure an empty webcatalog or you can use existed one through oracle fusion middleware em and restart all the obiee services. These standard guidelines may vary from project to project. Obiee repository contains all metadata of the bi server and is managed through the administration tool. Its proven architecture and common infrastructure producing and delivering enterprise reports, scorecards, dashboards, adhoc analysis, and olap analysis provides a rich enduser experience. The briefing book provides a way to create snapshots of dashboard pages, view them offline, or share them with others. The target environment has only 1 dashboard prompt, aligned vertically with over a dozen multiselects and. Click add to briefing book, locate the location of briefing book folder and assign the content types, navigation links, and description and click ok. By clicking on this the destinated reportdashpage will open in the same window or new window.
To export the obiee rpd metadata youll need to load the administration tool and open your rpd you can do this online or offline, depending on how you usually connect. It basically contains all the olap tables which are used to populate graphs and charts, the. Obiee 12c rpd consistency warnings oracle community. If briefing book navigation links were included, you can also click them to navigate. Only the oracle bi administration tool can create or open rpd files and.
145 863 997 222 698 596 953 1607 255 635 793 952 715 1314 893 1303 372 870 715 1372 254 346 1486 1292 370 186 656 772 1459 1155