Catalog manager provides an option to export the list of reports and columns used. As long as you are licensed for obiee 11g then you are able to use the mapviewer engine that is installed as part of the obiee 11g product suite. It does not solve the original problem of speed of change. 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.
Obiee 12c extended subject areas xsa and the data set service. Fusion middleware metadata repository builders guide for oracle business. Please suggest me which figure is better for create subject areas in presentation layer. Reporting using more than one fusion otbi subject area youtube. Explore the blog post on obiee 11g training online to become a pro in obiee 11g. One of the best improvements in obiee 11g answers is the ability to create a query across multiple subject areas. By clicking direct database request below the subject area in answers. How to create a basic obiee 11g repository oracle bi 11g. In addition, it includes enhancements in the connectivity from tableau to obiee, so we recommend existing users of bi connector to upgrade. Sales cloud has some special subject areas that can be added to the. As was the case when creating an analysis, a dashboard prompt is sourced from a single subject area. Obiee 11g features a common enterprise information model, common security model and a common configuration, deployment and systems management framework. Combining factssubject areas in oracle obiee part 2.
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. Oracle business intelligence enterprise edition 11g. Obiee 11g provides a sample rpd with a usage tracking subject area. Business intelligence server enterprise edition version 11. Select the training subject area as the source for this dashboard prompt. You can include additional sql clauses and change the subject area or the from clause for certain analyses. Hi obiee experts, i have a query for subject areas in obiee 10g version. Most common and simple method is by dragging business model in bmm layer to presentation layer and then making changes to it as per requirement. Obiee 11g is based on an architecturally integrated technology foundation built on an open, standards based service oriented architecture. Follow the onscreen instructions to construct the combined request. The example in this video is from hcm but applies to all applications that use otbi and otbi enterprise including.
A while back i wrote a post about how to combine measures from different facts in an obiee analysis. On top of this, visual analyzer has additional licensing cost even for existing obiee 11g customers who upgrade to obiee 12c. Combining factssubject areas in oracle obiee beyond blog. Use addremove subject area which can be used to combine attributesfacts across multiple subject areas. Subject areas are used in presentation layer provided by oracle bi presentation services. How to report across more than one subject area in fusion hcm otbi using the dimensionality check box. A video demo of crossdatabase joins to combine data from obiee subject area with data sources such as csv, excel, tde, and sql. Or you would model this logically in the business model by using said attributes as conformed dimensions which tie together your entities and more. The datamart or subject area that you will query with obiee contains two types of tables. 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. Created subject areas, folderssubfolders, and presentationbusiness columns. Visual analyzer va is a webbased tool that allows the business user to explore data visually. The following procedure describes how to combine columns from one or more subject areas.
Let us first refresh ourselves with a subject area actually is. Using security manger in obiee admin tool, by creating two user groups and allowing only part of the subject area for one group and other part to the other user group. There are various ways you can create subject areas in presentation layer. Obiee cant map proper column names from parent to child analysis. Crossdatabase join obiee subject area and csv with tableau. Obiee questions and answers has been designed with a special intention of helping students and professionals preparing for various certification exams and job interviews. Created design and development documents for creation of new subject areas customization.
To start using the functionality, one of the first steps is to copy the components from the sample rpd to the production rpd. Using obiee visual analyzer with teradata database teradata. Youll then get a shuttle dialog that lets you add more subject areas. The post is aimed primarily at endusers as there are developer techniques we can use to circumvent some of the restrictions described below. Business intelligence suite enterprise edition version 11. The subject area will report on configuration and changes to the rpd as well as configuration changes to enterprise manager. Analyses are stored in the oracle bi presentation catalog in xml format. Catalog is blank when report combines subject areas with union doc id 2192870.
Obiee 11g cannot expand presentation folder in subject area. 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. Nov 25, 2012 how will you implement security in obiee,so that subjects areas accessed by one group are not accessed by another group. One of the key issues i highlighted was that generally it is only possible to join up facts where the dimensions you are using are common across both facts. Using data lineage subject area we can fetch up the list of obiee reports used by a given. Its not possible to create a drill down actionlink between analysis of different subject areas. I wanted to write this as an introduction to combining data from multiple facts subject areas into a single analytic. Mar 08, 2017 a working environment of obiee 11g 11. Unlike in 11g, em does not have any option for deployments of rpd, it is all.
Obiee 10g reporting on multiple subject area advanced. 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. 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. This obiee 11g training tutorial shows you how to build a basic obiee repository before making it live for use by other developers. Select a subject area that contains the data you want to combine with the selections you made in step 1. Building on subject areas oracle bi publisher blog. A configured weblogic authentication chain to enable 11g users to sign in to 12c domain. You add more subject areas click on the subject area name where the data model name normally resides. In the presentation layer, subject areas enable you to show different views of a business. Feb 12, 2017 in earlier versions of obiee 11g, you could download more than 65000 rows.
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. Crossdatabase join obiee subject area and csv with. How to combine subject area analysis oracle community. Enter sample apps presentation in the project name text box.
Introduction to oracle business intelligence enterprise. To combine an analysis with a similar analysis from the same subject area or another. I am going to create 100 subject areas in presentation layer. 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. Combining analysis columns using set operations in oracle. Obiee subject area planning part 1 great bi with oracle bi.
You would model this by either joining on these attributes in the physical model if you want to go down the restrictive, databaselike way. Aug 12, 2016 ibot is intelligent bursting and output tool ibot is a utility available in obiee which is used for reports scheduling. In this video you learn how to combine analysis columns using set operations. How itll go down upgrading obiee 11g to 12c red pill. How will you create report from two subject areas from the criteria pane of the report created from first subject area. Additionally in 11g, you can create an analysis from two or more subject areas using a logical join operation instead of a union. Combine lets you choose any sa there is whereas add sa only lets you choose sas which are built upon a common bm as a first indication. How to create a basic obiee 11g repository firebox training. 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.
Managed appropriate security privileges on subject areas and dashboards as it were indicated in the business requirements. This section provides a useful collection of sample interview questions and multiple choice questions mcqs and their answers with appropriate explanations. Heres how subject areas is used in obiee developer jobs. The new release allows you to connect seamlessly to obiee subject area and reports with tableau. Oct 17, 2018 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.
Export bi catalog captions from command line in obiee 11g. Please note that you will need an oracle database for storing the layers e. The subject area can be the same as that selected in step 1, or a different subject area. Aug 26, 2016 in this video, we explain how you can securely connect to oracle bi obiee reports with tableau using bi connector reports edition. In this video you learn how to create an analysis from multiple subject areas. Obiee 11g cannot expand presentation folder in subject area doc id 19416. 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. Obiee calculation between results of a union some times the data model does not allow you to create a single query to get the results you need. In 10g you were constrained to the use only option 1 which made life very difficult if you just wanted a simple report aggregating two measures from different subject areas across a common dimension. Dimensional hierarchies are built by obiee repository developers in conjunction with the owners of the data, to allow users to drill down into dimensional data. Create a new dashboard prompt using the new icon on the toolbar at the top of the obiee answers screen.
668 904 507 491 309 479 294 1324 1392 887 447 507 731 363 251 826 1 329 764 1137 1138 642 1254 241 552 808 935 809 113