Obiee 11g features pdf

This release provides a fully integrated full-text search. This method of searching allows the user to find objects by searching on their attributes such as author and column name. For more information, see "Full-Text Catalog Search".

In this release, the "Sign In page" has been enhanced to include the Accessibility Mode box, which allows you to specify whether you want content for Oracle BI EE to be rendered in a browser in a way that facilitates the use of a screen reader. This release includes the addition of a contribution wheel diagram to a strategy tree, which allows you to view an objective and its supporting child objectives and KPIs hierarchically in a circular diagram.

For more information, see "Understanding a Contribution Wheel Diagram". You can use the marquee zoom feature to zoom into a specific area of the map view, as described in "Zooming in Map Views". The ability to include selected members in hierarchy selections steps that are based on family relationships.

For more information, see "Select Values dialog". The addition of Siblings of and Leaves of options in family relationships. If the content designer adds a selection step that includes a condition with a qualified data reference QDR , the QDR now displays in the Selection Steps pane. This condition type is available for attribute columns and hierarchical columns.

The Column field was added to the New Condition Step dialog for this condition type. For more information, see "New Condition Step dialog". The ability to rename views and compound layouts. For more information, see "Renaming Views or Compound Layouts". The Selection Steps view was added. This view when added to an analysis, displays the selection steps in effect for the analysis.

For more information, see "Results tab: Selection Steps editor". Enhancements to Tables and Pivot Tables. Select the measure on which to sort a column in a pivot table.

For more information, see "Sorting Options Menu". Specify how columns that are added to an analysis from the "Analysis editor: Criteria tab" after displaying the analysis results are handled.

For more information, see "Analysis Properties dialog: Data tab". Additional interactions on the right-click menu, for example, Include column , Show Running Sum , interactions for selection steps, and so on. The ability to specify which interactions for example, Drill are available when you right-click in an analysis or a dashboard at runtime.

For more information, see "Analysis Properties dialog: Interactions tab". The ability to use BI Composer in regular mode as well accessibility mode. In the previous release, BI Composer was available only in accessibility mode. In this release, you can specify the width of each column prompt field.

You can set the width when designing an individual prompt or when specifying format options for the prompts page. If you are specifying the prompt width on the prompts page, all prompts display to the width that you specify.

You can also specify to wrap column labels on the prompts page. The prompt field width and wrap prompt labels settings do not apply to the Slider user input type. For information about prompts, see Chapter 6, "Prompting in Dashboards and Analyses. This release introduces BI Composer, a simple-to-use wizard that allows you to quickly and easily create, edit, and view analyses without the complexities of the "Analysis editor".

In this release, it is available only in accessibility mode that is, it is optimized for use with screen reader applications such as JAWS so that users with visual impairments can easily create, edit, and view analyses. This release includes the following enhancements to the "KPI editor" :. The Thresholds page has been redesigned and renamed the States page. The redesign allows you to specify threshold values as percentages of the target value and to specify the status to assign to a KPI that returns no data.

A new page named Custom Attributes has been added that allows you to create custom columns for the KPI. Requests or reports have been renamed to analyses , and the term reports now refers to BI Publisher reports. Presentation columns have been renamed to attribute columns. Security terminology and architecture has changed. The user interface has undergone major improvements in several areas, including a new Home page and redesigned editors and panes.

This guide provides detailed information on working with the various pieces of the user interface. The interface has been enhanced to better serve the needs of users with disabilities.

For information, see Appendix C, "Accessibility Features. New Column Type and Related Operations. In previous releases prior to 11 g , you included presentation columns and measure columns in analyses. With this release, presentation columns have been renamed to attribute columns and a new column type, hierarchical column , is introduced.

Limit the data that is displayed in an analysis. You can continue to use a filter to limit the data for an attribute column, and you can use a "selection step" to limit data for columns by specifying the criteria for a set of members. See "Working with Selections of Data" for information. Drill in data. You can drill to expand and collapse values in views such as tables, pivot tables, graphs, and maps. For information, see "Drilling in Views".

Sort data values. You can apply sorts to members, measures, and rows in views such as tables, pivot tables, graphs, and maps. Sorting is now enabled by default.

See "Sorting Data in Views" for information. Table and pivot table have been enhanced to function more consistently and to display hierarchical columns. In a pivot table, you can easily drag and drop columns to various edges, to rearrange the display to suit your needs.

Graph and gauge have been enhanced with additional functionality. For example, you can define section sliders for graphs and gauges. Map view is a new view type that presents data in spatial form. Through location context, map views allow users to easily discover trends and transactions across regions that might not be obvious in tables or graphs. In addition to view enhancements, this release includes an enhanced Layout pane to accompany those views in which you can manipulate data.

See "Modifying the Layout of Data in Views" for information. In this release, you can also create master-detail relationships among certain view types. You can continue to create calculated items to perform mathematical operations on members.

In previous releases prior to 11 g , you could create a calculated item for an attribute column. In this release, you can create a calculated item for the members of an attribute column or of a hierarchical column. In this release, you can create a "group" of members to display in a view. The group inherits the aggregation function of the measure column with which it is displayed. See "Working with Groups and Calculated Items" for information.

