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