Business intelligence suite enterprise edition version 11. I am using obiee 12c and i faced a problem when trying to use two different subject areas in generating an analysis. To report against multiple subject areas, after selecting the first subject area, select the use report editor option, and click finish to save the report. It is my external memory, that helps me remember solutions i used and links i need. Obiee 12c extended subject areas xsa and the data set. Share query with multiple users may improve performance after initial run. Additionally in 11g, you can create an analysis from two or more subject areas using a logical join operation instead of a union. Home middleware oracle fusion middleware online documentation library, 11g. Sql queries, such as microsoft access, do not select the export logical keys option. Obiee 11g and maps frequently asked questions faq peak. Managed appropriate security privileges on subject areas and dashboards as it were indicated in the business requirements.
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. We need to import the layers, maps and the images that are required as shown below. A query contains the underlying sql statements that are issued to the oracle bi. 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. So lets whack the subject area sample targets lite, rename the rpd to. Obiee 10g reporting on multiple subject area advanced logical sql. Your contribution will go a long way in helping us. How to create a basic obiee 11g repository firebox training. Querying across two subject areas in oracle business intelligence suite. Created design and development documents for creation of new subject areas customization. Migrating oracle bi discoverer metadata to oracle bi. Jan 10, 2011 one of the best improvements in obiee 11g answers is the ability to create a query across multiple subject areas.
Obiee tutorial a beginner guide by obiee professionals. Obiee 11g cannot expand presentation folder in subject area. However, when you combine columns from multiple subject areas, you must. 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. 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. Order item level, you dont need to create a single subject area that contains both order and. It is very easy to setup logging such that a centralized logging solution such as syslog or splunk can receive obiee activity. Only for 11gusers in oracle bi answers can create queries that span multiple subject areas.
In this example here im using an excel worksheet with 140,000 rows and 78 columns. It also explains subject areas and columns, the double column feature, and variables. 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. 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. You might be unable to download analysis results based on the security. Obiee subject area planning part 1 great bi with oracle bi. In addition to the primary subject area that you select when you create a new analysis, filter, or dashboard prompt, you can include. The demand for qualified obiee programmers continues to expand and if you dont know obiee you dont know big business today. For an example of the use of multiple subject areas, take a look at the sample obiee 11g app available for download at otn. Catalog is blank when report combines subject areas with union doc id 2192870.
Business intelligence server enterprise edition version 11. It is used to store information about the application environment such as. 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. Subject areas and columns are the building blocks for an analysis. If the association between a column and a layer is incorrect, then the layer cannot be displayed correctly on the map. There is an option to use unionintersect operations which creates a union query 2. Obiee 11g cannot expand presentation folder in subject. Obiee 11g cannot expand presentation folder in subject area doc id 19416. Created subject areas, folderssubfolders, and presentationbusiness columns. 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. Knowing who ran what report, when and with what parameters is helpful not only for performance tuning but also for security. 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. How to get list of users and their assigned groupsroles.
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. 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. In earlier versions of obiee 11g, you could download more than 65000 rows. There is an option to use addremove subject area which can be used to combine attributesfacts across multiple subject areas. 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. Creating a project in obiee 11g the next step is to create one or more projects.
Hi, i have to do cross subject area operations in obiee 11g. You add more subject areas click on the subject area name where the data model name normally resides. Heres how subject areas is used in obiee developer jobs. Obiee 10g reporting on multiple subject area advanced logical. Is there other consideration when joining subject areas.
Querying across two subject areas in oracle business intelligence suite obiee 0. 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. One of the best improvements in obiee 11g answers is the ability to create a query across multiple subject areas. Building on subject areas oracle bi publisher blog. Feb 12, 2017 65000 rows csv limit hidden parameter. 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. A bi layer can be associated with multiple columns in multiple subject areas. 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. Bi publisher create report guide with bi subject area. 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. Obiee or oracle business intelligence enterprise edition is one of the leading business systems in use. Oracle business intelligence enterprise edition 11g obiee 11g complete business intelligence platform from oracle delivers rich analytic and reporting functions for an enterprise by. 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.
Fusion middleware metadata repository builders guide for oracle business. Obiee subject area presentation catalog gerardnico the data. After importing themes, you can associate certain layers with columns in the oracle business intelligence subject area folders. Youll then get a shuttle dialog that lets you add more subject areas. Then, use the report editor to add the additional subject areas. 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.
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. Use this area at the top of the tab to access links that are identified with the name of the. You would model this by either joining on these attributes in the physical model if you want to go down the restrictive, databaselike way. Obiee 10g reporting on multiple subject area advanced. For more information, see creating a report against multiple subject areas. The new obiee 12c instance can be installed alongside the existing obiee 11g instance. Tiered architecture and functional subject areas provide modularity. In the presentation layer, subject areas enable you to show different views of a. 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. These operators are still there in 11g, but we also have a much more user friendly way of querying.
Creating reports using a direct connection to a subject area. Obiee 12c extended subject areas xsa and the data set service. In this example here im using an excel worksheet with. Obiee 11g provides a sample rpd with a usage tracking subject area. From enter either the name of the subject area to use for the analysis or enter a complex from clause.
Querying across two subject areas in oracle business intelligence suite obiee ask question asked 4 years, 7 months ago. Designing and querying for multiple facts and conformed. 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. Obiee 11g can now supports oracle olap as a data source. It does not reflect the position or policy of oracle.