Lets say i have one rpd based on oracle ebs transaction system for actuals. We are trying to create a sa system users subject area. This means, for example, that a login of fred will not match an sa system subject area entry of fred if your. Check if you are applying any kind of security to that subject area by. Bip 10g configuration with obiee 10g gerardnico the. Welcome as the changes to obiee 12c are, the day after install generated for me basic questions to. The core of the sa system area is a presentation catalogsubject area containing exactly the following tables and columns. I have made a presentation table in a subject area, but it was not ok, so i deleted the columns of that presentation table. In both cases, logical dimension tables joined to the logical fact tables are implicitly included, even though they do not appear in the right pane. So, can anyone help me to create a subject area in obiee. Obiee 10g premier support ends mid 20 oracle business. Subject areas and columns are the building blocks for an analysis.
Obiee has 2 default servers bi server and presentation server. 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. 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. This is a sample table in the database along with other columns. Please leave some comments regarding your ideas and experiences on subject area planning. So your only path is to use a query against the bi server and get the data that way. Mar 26, 2014 find useful oracle, sql developer, sqlplus, informatica, odi, obiee tips here. The presentation catalog must include specific fields with exact field names as outlined in venkats article.
Using obiee visual analyzer with teradata database teradata. 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 oracle business intelligence enterprise edition obiee 11g 11. Tiered architecture and functional subject areas provide modularity. This obiee 11g training tutorial shows you how to build a basic obiee repository before making it live for use by other developers. To resolve this problem, you must to set the obiee 10g 11g sa system subject area up if you use bip in a previous release than 10. You would model this by either joining on these attributes in the physical model if you want to go down the restrictive, databaselike way.
The subject area must be sa system as the system automatically looks for this specific value. 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. Download the obiee 11g versionfrom here or from oracle edelivery site and extract all the four disk into a single folder and click setup. Oracle business intelligence enterprise edition 11g a hands. Download the spatial schema provided by navteq from the. Adding a logical fact table includes the subject area containing the table. We can achieve thisby using bin with out writing long case statements.
To start using the functionality, one of the first steps is to copy the components from the sample rpd to the production rpd. Obiee oracle business intelligence enterprise edition latest version is 11. This appendix explains how to configure and use the sa system subject area to accomplish this task. 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. An application role defines a set of permissions that are granted to a user or group. Oracle business intelligence enterprise edition oracle business intelligence suite enterprise edition plus obiee plus is a comprehensive suite of enterprise business intelligence bi products. Oracle business intelligence presentation services administration guide version 10. Web logic server domain j2ee app server used across the board for all 11g bi applications contains.
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 security leveltype obiee implicit fact column. Create a new dashboard prompt using the new icon on the toolbar at the top of the obiee answers screen. Application roles are new with obiee 11g and replace groups within obiee 10g. Obiee 11g features a common enterprise information model, common security model and a common configuration, deployment and systems management framework. The subject area will report on configuration and changes to the rpd as well as configuration changes to enterprise manager. Sa systems subject area for obiee 12c oracle community. 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. Obiee 11g provides a sample rpd with a usage tracking subject area. Set of j2ee applications used for functioning the biee system. 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. 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.
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. The subject area data model is a black box which means there is no sample data to work with in the rtf. Obiee groups, webgroups, and delivers kpi partners. For information on the sa system subject area, see the oracle business intelligence server administration guide. I will use some keywords like dev and sit like that. Sa systems subject area for obiee 12c 986359 oct 28, 2016 7. If the file is not the expected size, you may want to try temporarily disabling anti. Oct 15, 2012 to give all obiee users a fair warning ahead of time. Obiee is a reporting tool wherein multiple users belonging to multiple groups create multiple reports and dashboards. Visual analyzer va is a webbased tool that allows the business user to explore data visually. By clicking direct database request below the subject area in we can execute direct sql in obiee. Made the changes as per the following document in the instanceconfig. So lets whack the subject area sample targets lite, rename the rpd to.
Obia 11g after upgrading 10g 11g obiee often getting the following errors nqserror. Obiee 12c start and stop scripts no more opmn big data. In part two of this topic i will discuss layout within a subject area. To give all obiee users a fair warning ahead of time. Obiee subject area planning part 1 great bi with oracle bi.
Export bi catalog captions from command line in obiee 11g. The core of the sa system area is a presentation catalog subject area containing exactly the following tables and columns. Oracle mapviewer is a j2ee service and it serves as an engine for rendering. Obiee tutorial a beginner guide by obiee professionals. Select the training subject area as the source for this dashboard prompt. Fusion middleware system administrators guide for oracle business. It is a reporting tool for generate the reports to analyses the data. From the criteria pane of the report created from first subject area come to the bottom of the page and click combine request. 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. Oct 30, 2014 in this post we will migrate one single subject area from one environment to another environment. Oracle business intelligence enterprise edition oracle business intelligence suite enterprise edition plus obiee plus is a. A dashboard is a customized viewing page that displays the analysis or report.
This area is for the development team to build adminonly dashboards to assist your system test and regression tests. Bip 10g configuration with obiee 10g gerardnico the data. After running an answers report, check the sql nqquery. Includes information about the sa system subject area.
Steps for obiee 11g installation in windows764 bit os. Error in sa subject area creation obiee 12c oracle. Obiee 11g is based on an architecturally integrated technology foundation built on an open, standards based service oriented architecture. 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 obiee 10g, security is controlled at the following points. Sa system can also overwrite user settings in my account if a parameter to do that is set in instanceconfig. 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. Aug 19, 2019 obia 11g after upgrading 10g 11g obiee often getting the following errors nqserror. Find useful oracle, sql developer, sqlplus, informatica, odi, obiee tips here. You will build it offline and then make it active at the end. This is a java deployment datasetsvc running in the managed server. In obiee 11g, the security policy is split across the obiee presentation catalog, repository and default 11g identity store embedded wls. Obiee 10g11g sa system subject area gerardnico the data.
Adding a subject area includes all fact tables and dependencies in the subject area. Oct 31, 2011 what about the sa system subject area. The system issues queries using these field names when retrieving details for a user. Login to dev dac and select the subject area you want to migrate. Obiee 10g 11g how to see the physical sql generated by a request in presentation service.
As was the case when creating an analysis, a dashboard prompt is sourced from a single subject area. This chapter describes the application roles and application policies that are managed in oracle enterprise manager fusion middleware control. So it is like a ghost empty folder in the subject area in analytics. 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. The new release allows you to connect seamlessly to obiee subject area and reports with tableau. The dashboard page when loaded simply has the comment database table modeled through in the obiee rpd as a subject area which is referenced in another analysis created to display the comment data from the database table. If the file is not the expected size, you may want to try temporarily disabling antivirus software or downloading on a unix machine first. In this post we will migrate one single subject area from one environment to another environment. Obiee 10g reporting on multiple subject area advanced logical sql obiee 10g 11g sa system subject area. D setting up the sa system subject area oracle docs. Oracle business intelligence enterprise edition oracle bi ee is a comprehensive set. I tried to get the report to render xml as an output and then use that but bip reports that xml is not available for this report. Searching subject area for measure names in answers hello, i have installed obiee 11g sampleapp 825 and just exploring the provided set of dashboards. How obiee developer can create report from two subject areas.
Reports created by a particular group of users should be visible to that particular group only or some specific data should be visible to only a specific set of people. Building on subject areas oracle bi publisher blog. The sa system subject area feature automatically populated delivery devices and profiles for users. To resolve this problem, you must to set the obiee 10g11g sa system subject area up if you use bip in a previous release than 10. Oracle business intelligence is a system that provides the single enterprise view of.
In dac 10g we used to migrate the entire container for any code migrations. Obia 11g after upgrading 10g 11g obiee often getting the. When the obiee version is installed, sales and catering advanced reporting subject areas are included within the obi subject areas. Apr 17, 2014 obiee oracle business intelligence enterprise edition latest version is 11. Business intelligence suite enterprise edition version 11. The posts will be on oracle concepts, interview question and answers, real time scenarios, solutions for queries are provided. Obiee subject area presentation catalog gerardnico. So locate the sa system in the presentation layer and delete it. Please be aware that the premier support product lifecycle for oracle business intelligence enterprise edition and oracle business intelligence publisher 10.
An extended subject area xsa is made up of a dataset, and associated. Hi all, i am absolutely new to obiee and i am not able to create a subject area in it. Obiee 10g11g sa system subject area gerardnico the. Oracle business intelligence enterprise edition 11g. This blog mainly concentrates on oracle technologies. Turn off caching in the i and restart the server service or at the physical table level in the. Although oracle apex has come a long way in the last several years, the full integration with obiee is still advancing. Find useful oracle tips hereoracle, sql developer, sql.
Tasks like restarting the system, checking status and moving. 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. Obiee 12c extended subject areas xsa and the data set service. Oracle business intelligence presentation services. Select the export link to download the report to your computer.
We have created the table with all necessary columns and created the subject area in rpd. Configuring to download oracle hyperion smart view for office. In addition, it includes enhancements in the connectivity from tableau to obiee, so we recommend existing users of bi connector to upgrade. 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.
334 1215 994 756 1198 586 414 169 1043 528 954 545 761 1187 1448 100 1184 1336 1151 30 4 1193 181 514 1229 1042 970 798 367 1270 178 1024