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