We want to know what advantage we can have by migrating to obiee 11g and are there any new features we can use to improve the way our current reports are running. Download the obiee 11g versionfrom here or from oracle e. Creating an oracle bi presentation layer from imported olap cubes 3 table 1. Obiee tutorial a beginner guide by obiee professionals. Q18 mention the various layers in the repository of obiee 11g. This is the layer of the logical business model that is accessible for the clients through a structured query language sql better known as the logical sql presentation layer is often describe as the business model in the literature to include the complete logical business model the presentation layer is the appropriate layer in which to set user permissions. Creating and maintaining the presentation layer oracle help center. I this video you can see how presentation layer objects displays when you login in to obiee 12c analytics. Today i was working in an oracle business intelligence enterprise edition obiee 12c rpd version 12. In previous article we got idea of basics of rpd development as how to develop rpd physical layer. The presentation layer exposes the business model objects in oracle bi user. So if we want to change the current running rpd and catalog in obiee. Business model mapping layer will convert actual business model to technical model and using this layer. The role based views also save as a security measure as they hide the complex.
It contains information about the physical data sources. To nest the presentation folders, login to obiee rpd and look at presentation layer. The presentation layer holds the subject areas, presentation tables, and. In previous article we have studied the development of physical layer as well as development of business model mapping layer. This layer is used for importing data creating aliases building physical joins setting up connection pool and its properties enabling disabling cache for individual table 2. I only want to put the original dimensions in the presentation layer not the alias.
You will build it offline and then make it active at the end. How presentation layer looks like in obiee 12c analytics. If you decide to export logical keys, make sure that the logical key columns exist. You will learn difference between obiee 11g and obiee. Renaming presentation tables in obiee 12c performance. If wls is integrated with other ldap products, then users and groups needs to managed using the interface provide by the respective ldap vendor new in obiee 11g application roles and application policies are managed in oracle enterprise manager fusion middleware control new in obiee 11g. A default obiee 11g installation includes the sampleapplite rpd file and web catalog. Obiee how to enable metadata dictionary in presentation layer. This chapter explains how to use the oracle bi administration tool to create, edit, and maintain objects in the presentation layer of the oracle bi repository. Create presentation hierarchiesto create hierarchies in presentation layer 1.
Obiee repository development basics presentation layer. Obiee has threetier architecture with a presentation server, bi server and. Obiee best practices in presentation layer blogger. This tutorial covers the creation of oracle business intelligence enterprise edition obiee metadata for access to oracle database 11g olap option data and calculations by using the oracle olap 11g analytic workspace manager plugin for obiee. Here are the steps to deploy samplesales rpd on your machine. Obiee 10g11g presentation layer gerardnico the data. The users should be downloaded from the weblogic server.
Introduction oracle fusion applications have a built in business intelligence. Obiee 10g11g presentation layer gerardnico the data blog. Physical layer joins do not specify inner or outer. In earlier versions of obiee we dont have an option to audit teh security permissions applied at rpd level. Doubleclick the sample sales subject area in the presentation layer to open the subject area dialog box. Please open the rpd in online mode and see which subject area is displayed in presentation layer. You have created the initial sample sales business model in the repository. The bmm is really the heart of an obiee application.
It is recommended that you rename the business model layer. Most common and simple method is by dragging business model in bmm layer to presentation layer. Most common and simple method is by dragging business model in bmm layer to presentation layer and then making changes to it as per requirement. The presentation services and oracle bi server are part of obiee. Reorder the presentation tables so that customer regions appears after customers. Obiee repository development basics business model. The diagram above shows obiee application layer architecture. Avoid the use of aliases when a new presentation column is created. It provides a convenient way to transform physical names to userfriendly names. Download the obiee 11g versionfrom here or from oracle edelivery site and extract all the four disk into a single folder and click setup. Presentation layer provides a customized view of business model to the users. Will there be any issue in our current reports if we migrate to 11g. This is the layer of the logical business model that is accessible for the clients through a structured query language sql better known as the logical sql presentation layer is often describe as the business model in the literature to include the complete logical business model the presentation layer is the appropriate layer. Creating and maintaining the presentation layer 11g.
The presentation hierarchy object must be located within a presentation table, unlike in the business model and mapping layer. However, a different name can also be given by unchecking use logical column name and the display custom name in the presentation. Export obiee rpd documentation data lineage from the. Uploading the repository oracle business intelligence 11g r1. Physical layer if you create a database object manually, you also need to manually set up an associated connection pool. All the objects in this layer depend on the bmm layer objects. Design tips for the obiee 11g repository design presentation layerin the presentation layer, you can do the following. If we understand the various places in rpd and webcat where we can formulate the underlying report query then we can minimize our design efforts. Obiee11g building logical dimension hierarchy slideshare. Renaming the presentation layer columns will reset the use logical column name property to false. The linage is pretty comprehensive and covers everything from presentation column to physical database column. Build presentation layer in obiee 12c datawarehouse.
In this article i will try to explain how to develop business model layer which is heart of obiee reporting. Obiee best practices in presentation layer march 06, 2012 1. To create a presentation hierarchy, you can drag a logical dimension hierarchy from the business model and mapping layer to a table in the presentation layer. Combining obiee answer requests in presentation layer. Creating an oracle bi presentation layer from imported.
Export bi catalog captions from command line in obiee 11g. Sub folders nesting folders in obiee 11g answers obiee. Use parent folders and sub folders to group facts and similar dimensions together. In the presentation layer, rightclick the sample sales subject area and select new presentation table to open the presentation table dialog box. Presentation layer enables the customization of the business model. Build presentation layer in obiee 12c please note that you are using the manual method for creating presentation layer objects. The most common way to create the schema in the physical layer. Creating obiee metadata for olap 11g cubes purpose. Presentation layer exposes only data which is meaningful to the user.
Building the presentation layer of a repository in obiee. In this article we will study the development of presentation layer and its usages. Subject areas are used in presentation layer provided by oracle bi presentation services. Home middleware oracle fusion middleware online documentation library, 11g. Building the presentation layer of a repository in obiee tekslate. Manage security, obiee 11g, order by in obiee, physical layer, presentation. How to create a basic obiee 11g repository firebox training. Show fewer columns than exist in the business model and mapping layer. You can export logical keys to odbcbased query and reporting tools. Sorry for the convenience, and happy download and installation using obiee. The presentation layer is the exposed layer to odbc query clients including the obiee presentation services component.
The presentation layer exposes the business model objects in oracle bi user interfaces so that users can build analyses and dashboards to analyze their data. Best practices of the presentation layer oracle business. Rename wizard in obiee datawarehouse architect rename wizard in obiee. The presentation layer provides a way to present customized, secure, rolebased views of a business model to users. Often, the obiee repository development is run in one phase and any presentation layer changes and creating new obiee requests answers is done in the next phase. The presentation layer is the appropriate layer in which to set user permissions. Presentation layer, testing rpd, obiee 12c architecture, upload rpd into obis. Obiee design and development best practices perficient blogs. The physical layer is the layer of the logical business model where you define the physical data model of your data source.
While we can do a lot of things in obiee 11g, i see the tool as a query generator. Best practices in presentation layerobiee obiee by. Obiee presentation layer in obiee tutorial 26 march 2020. The presentation layer exposes the business model objects in. Hi, can anyone tell me what new features obiee 11g is having. For multidimensional data sources, if you create the physical schema in the physical layer of the repository, you need to create one database in the physical layer. For simple models it is also possible to drag objects from the bmm layer to the presentation layer to create the presentation layer. This is an overview of oracles key bi product obiee, formally known as. Obiee how to enable metadata dictionary in presentation layer step1. Logical grouping of the columns in the presentation layer table is important like we should always place the measure columns in the fact table of the presentation catalog folder. You now create the presentation layer of the repository. The role based views also save as a security measure as they hide the.
602 964 1277 1539 1012 500 164 1353 617 35 1562 1379 419 1035 1027 1551 158 343 1386 1227 502 1071 504 30 1486 290 213 660 272 992 249 735 348 1201 1366 1177 939 1036 5 190 384 185 1175 1493 873 664 921 997