Error in sa subject area creation obiee 12c oracle. Obiee 12c extended subject areas xsa and the data set service. Sa systems subject area for obiee 12c 986359 oct 28, 2016 7. The sa system area allows you to set up delivery devices for users of siebel delivers automatically, so that it isnt necessary for each user to fill in my account with appropriate delivery devices and profiles etc. Please leave some comments regarding your ideas and experiences on subject area planning. Scaling is the process of increasing or decreasing the capacity of the system by changing the number of processes available to service requests from oracle business intelligence clients. Emailing reports to non obi users using ibots clearpeaks blog. In part two of this topic i will discuss layout within a subject area.
Real time suffixed with most of the rpd subject area names. In many cases this completely removes the need to extract this information from your corporate directory into a database and configure sa subject system area to enable all delivers functionality. Oracle business intelligence is a system that provides the single enterprise view of the business. Oracle bi presentation services delivers alerts from oracle bi delivers to specified email addresses, phone numbers. There are many things which were constrained till previous release, 11g fixed most of them.
Obiee microsoft office server and addinplugin gerardnico. The subject area will report on configuration and changes to the rpd as well as configuration changes to enterprise manager. Web logic server domain j2ee app server used across the board for all 11g bi applications contains. First click on the subject area and the metadata dictionary button will be enabled, click on it and youll find a set of static xml documents that contain information about dimensions, levels, hierarchies, joins, calculations and used expressions, functions, aggregation rules, physical table names, data types, etc. The sa system subject area feature automatically populated delivery devices and profiles for users. Aug 19, 2019 obia 11g after upgrading 10g 11g obiee often getting the following errors nqserror. Application name this field was added in release 10. Dec 08, 2010 using bins in obiee posted on december 8, 2010 by naveen kumar if any one want to group markets in a region and their sales.
Oracle business intelligence for microsoft office includes the oracle business. I will use some keywords like dev and sit like that. Select the training subject area as the source for this dashboard prompt. Oracle business intelligence enterprise edition obiee is a business intelligence. Obiee 10g11g sa system subject area gerardnico the. Explains how to manage oracle business intelligence enterprise edition scheduler and job manager, including how to configure scheduler, how to use job manager and its menus, and how to program scripts and java jobs. Oracle business intelligence enterprise edition obiee upgrading an oracle business intelligence enterprise edition 10g system to oracle business intelligence enterprise edition 11g is a straightforward process when you use the oracle fusion middleware upgrade assistant. Visual analyzer va is a webbased tool that allows the business user to explore data visually. Subject area, catalog and functional area security to restrict access to a particular subject area, or to certain tables or columns in a subject area, there are actually two main approaches you can take. Obiee 10g11g sa system subject area gerardnico the data.
Download file pdf oracle business intelligence enterprise edition 11g a hands on tutorial. Oracle business intelligence enterprise edition 11g a. Oracle business intelligence 12c new release features. Obiee 11g is based on an architecturally integrated technology foundation built on an open, standards based service oriented architecture. By this we can create report from two subject areas. The posts will be on oracle concepts, interview question and answers, real time scenarios, solutions for queries are provided. Hierarchies in obiee 11g part 1 its all about business. Sa system can also overwrite user settings in my account if a parameter to do that is set in instanceconfig. This section provides a useful collection of sample interview questions and multiple choice questions mcqs and their answers with appropriate explanations. How to create a subject area in obiee 11g oracle community. 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 user should not be able to select objects from a subject area that have no logical relationship. For all supported platform such as client operating systems, application servers.
I have made a presentation table in a subject area, but it was not ok, so i deleted the columns of that presentation table. You will build it offline and then make it active at the end. So it is like a ghost empty folder in the subject area in analytics. Oracle bi presentation services delivers alerts from oracle bi delivers to specified email addresses, phone. You can migrate the oracle bi 11g metadata to 12c, which a twostep. The physical to logical mapping can also be used to specify transformations that occur between the physical layer and the business model and mapping layer, as well as to enable aggregate navigation and fragmentation. Jul 16, 2009 this area is for the development team to build adminonly dashboards to assist your system test and regression tests.
Oracle 2 data sheet oracle analytics server formerly known as oracle. Obiee 11g features a common enterprise information model, common security model and a common configuration, deployment and systems management framework. In dac 10g we used to migrate the entire container for any code migrations. Let us start with hierarchies and see how to implement different types of hierarchies in bi 11g with step by step example. In previous releases of oracle business intelligence, sa system was a subject area that exposed group membership to delivers and enabled contact information, such as email addresses to be retrieved from a database and used as delivery devices in delivers. Obi 11g supports sa system subject area in combination with the bi server init blocks,to access user,group and profile information stored in database tables. Rightclick in the presentation section and select new subject area. Jan 19, 2012 setting the case of logon names for the sa system subject area when the sa system subject area is used, logon names are compared to the logon column in the sa system subject area. Tiered architecture and functional subject areas provide modularity. Enter sample apps presentation in the project name text box.
Vertica integration with oracle business intelligence suite. Business intelligence suite enterprise edition version 11. Helping teams, developers, project managers, directors, innovators and clients understand and implement data applications since 2009. This means, for example, that a login of fred will not match an sa system subject area entry of fred if your. Oracle mapviewer is a j2ee service and it serves as an engine for rendering maps. Oracle bi reporting, catalog, and subject areas youtube. Solution obiee 11g 12c where to download the obiee.
Oct 31, 2011 what about the sa system subject area. Comparing the oracle business intelligence 11g and 12c. Obiee groups, webgroups, and delivers kpi partners. Find useful oracle tips hereoracle, sql developer, sql.
Obiee 11g sample app v107 gerardnico the data blog. Includes information about the sa system subject area. Obiee questions and answers has been designed with a special intention of helping students and professionals preparing for various certification exams and job interviews. Obiee 11g sample app v107 reporting and data access tools oracle business intelligence obieesiebel analytics in. Sa systems subject area for obiee 12c oracle community. Obiee saschinvoke command line triggering of oracle bi. Explore the blog post on obiee 11g training online to become a pro in obiee 11g. Obia 11g after upgrading 10g 11g obiee often getting the. Or you would model this logically in the business model by using said attributes as conformed dimensions which tie together your entities and more. Manual effort of downloading the source data files from mail to local machine. Obiee 11g provides a sample rpd with a usage tracking subject area. Oracle business intelligence enterprise edition 11g a hands. Apr 27, 2016 we are trying to create a sa system users subject area.
How to refresh guids in obiee 11g for authentication. The basic purpose of sa system is to set the delivery profiles of users, providing default delivery settings for users who have not entered settings in my account. Obiee subject area planning part 1 great bi with oracle bi. Aug 15, 2012 we are very much interested in technical blogging. Oracle business intelligence enterprise edition 11g. Saschinvoke command line triggering of oracle bi scheduler jobs saw url symbolic url parameters applet. As was the case when creating an analysis, a dashboard prompt is sourced from a single subject area. Enterprise data warehouse for telco giant rpd standards naming standards all object naming will follow business friendly conventions except the physical layer. In this video, our trainer explains bi reports and analytics, subject areas, fusion reporting terms, data roles and security profiles. Oracle fusion middleware online documentation library 11g release 1 11.
The presentation catalog must include specific fields with exact field names as outlined in venkats article. Describes how to install and configure oracle business intelligence components in an enterprise deployment. Create a new dashboard prompt using the new icon on the toolbar at the top of the obiee answers screen. Oracle fusion middleware online documentation library. Oct 30, 2014 in this post we will migrate one single subject area from one environment to another environment. Its also the catalogmetadata that the client tools such as presentation service see when they made a connection even though the logical sql requests from answers and other clients query the presentation tables and columns, the real logic for entities, relationships, joins, and so on is. Instead, system components are managed by the oracle weblogic. From the criteria pane of the report created from first subject area come to the bottom of the page and click combine request. How obiee developer can create report from two subject areas. Using obiee visual analyzer with teradata database teradata.
Obiee 11g sample app v107 reporting and data access tools oracle business intelligence obiee siebel analytics in progress. Also, you may refer obiee sa system subject area for reference which uses just a single table rpd modeling. Obiee tutorial a beginner guide by obiee professionals. Logical table sources define the mappings from a single logical table to one or more physical tables. We have created the table with all necessary columns and created the subject area in rpd. The core of the sa system area is a presentation catalog subject area containing exactly the following tables and columns. As its a subject area, you can choose the source of your data as for instance a ldap directory.
We can achieve thisby using bin with out writing long case statements. The enterprise manager does not have an option to deploy the rpd. Login to dev dac and select the subject area you want to migrate. Further, the entire solution is a cloud based model, so they have the best of. We are trying to create a sa system users subject area. This obiee 11g training tutorial shows you how to build a basic obiee repository before making it live for use by other developers. The system issues queries using these field names when retrieving details for a user. Apply to data warehouse engineer, developer, consultant and more. 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. Difference between high availability and scale out. Overview and changes 27 step change from 11g to 12c download software fewer.
This blog mainly concentrates on oracle technologies. 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. Steps for obiee 11g installation in windows764 bit os. Download the spatial schema provided by navteq from the following location. Sa system subject area oracle business intelligence release 12 c supports the use of sa system subject area, in combination with the bi server initialization blocks, to access user, group and profile information stored in database tables. Obiee 11g sample app v107 reporting and data access tools oracle business intelligence obiee siebel analytics. If you are manually loading your data from source system to oracle reconciliation. The problem is that there is a folder in the subject area in analytics and it is empty, but in the repository itself i dont see that folder. By clicking direct database request below the subject area in we can execute direct sql in obiee. Check if you are applying any kind of security to that subject area by. D setting up the sa system subject area oracle docs.
To start using the functionality, one of the first steps is to copy the components from the sample rpd to the production rpd. The purpose of the sa system subject area is to be able to manage user profiles that do not belong to any obiee group. Read more to learn why combining obiee with tableau, not replacing, is a superior. The subject area must be sa system as the system automatically looks for this specific value. Documentation for oracle business intelligence publisher oracle bi publisher on fusion middleware 11g 11. So, can anyone help me to create a subject area in obiee.
Deploying a high availability system minimizes the time when the system is down, or unavailable and maximizes the time when it is running, or available. Mar 11, 2011 the sa system area allows you to set up delivery devices for users of siebel delivers automatically, so that it isnt necessary for each user to fill in my account with appropriate delivery devices and profiles etc. From 11g, no difference in the name is made and this two appellations are regrouped under 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 presentation catalog gerardnico. How to create a basic obiee 11g repository firebox training. Made the changes as per the following document in the instanceconfig.
432 549 358 1060 328 1167 1485 438 331 313 1358 1253 1274 1021 142 964 409 1299 945 54 1383 351 271 369 1064 491 287 1100 1005 486 478 1470