When you create a new view, obiee looks at the data types of the fields you choose as well as and the cardinality of the data in the resulting recordset. Export logical keys provides client tools access to the key column metadata. You can rename subject area, table and columns with the help of an alias. This description appears in a mouseover tooltip for the subject area in oracle bi answers. Change column formatting default options for all columns in a subject area. In the presentation layer, subject areas enable you to show different views of.
On the general tab, rename the d1 time logical table source to lts1 4. Obiee subject area presentation catalog gerardnico the data. In order for you to be able to rename an object, you need to check the box edit presentation names in tools options. This version of obia is the first version which runs on the new oracle bi 11g 11. Select change specified text to rename particular words or phrases. See the readme file for installation and opatch version instructions. The function called, create subject areas for logical stars and snowflakes is selected by rightclicking a. The obiee answers interface will look like this screenshot when creating or editing an analysis.
To apply filters to the answers include in the dashboard page obiee 10g 11g passing filters through the go and dashboard url the best way to retrieve the portalpath and the page parameters is to generate a dashboard link see below for how to. In 10g you were constrained to the intersectunionminus operators which made life very difficult if you just wanted a simple report aggregating two measures from different subject areas across a common dimension. Subject areas in the presentation layer appear as catalogs to client tools that use the oracle bi server as an odbc data source. Mar 01, 2016 short answer is there is a lot less pain going from 11g to 12c than there was going from obiee 10g to 11g. Doubleclick the following column names in the subject areas pane to add 7. Some time i should refresh multiple time the page and restart or change my. Its the most updated latest version actually bundle patch of obiee, installed on top of 11.
At the moment the patch is available for windows 64, linux 64 and linux 32. Jul 02, 2014 in the select types screen, select the object types you want to rename, such as subject area, logical table, or logical column. Obiee 11g cannot expand presentation folder in subject area doc id 19416. How to connect to oracle bi server using odbc tableau. Subject areas and columns are the building blocks for an analysis. The new release allows you to connect seamlessly to obiee subject area and reports with tableau. Jul 04, 2014 how to create a basic obiee 11g repository oracle bi 11g training.
Subject areas contain presentation tables, columns, hierarchies, and levels. Tiered architecture and functional subject areas provide. To my surprise, the newly loaded rpd is live without having to restart the obis1 process and without having to reload server metadata. Creating visualizations is so easy in visual analyzer that the data analysis work becomes more an individual experience in exploration and discovery rather than an extended process of constructing views from data.
Tasks like restarting the system, checking status and moving repositoriescatalogs are quite different in 12c. Explore the blog post on obiee 11g training online to become a pro in obiee 11g. The following is a short description of what steps have to be taken to install oracle bi applications obia version 7. Obiee 11g lookup tables sparse and dense lookups, lookup table in obiee 22g oracle business intelligence 11g everthing about obiee, obia, odi, oraclesql. Obiee subject area planning part 1 great bi with oracle bi. Since guids are removed in obiee 12c, the process to rename a user in the catalog after we have renamed the user in the authenticator identity store directory is. A subject area contains folders, measure columns, attribute columns, hierarchical columns, and hierarchy levels that represent information about the areas of an organizations business or about groups of users with an organization. Select and join the tables in the join area on the tableau data source connection screen. Introduction to oracle business intelligence enterprise. Create subject areas that help you organize your content in a way that makes sense for your users. Sep, 2016 since guids are removed in obiee 12c, the process to rename a user in the catalog after we have renamed the user in the authenticator identity store directory is as below. Hi all, i am absolutely new to obiee and i am not able to create a subject area in it. Its also the catalogmetadata that the client tools such.
When the obiee version is installed, sales and catering advanced reporting subject areas are included within the obi subject areas. Subject area, catalog and functional area security march 2012 in the previous posting in this series, we looked at an overview of obiee 11g security, and then looked at rowlevel security, which allows us to deploy the same analysis or dashboard out to a set of users, but then restrict what each can see based on. How to change the subject area name in rpd presentation layer in obiee 12c. If you rename the presentation catalog in the presentation layer, those requests that are based on this subject area will be working fine without any issue.
The upgrade to 12c is an out of place upgrade as was the 10g to 11g which means new software install followed by migratingupgrading 11g artifactsweb catalog, rpd file and permisssion to the 12c versions. Obiee 12c where it all went welcome as the changes to obiee 12c are, the day after install generated for me basic questions to where things went and how things work. But this will change it across board for all subject areas in obiee. Some time i should refresh multiple time the page and restart or change my browser to show the new repository in subject area. May 10, 20 yes you can go across subject areas, but you need to know if its going to make sense or even work before you add more. In 11g, in the selected columns section of a new analysis, in the upper right is a small icon that looks like a. This tutorial covers using the oracle business intelligence bi administration tool to build, modify, enhance, and manage an oracle bi repository. Renaming dashboards in obiee there are 2 ways to rename the shared dashboards. Oct, 2016 enter your oracle bi server credentials, and then click ok to connect to the oracle bi server. The readme file describes the following bugs fixed.
Obiee is customizable in all tiers 1, e reports, repository. However when you want to edit the request, you will get the following message on the left pane. Welcome as the changes to obiee 12c are, the day after install generated for me. Jan 12, 20 if you rename the presentation catalog in the presentation layer, those requests that are based on this subject area will be working fine without any issue. It is my external memory, that helps me remember solutions i used and links i need. In addition, it includes enhancements in the connectivity from tableau to obiee, so we recommend existing users of bi connector to upgrade. Oracle bi 12c,new repository not show in subject area after. S i tried creating filter isprompted and using action links, but it is not working. Reporting using more than one fusion otbi subject area.
How to create a basic obiee 11g repository firebox training. In the presentation layer, subject areas enable you to show. Yes you can go across subject areas, but you need to know if its going to make sense or even work before you add more. Obiee cant map proper column names from parent to child analysis.
Oracle business intelligence enterprise edition 11g obiee is a comprehensive business intelligence platform that delivers a full range of capabilitiesincluding interactive dashboards, ad hoc queries, notifications and alerts, enterprise and financial reporting, scorecard and strategy management, business process invocation. One important note to mention here is it is going to be an outofplace upgrade meaning you will be installing a new obiee 12c environment and then migrate metadata from obiee 11g environment. In this example here im using an excel worksheet with. Oracle business intelligence enterprise edition 11g. This will create a union between the two data sets. This tutorial covers using oracle map builder and oracle map viewer to build and embed maps for use in oracle business intelligence analyses and dashboards. Mar 15, 2015 obiee 11g lookup tables sparse and dense lookups, lookup table in obiee 22g oracle business intelligence 11g everthing about obiee, obia, odi, oraclesql. Building on subject areas oracle bi publisher blog. As the stating point for any content creation with oracles bi platform, subject areas, also called presentation catalogs, require a good deal of thought and planning to properly match what each user communitys needs with underlying capability. Obiee tutorial a beginner guide by obiee professionals.
Visual analyzer va is a webbased tool that allows the business user to explore data visually. Below is an example of a connection to the sample sales lite subject area on the oracle bi server. So lets whack the subject area sample targets lite, rename the rpd to. Obiee provides a logical business data modal based on common information model that hides the data source from the business. It does not reflect the position or policy of oracle. Fusion middleware metadata repository builders guide for oracle business. Obiee repository contains all metadata of the bi server and is managed through the administration tool. In this oracle bi training tutorial firebox will show you how to build a basic obiee 11g repository before making it live for use by other developers. Creating and maintaining the presentation layer 11g release 1. The function called, create subject areas for logical stars and snowflakes is selected by rightclicking a business model. Its my intent that after reading this, you can expect some degree of comfort in regards to possibly doing this thing yourself should you find yourself in just such a circumstance, but if not, feel free to drop us a line or give us a ring. You can add, edit, duplicate, delete, and rename your views here too.
To apply filters to the answers include in the dashboard page obiee 10g11g passing filters through the go and dashboard url the best way to retrieve the portalpath and the page parameters is to generate a dashboard link see below for how to. Creating a repository using the oracle bi administration tool. General steps to create an application role create a new group in console create a new application role in em and link it to the created group creating a group go to. Enter sample apps presentation in the project name text box. Obiee 11g cannot expand presentation folder in subject area. Tiered architecture and functional subject areas provide modularity. Creating a repository using the oracle bi 11g administration toolin order to complete this tutorial you must have access to the bisample schema that is includedwith the sample application for oracle business intelligence suite enterprise edition plus. Check if you are applying any kind of security to that subject area by. Obiee 10g11g dashboard urllink gerardnico the data blog.
In oracle business intelligence 11g r1 a new feature has been added to the rpd logical layer which allows a user to automatically create one or more subject areas based on a single business model. Steps to create and manage repository using oracle bi ee 11g administration tool. The implementation of this is one of the big architectural changes of obiee 12c, introducing the concept of the extended subject areas xsa, and the data set service dss. Obiee 10g11g presentation layer gerardnico the data blog. Obiee 12c rename a user in the catalog proficient bi. Obiee repository can be accessed using the following path. Building maps for oracle business intelligence analyses and dashboards. The new obiee 12c instance can be installed alongside the existing obiee 11g instance.
You can export logical keys to odbcbased query and reporting tools. Manually change the value for each column in the subject area and save as system wide default option. There will be some differences if you are testing with 11. I cloned both database and physical tables on physical layer that subject area on. Your contribution will go a long way in helping us. Add any columns from your subject area to your analysis edit. Jan 18, 2016 i had an open session to obiee in the browser. Mar 08, 2017 one important note to mention here is it is going to be an outofplace upgrade meaning you will be installing a new obiee 12c environment and then migrate metadata from obiee 11g environment. The recommended method is to drag and drop a business model from the business model and mapping layer to the presentation layer, and then modify the presentation layer based on what you want users to see. In the select types screen, select the object types you want to rename, such as subject area, logical table, or logical column.
Aliases are created automatically whenever presentation objects are renamed, so that. Enter your oracle bi server credentials, and then click ok to connect to the oracle bi server. Obiee or oracle business intelligence enterprise edition is one of the leading business systems in use. How itll go down upgrading obiee 11g to 12c red pill. Business intelligence suite enterprise edition version 11. You add more subject areas click on the subject area name where the data model name normally resides. From 11g, no difference in the name is made and this two appellations are regrouped under subject area. Jan 18, 20 its the most updated latest version actually bundle patch of obiee, installed on top of 11. Building maps for oracle business intelligence analyses. I have one use case where i want to enable drill down action from an analysis in one subject area to an analysis of two different subject area. Renaming dashboards in obiee renaming dashboards in obiee. Overview and changes 27 step change from 11g to 12c download software fewer. Short answer is there is a lot less pain going from 11g to 12c than there was going from obiee 10g to 11g.
36 1414 1546 916 219 1297 1275 1188 350 1142 906 1210 1334 1007 1345 34 808 1097 642 922 140 1394 304 758 491 173 808 1026 581 1463 1262 1299 63 453 1493 709 382 877