In this release, you can work with 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 additional subject areas that are related to the primary subject area with which to work. In addition, you can view metadata information for subject areas, folders, columns, and hierarchy levels. Interaction with Other Oracle Products. The following new and revised SQL functions enable you to create time series calculations and level-based measures:.

AGO is a time series aggregation function that calculates the aggregated value from the current time back to a specified time period.

TODATE is a time series aggregation function that aggregates a measure attribute from the beginning of a specified time period to the currently displayed time. The syntax for this function has changed in this release. You can create analyses by directly calling database functions from either Oracle Business Intelligence, or by using a Logical column in the Logical Table source within the metadata repository. Key uses for these functions include the ability to pass through expressions to get advanced calculations, as well as the ability to access custom written functions or procedures on the underlying database.

See "Database Functions" for information. This release includes enhancements to the way that default formatting is handled. Conditional formatting has been enhanced to work with pivot tables and with hierarchical columns.

The Oracle BI Presentation Catalog is a powerful, underlying storage directory-based system that contains the objects dashboards, scorecards, prompts, and KPIs for example that you create. If you use BI Publisher, then the catalog also contains BI Publisher data and objects data models and schedules, for example. Using the catalog, you can:.

Perform object-specific tasks for example, modifying settings using the associated editor, or creating and assigning an agent. Work with properties such as changing the ownership of a folder or viewing the creation date of an object. This release provides a mechanism for searching for objects in the Oracle BI Presentation Catalog that is similar to a full-text search. The upgrade process is explained at length here. There is also an example Linux in-place upgrade from Let's take an in-depth look at some of the new features.

A variety of features have been added to Data Visualization, which brings it closer to its standalone counterpart, Data Visualization Desktop. This allows user to "revisualize" and explore the data contained within one or more analyses in different ways.

Oracle has added this same feature in data visualization. Selecting From Oracle Applications opens a new window where you enter your connection information. Once you enter the connection information, you are able to view all of the folders you have access to within the OBIEE catalog.

Selecting an analysis and clicking ok brings you to another screen where you can specify between measures and attributes for your columns and change the specified aggregation for your measure columns. Another feature added to DV is the ability to connect directly to a database.

It allows you to add tables directly from a database schema or write a SQL statement to select the data you want. This brings up a connection window to enter your connection details.

From here, you can also select from a large selection of database types other than the default Oracle Type. Clicking on Oracle brings up the list which matches the selections available in the latest release of Data Visualization Desktop. Choosing to add tables from a database schema allows you to add data sources, one table at a time.

In some situations, you might want to create one datasource selection from a database from multiple tables. You can achieve this by clicking on the SQL tab after making your database connection and writing a custom sql statement. Clicking OK brings you to a results screen with all of the columns previously defined in your sql statement and also give you the ability to rename your datasource and to change the aggregation type for your measure columns.

Also known as "Data Wrangling", Oracle has added the ability to manipulate a dataset depending on the column data type. By invoking a logical SQL function, Data Visualization does the work for you and can create a new column or edit an existing one. In the top left menu bar, there is an option called Stage. Clicking on it opens the datasource and shows all of the columns present and the first records. Note: If you have more than one file, clicking on the name of the file in the top left will reveal a dropdown menu where you can choose between them.

To edit or add a column, navigate to the right of the column you wish to edit and click on the options icon. This brings up the options menu where you can select from a variety of different options for editing or adding column depending on the datatype. Using the Concatenate function, I was able to create a new column that showed the full name of each customer combined with data in the Age Group column separated by a colon. DV now includes new visualizations including donut charts, text boxes, sunburst, combo, scatter cat.

Also included assuming you have installed and configured Oracle's R distribution is the ability to add clusters, outliers, reference lines, trend lines and forecast. There are two ways to add these to your visualizations. The first is by selecting the Analytics option in the horizontal menu bar on the far right side and then choose the desired function.

Double clicking on a function automatically adds it to your visualization. You can add analytic functions and, depending on the function, there are a variety of different options to change how the function is displayed. You can also add URLs or links to insights within Tiles, Text Boxes and Image visualizations and, if you use Chrome for Windows or Android, there is a dictation option within properties that you can use to add descriptions. One of the more frustrating absences from DV up to this point was the ability to customize colors in your visualizations.

Oracle has not only added this feature but given you the ability to customize and save these customizations, making color conformance for a group of users or across an entire organization a breeze. Let's start by looking at an example of applying color to an entire project. By clicking on the color selection in the Color Series section, you can choose from one of four default selections or create your own custom palette.

Notice how each measure is assigned a color and that color is continuous across the entire project. You can also manage colors from inside of an individual visualization.

From here you can assign colors to each measure individually and it is then displayed across the entire project. In this example, I right clicked on Technology and changed its color which then changed it for every visualization in the project. Oracle added the ability to specify which data source takes precedence over the other when blending two data sources together.

This can be very useful when you have a project that includes data from two data sources and there are match values in one data source that are not in the second. Let's look at an example. I have two data sources. One contains population information and one contains country name and they are matched on the country codes. Notice in the example that there are countries that have no population facts and and population facts that have no countries.