Its also the catalogmetadata that the client tools such. How to create a basic obiee 11g repository oracle bi 11g training. Obiee or oracle business intelligence enterprise edition is one of the leading business systems in use. Obiee cant map proper column names from parent to child analysis.
How to connect to oracle bi server using odbc tableau. In the select rules screen, select the renaming rules you want to apply and click add. Below is an example of a connection to the sample sales lite subject area on the oracle bi server. Oracle business intelligence enterprise edition 11g.
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. Short answer is there is a lot less pain going from 11g to 12c than there was going from obiee 10g to 11g. Building maps for oracle business intelligence analyses and dashboards. But this will change it across board for all subject areas in obiee. From 11g, no difference in the name is made and this two appellations are regrouped under subject area. See the readme file for installation and opatch version instructions. 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. 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. Creating a repository using the oracle bi administration tool. This version of obia is the first version which runs on the new oracle bi 11g 11. Reporting using more than one fusion otbi subject area. However when you want to edit the request, you will get the following message on the left pane. Tiered architecture and functional subject areas provide.
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. Subject areas and columns are the building blocks for an analysis. I cloned both database and physical tables on physical layer that subject area on. It is my external memory, that helps me remember solutions i used and links i need. 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. Tiered architecture and functional subject areas provide modularity. Renaming dashboards in obiee there are 2 ways to rename the shared dashboards. Visual analyzer va is a webbased tool that allows the business user to explore data visually. Jan 18, 2016 i had an open session to obiee in the browser.
How to change the subject area name in rpd presentation layer in obiee 12c. Add any columns from your subject area to your analysis edit. Explore the blog post on obiee 11g training online to become a pro in obiee 11g. Introduction to oracle business intelligence enterprise. 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. So, can anyone help me to create a subject area in obiee.
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. Select change specified text to rename particular words or phrases. Building on subject areas oracle bi publisher blog. 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. At the moment the patch is available for windows 64, linux 64 and linux 32. In the presentation layer, subject areas enable you to show different views of. Enter sample apps presentation in the project name text box. 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. 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. Renaming dashboards in obiee renaming dashboards in obiee.
Welcome as the changes to obiee 12c are, the day after install generated for me. Hi all, i am absolutely new to obiee and i am not able to create a subject area in it. Oracle bi 12c,new repository not show in subject area after. Obiee 11g cannot expand presentation folder in subject area. On the general tab, rename the d1 time logical table source to lts1 4. Some time i should refresh multiple time the page and restart or change my. So lets whack the subject area sample targets lite, rename the rpd to. When the obiee version is installed, sales and catering advanced reporting subject areas are included within the obi subject areas. Steps to create and manage repository using oracle bi ee 11g administration tool.
The following is a short description of what steps have to be taken to install oracle bi applications obia version 7. Change column formatting default options for all columns in a subject area. In this article well see some of how xsa and dss work behind the scenes, providing an important insight for troubleshooting and performance analysis of this functionality. Obiee subject area planning part 1 great bi with oracle bi. The function called, create subject areas for logical stars and snowflakes is selected by rightclicking a. The new release allows you to connect seamlessly to obiee subject area and reports with tableau.
Some time i should refresh multiple time the page and restart or change my browser to show the new repository in subject area. Obiee repository can be accessed using the following path. 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 12c rename a user in the catalog proficient bi. 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. The demand for qualified obiee programmers continues to expand and if you dont know obiee you dont know big business today. In this example here im using an excel worksheet with. 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. It is used to store information about the application environment such as. Create subject areas that help you organize your content in a way that makes sense for your users.
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. Doubleclick the following column names in the subject areas pane to add 7. This tutorial covers using the oracle business intelligence bi administration tool to build, modify, enhance, and manage an oracle bi repository. Building maps for oracle business intelligence analyses. Its the most updated latest version actually bundle patch of obiee, installed on top of 11. Business intelligence suite enterprise edition version 11. 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. Subject areas contain presentation tables, columns, hierarchies, and levels. Jan 18, 20 its the most updated latest version actually bundle patch of obiee, installed on top of 11. Export bi catalog captions from command line in obiee 11g.
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. Fusion middleware metadata repository builders guide for oracle business. 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. Oct, 2016 enter your oracle bi server credentials, and then click ok to connect to the oracle bi server. Jul 04, 2014 how to create a basic obiee 11g repository oracle bi 11g training. 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.
To my surprise, the newly loaded rpd is live without having to restart the obis1 process and without having to reload server metadata. You can add, edit, duplicate, delete, and rename your views here too. Obiee 10g11g presentation layer gerardnico the data blog. Youll then get a shuttle dialog that lets you add more subject areas. Check if you are applying any kind of security to that subject area by.
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. 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. Subject areas in the presentation layer appear as catalogs to client tools that use the oracle bi server as an odbc data source. There are several ways to create subject areas in the presentation layer.
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 addition, it includes enhancements in the connectivity from tableau to obiee, so we recommend existing users of bi connector to upgrade. 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. In the select types screen, select the object types you want to rename, such as subject area, logical table, or logical column. There will be some differences if you are testing with 11. Your contribution will go a long way in helping us.
How to create a basic obiee 11g repository firebox training. You add more subject areas click on the subject area name where the data model name normally resides. You can rename subject area, table and columns with the help of an alias. The function called, create subject areas for logical stars and snowflakes is selected by rightclicking a business model. Obiee repository contains all metadata of the bi server and is managed through the administration tool. Creating and maintaining the presentation layer 11g release 1. Obiee provides a logical business data modal based on common information model that hides the data source from the business. Export logical keys provides client tools access to the key column metadata.
Obiee 11g lookup tables sparse and dense lookups, lookup table in obiee 22g oracle business intelligence 11g everthing about obiee, obia, odi, oraclesql. In 11g, in the selected columns section of a new analysis, in the upper right is a small icon that looks like a. In the presentation layer, subject areas enable you to show. Obiee tutorial a beginner guide by obiee professionals. How itll go down upgrading obiee 11g to 12c red pill. It does not reflect the position or policy of oracle. Aliases are created automatically whenever presentation objects are renamed, so that. Obiee subject area presentation catalog gerardnico the data. 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. Enter your oracle bi server credentials, and then click ok to connect to the oracle bi server.
The obiee answers interface will look like this screenshot when creating or editing an analysis. Obiee 12c extended subject areas xsa and the data set service. In order for you to be able to rename an object, you need to check the box edit presentation names in tools options. 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. 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. Obiee 10g11g dashboard urllink gerardnico the data blog. Select and join the tables in the join area on the tableau data source connection screen. You can export logical keys to odbcbased query and reporting tools. Jan 24, 20 obiee in il this blog is personal and independent. One of the best improvements in obiee 11g answers is the ability to create a query across multiple subject areas. Overview and changes 27 step change from 11g to 12c download software fewer. 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.
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. 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 11g cannot expand presentation folder in subject area doc id 19416. The readme file describes the following bugs fixed. This description appears in a mouseover tooltip for the subject area in oracle bi answers. In version 10g you choose combine with similar request button on the criteria tab, and choose the 2nd subject area. S i tried creating filter isprompted and using action links, but it is not working. Tasks like restarting the system, checking status and moving repositoriescatalogs are quite different in 12c. 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. The new obiee 12c instance can be installed alongside the existing obiee 11g instance. This will create a union between the two data sets. Manually change the value for each column in the subject area and save as system wide default option. 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. Obiee is customizable in all tiers 1, e reports, repository.
1255 366 242 1187 229 769 8 666 1059 387 176 290 1292 625 808 1085 89 190 219 528 1369 47 1418 1638 1344 1555 147 1416 660 297 175 930 371 1022 4 1578 868 844 275 1477 969 1181 1376 835 756 732 821 1041 1394