Execute the utility through a launcher script, datamodel. I was among the people who were dancing and singing after finding out some of the obiee 12c new features. Download the rpd and supply the repository password on the command line. This document assumes that both obiee 11g and obiee 12c environments are installed with configured services. Migrating from oracle business intelligence 11g to 12c. We should be using weblogic scripting command uploadrpd to upload repository to oracle bi server. Power bi desktop connection to obiee rpd microsoft power. We have seen lot of customers asking how to deploy samplesales rpd. Administration ii training is a continuation of oracle. In order to install the obiee 12c client tool, you have to download it. There are some issues in the obiee 12c installation as the default port should have changed in the dsn also after the installation. Rpd deployment process in obiee 12c data science and. Obiee repository contains all metadata of the bi server and is managed through the administration tool.
Obiee 12c client tool installation learn it with examples. The utility has a few switches which youll need to enter to tell it what it needs to know to downgrade the rpd file. The rpd file is password protected and the whole file is encrypted. This video guides you through the process of using a command line utility to uploaddownload rpd in obiee 12c. Trying to open online rpd from bi administration tool obiee 12c. Webbased rpd upload and download for obiee 12c 11 january 2017 on obiee, obiee12c, curl, web services, rpd, jquery, gui. When upgrading oracle business intelligence from a previous 12c release to 12. Copied from obiee 11g environment and upgraded 11g rpd to 12c using obiee 12c administration tool, then uploading the rpd in obiee 12c environment. You can edit oracle bi repositories using the oracle bi administration tool. See how to create a simple web page interface for uploading and downloading rpds in obiee 12c using the rest web service. But when i tried to use it and upload a repository from my developer workstation to a server, ive faced two issues. This is not compatible with the rpd files created in admin tool of obiee.
Trying to open online rpd from bi administration tool. In 12c, em does not have any option for deployments of rpd. Here is the way in obiee 12c to open the repository rpd in offline mode. There is a difference opening rpd in onlineoffline mode. Hi, i was trying to connect power bi desktop tool to oracle obiee 11g rpd via odbc connection. Any changes to the rpd file can be done only in obiee. Sampleapplite rpd and catalog file for obiee 12c oracle. With architecture change in obiee 12c, the most commonly used files paths might be confusing in the early stages. A case study building financial report and dashboard using obiee part ithis is a 1st document in the series of building financial reports and dashboard taking essbase as datasource. Im looking at a possible script to automated the rpd deployment from one environment to another dev,test,prod. The inability to ftp the current rpd down from the server and use it for further modification. There are a few changes in the way it is installed compared to the previous 11g releases. This is required for the online opening mode of rpd repository file.
Only the oracle bi administration tool can create or open rpd files and bi administration. So the data source that we need to configure to connect the rpd in online mode should use 9514 instead of 9703. One of the most interesting features of obiee 12c is an ability to downloadupload a repository with commandline utility without using oem and the best part of all. Obiee 12c open rpd online november 30, 2015 by nick passmore. How to install and configure obiee 12c peak indicators. The obiee repository database, known as a rpd file because of its file extension, defines the entire obiee application. Its proven architecture and common infrastructure producing and delivering enterprise reports, scorecards, dashboards, adhoc analysis, and olap analysis provides a rich enduser experience. This post is about installing and configuring obiee 12c with detailed stepbystep instructions linux x8664 in this case. Manual deployment of obiee 11g rpd obiee by shiva molabanti. For those who have recently upgraded to oracle bi 12c, things have moved around a bit. Download online rpd without admintool in obiee12c data. Commands to deploy rpd and download rpd log file location for uploadrpd and downloadrpd command utilities. This post is to highlight the command line utilities for downloading and uploading rpd. This contains the data models, data source details, custom calculations, dimensional details and so on that bring.
It contains all the metadata, security rules, database connection information and sql used by an obiee application. It is used to store information about the application environment such as. Use the downloadrpd command to download the repository used by the service instance. The required system odbc dsn has not been created for the oracle bi server. The software download took around 2 hours really bad home internettook rpd upload and download for obiee 12c 11 january 2017 on obiee, obiee12c, curl, web services, rpd, jquery, gui. Obiee 12c download and upload of rpd in obiee 12c it is no longer possible to upload an rpd from enterprise manager. I am using obiee 12c which is installed on different server and i am trying to open the deployed repository in online mode from my biadministration client tool but not able to open, i was also. For example, the size of the repository file can be too large for fusion middleware control to handle. 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 as the rpd. Downloading rpd in obiee 12c obiee training youtube.
I followed the steps mentioned in the below link and downloaded the rpd. Is it possible to upload a metadata repository rpd via enterprise manager fusion middleware control. Here are the steps to deploy samplesales rpd on your machine. P is the rpd password of the source rpd you wish to downgrade. Rpd deployment in obiee 12c server is unlikely different from 11g. This video tutorial shows you how to upload rpd in obiee 12c. Please click the like button if you find this blog helpful. Obiee 12c has moved away from em to script based utilities. In order to create, modify an rpd you have to install the obiee client tool. Obiee 12c open repository rpd in offline mode youtube. In obiee 11g, we used to run the rcu setup first and then obiee 11g setup. The correct an proper method to migrate a repository from 11g to 12c is to use the documented process. If you want to downgrade rpd version from 320 to 308 also, you can follow the below steps.
Ive change the connection information in our new obiee 12c rpd to connect back to the 11g system. Queue will hold the message until the receiver is ready to receive the message. In earlier versions of obiee we dont have an option to audit teh security permissions applied at rpd level. O is the target name and path for the downgraded rpdv is the rpd version to downgrade to. Only include this option when you are running the command from a client installation. Steps for converting the obiee 12c rpd to a xml file linux step 1. The bics subscription is bundled with a singleschema service. The compare dialogue must be used with admin tool opened. To download an rpd file for editing you need to use a new utility called datamodelcmd probably. Obiee repository can be accessed using the following path. Business intelligence server enterprise edition version 12.
Under 11g the current or live rpd kept the filename as selected from the file system with sequence numbers appended to the end. Here we setup obiee 12c to open the repository rpd online. This post details the steps needed to migrate existing obiee 11g 11. The enterprise manager deployment tab to upload a repository has been replaced with one commandline utility, datamodelcmd. In this session, i will describe how to compare rpds with the compare dialogue. Open the command prompt and type cd \to change the directory and press the enter. Obiee 11g administration fails to start on windows 64bit operating system. Hope this quick overview of how to download and convert the rpd file to xml in obiee 12c was helpful. Obiee 12c uploadrpd and downloadrpd log file oracle. This video tutorial explains you how to download rpd in obiee 12c. Has anyone ever worked on such a script on a windows based platform.
Compare the mud rpd before and after the modification open your fixed mud rpd. A default obiee 11g installation includes the sampleapplite rpd file and web catalog. But you might encounter specific situations in which you must upload the repository using a different approach. In general, the recommended approach for uploading the metadata repository is to use the repository tab of the deployment page. In short, we have the 11g artifacts running on a new 12c system, and the 12c system is using the 11g systems data sources. There is a slight change between 11g and 12c setup. The feature i liked the most was a scripted deploy of an rpd file from a developers computer. Obiee is a well established product, having been around in various incarnations for well over a decade. About the oracle business intelligence migration process. Business intelligence suite enterprise edition version 12. In obiee 12c we cannot simply ftp the current rpd from the server and also there is no deployment screen in em console to re upload it. Uploading repositoryrpd in obiee 12c obiee training youtube. How to download rpd file from oracle business intelligence 12c. How itll go down upgrading obiee 11g to 12c red pill.
Im trying to connect to the repository for obiee using an odbc connection and the list of subject areas appears to load in power bi, but i am unable to load any data into power bi in order to make visualizations and reports. Iunder the covers of obiee 12c there are still a lot of similarities to obiee 11g and one of those is the rpd repository metadata file. Downloading and uploading rpd is different in obiee 12c from obiee 11g. There is a new command line script for downloadinguploading rpd files to the service instance named datamodel cmdcmd. Installation and configuration obiee 12c how to uninstalldeinstall obiee 12c in linux.
Downloadrpd and uploadrpd commands write the repo obiee 12c. Download the obiee 11g versionfrom here or from oracle edelivery site and extract all the four disk into a single folder and click setup. The oracle bi repository rpd file stores bi server metadata. Obiee 12c open repository rpd in offline mode duration. In order to upload the rpd file created in admin tool of obiee, a subscription to a. Admin tool reads the oracle bi server rpd in online mode. Here are some useful file locations in case it helps.
When the oracle argus insight rpd is opened in online mode, change the connection pool settings, as follows. Download the rpd and supply the repository password on the command line with the w parameter, or omit the w parameter and enter the password when prompted. Obiee i about the tutorial oracle business intelligence enterprise edition obiee is a business intelligence bi tool by oracle corporation. Earlier this week i started on the task of installing obiee on my windows machine for the first time ever. When configuring the obiee admin tool, so you can open the rpd online with obiee 12c, the steps are the same as obiee 11g, however the port number you need to configure your odbc driver is different. But when i try to locate the rpd it is not present in the mentioned location. Obiee rpd automation from one environment to another. This post can help people who are new to obiee 12c to easily find the paths. Once the changes are made the rpd file can be migrated to bics again. The metadata defines logical schemas, physical schemas, physicaltological mappings, aggregate table navigation, and other constructs. Now i got chance to write for download rpd from obiee 12c. But in obiee 12c, we will the rcu first and obiee setup after that.
1107 396 77 199 500 228 1428 1268 281 1542 1024 1557 1278 167 611 988 711 1224 277 941 750 747 1239 38 20 502 1161 1326 844 425 1454 1105 1103 840 770 313 1174 1321