Fusion middleware metadata repository builders guide for oracle business. 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. Youll then get a shuttle dialog that lets you add more subject areas. Obiee subject area presentation catalog gerardnico the data. Created design and development documents for creation of new subject areas customization. Querying across two subject areas in oracle business intelligence suite. For an example of the use of multiple subject areas, take a look at the sample obiee 11g app available for download at otn.
It is my external memory, that helps me remember solutions i used and links i need. Oracle bi ee metadata can span multiple heterogeneous data sources, share common dimensions between multiple subject areas and therefore provides a common and consistent reporting framework across all business functions. You would model this by either joining on these attributes in the physical model if you want to go down the restrictive, databaselike way. May 28, 2015 for this we can only open each user in console and check the individual groups added to him in groups tab. A bi layer can be associated with multiple columns in multiple subject areas. This chapter describes how to create analyses in oracle business intelligence enterprise edition, including how to specify the criteria for analyses, display the results, and examine the sql statements. As mentioned above in scenario, the primary reason to create projects is to support multiuser development. I am using obiee 12c and i faced a problem when trying to use two different subject areas in generating an analysis. Then, use the report editor to add the additional subject areas. It is very easy to setup logging such that a centralized logging solution such as syslog or splunk can receive obiee activity. Order item level, you dont need to create a single subject area that contains both order and. Obiee 11g cannot expand presentation folder in subject.
Jul 10, 2014 relationship between bi ee repository columns subject areas and mapviewer maps are done from the manage map data screen in the presentation services admin console. Obiee 11g impersonates the option of calling a webservice in the answers that resides in weblogic, we can use this feature to see the individual uses and their groupsroles by calling webservice from the obiee 11g dashboard. The demand for qualified obiee programmers continues to expand and if you dont know obiee you dont know big business today. Obiee 11g can now supports oracle olap as a data source. Obiee 10g reporting on multiple subject area advanced logical. 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. Creating reports using a direct connection to a subject area. Business intelligence suite enterprise edition version 11.
The function called, create subject areas for logical stars and snowflakes is selected by rightclicking a business model. Obiee 11g also has two levels of caching to optimise not only the querying of report data but also the presentation of report objects charts, tables etc the oracle database, mapviewer and bi ee are all horizontally scalable, so you get the full benefits of a scalable and highavailability architecture throughout the technology stack. After importing themes, you can associate certain layers with columns in the oracle business intelligence subject area folders. How to create a basic obiee 11g repository firebox training. Oracle business intelligence enterprise edition 11g obiee 11g complete business intelligence platform from oracle delivers rich analytic and reporting functions for an enterprise by. Jan 10, 2011 one of the best improvements in obiee 11g answers is the ability to create a query across multiple subject areas. 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. Designing and querying for multiple facts and conformed. Migrating oracle bi discoverer metadata to oracle bi. One of the best improvements in obiee 11g answers is the ability to create a query across multiple subject areas. Creating a project in obiee 11g the next step is to create one or more projects. 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. Knowing who ran what report, when and with what parameters is helpful not only for performance tuning but also for security. In this example here im using an excel worksheet with 140,000 rows and 78 columns.
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. Tiered architecture and functional subject areas provide modularity. Heres how subject areas is used in obiee developer jobs. Obiee 10g reporting on multiple subject area advanced. Business intelligence server enterprise edition version 11. Obiee 11g cannot expand presentation folder in subject area. Only for 11gusers in oracle bi answers can create queries that span multiple subject areas. There is an option to use addremove subject area which can be used to combine attributesfacts across multiple subject areas.
Obiee or oracle business intelligence enterprise edition is one of the leading business systems in use. Home middleware oracle fusion middleware online documentation library, 11g. Your contribution will go a long way in helping us. In addition to the primary subject area that you select when you create a new analysis, filter, or dashboard prompt, you can include. In the presentation layer, subject areas enable you to show different views of a. Obiee tutorial a beginner guide by obiee professionals. Sql queries, such as microsoft access, do not select the export logical keys option. There is an option to use unionintersect operations which creates a union query 2. Obiee 10g reporting on multiple subject area advanced logical sql.
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. Querying across two subject areas in oracle business intelligence suite obiee ask question asked 4 years, 7 months ago. Building on subject areas oracle bi publisher blog. 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. It is used to store information about the application environment such as.
In this example here im using an excel worksheet with. Additionally in 11g, you can create an analysis from two or more subject areas using a logical join operation instead of a union. Querying across two subject areas in oracle business intelligence suite obiee 0. Subject areas and columns are the building blocks for an analysis. Use this area at the top of the tab to access links that are identified with the name of the. So lets whack the subject area sample targets lite, rename the rpd to. Created subject areas, folderssubfolders, and presentationbusiness columns. Multirelease model in oracle business intelligence synchronizing rpd.
These operators are still there in 11g, but we also have a much more user friendly way of querying. 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. Obiee repository can be accessed using the following path. Hi, i have to do cross subject area operations in obiee 11g. Bi publisher create report guide with bi subject area. Is there other consideration when joining subject areas.
Obiee 11g provides a sample rpd with a usage tracking subject area. Catalog is blank when report combines subject areas with union doc id 2192870. Obiee 11g cannot expand presentation folder in subject area doc id 19416. You add more subject areas click on the subject area name where the data model name normally resides. How to get list of users and their assigned groupsroles. This article shows advanced logical sql statement for the sake of knowledge and was written on a 10g because within an answer, it was possible through the gui to join two subject areas even if the gui of answer cant do it, bi server is able to read and to serve this kind of clause because the logical sql is ansi sql 92 compliant. This article shows advanced logical sql statement for the sake of knowledge and was written on a 10g because within an answer, it was possible through the gui to join two 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. 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.
In earlier versions of obiee 11g, you could download more than 65000 rows. 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. It also explains subject areas and columns, the double column feature, and variables. Obiee 12c extended subject areas xsa and the data set service. Obiee 12c extended subject areas xsa and the data set. Obiee subject area planning part 1 great bi with oracle bi.
I started with creating the analysis based on one subject area. 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. You might be unable to download analysis results based on the security. We need to import the layers, maps and the images that are required as shown below. For more information, see creating a report against multiple subject areas. Share query with multiple users may improve performance after initial run. Feb 12, 2017 65000 rows csv limit hidden parameter. It does not reflect the position or policy of oracle. A query contains the underlying sql statements that are issued to the oracle bi. Obiee repository contains all metadata of the bi server and is managed through the administration tool.
Obiee 11g and maps frequently asked questions faq peak. If the association between a column and a layer is incorrect, then the layer cannot be displayed correctly on the map. 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. Then, the builtin obiee ui will present the user with a list of subject areas by name for them to choose from when your user goes to build an analysis. The new obiee 12c instance can be installed alongside the existing obiee 11g instance. However, when you combine columns from multiple subject areas, you must. From enter either the name of the subject area to use for the analysis or enter a complex from clause. There need not be any relation between the column used in spatial and the column mapped in bi ee.
1098 1266 1274 971 1021 393 995 472 12 752 1036 858 295 274 497 926 1052 879 1394 1520 1399 1223 685 652 601 424 1120 1017 119 739 345 586 837 262 911 1402