his post describes the Top10 new features in Oracle Business Intelligence Enterprise Edition 11g Release 1 (11.1.1). Some features that are useless like shortcuts, visual format, navigation panels or icons, were not considered in this study.
Let´s begin.
New Feature 1: Key Terminology Changes
In this release, the following terminology changes have been made:
- iBots have been renamed to agents.
- Requests have been renamed to analyses.
- Reports now refers to BI Publisher reports.
- Presentation columns have been renamed to attribute columns.
- Charts have been renamed to graphs.
New Feature 2: New Column Type and Related Operations
In this release, new column type Hierarchical Column is introduced.
Hierarchical Column holds data values that are organized and support the following hierarchy kinds:
- Level-based hierarchy,
- Parent-child hierarchy,
- Ragged or unbalanced hierarchy (in which all the lowest-level members do not have the same depth),
- Skip-level hierarchy (in which certain members do not have values for certain higher levels).
New Feature 3: Enhancements to Views
Several of the view types have been enhanced, including:
- New Table and pivot table functionality, hierarchical columns and drag and drop columns.
- New Slider functionality on graphs and gauges views.
- New Map view type to presents data in spatial form.
- New Master-detail linking of views, which enable to establish a relationship between two or more views such that one view, called the master view, will drive data changes in one or more other views, called detail views.
New Feature 4: Calculated Items and Groups
In this release, you can create a calculated item for the members of an attribute column or of a hierarchical column. 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.
New Feature 5: Multiple Subject Areas
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.
New Feature 6: Interaction with Other Oracle Products
- Oracle BI Publisher is a fully integrated member of the Oracle BI EE suite by default.
- Oracle Hyperion Smart View is available for download from the Oracle BI EE Home page.
- The integration of Oracle BI EE with Oracle Business Intelligence Add-in for Microsoft Office has been enhanced.
New Feature 7: SQL Functions for Time Series Calculations
- PERIODROLLING is a new function that computes the sum of a measure over the period starting x units of time and ending y units of time from the current time.
- AGGREGATE AT is a new function that aggregates columns based on the level or levels specified
- AGO is a time series aggregation function that calculates the aggregated value from the current time back to a specified time period. In this release, the time_level argument is optional, and there are additional syntax changes.
- 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.
New Feature 8: Embedded Database Functions
New supported functions EVALUATE, EVALUATE_AGGR, and EVALUATE_PREDICATE can be directly calling database functions from either Oracle Business Intelligence, or by using a Logical column (in the Logical Table source) within the metadata repository.
New Feature 9: Key Performance Indicators (KPIs)
In this release, you can create KPIs to represent business measures or metrics that you want to monitor, improve, and use to evaluate the performance of the objectives and initiatives that comprise levels of organizational strategy.
KPIs have measurable values that usually vary with time, have targets to determine a score and performance status, include dimensions to allow for more specific analysis, and can be compared over time for trending purposes and to identify performance patterns.
New Feature 10: Oracle Scorecard and Strategy Management
In this release, you can use Oracle Scorecard and Strategy Management to articulate, evaluate (scorecard), and evolve the performance of your organization or key business areas. You can use Oracle Scorecard and Strategy Management to define, depict, and monitor the progress of the strategic goals and requirements (objectives) key to corporate functions, and the tasks and projects (initiatives) that are required to achieve those goals.
Oracle Scorecard and Strategy Management also enables you to either align your objectives and initiatives with traditional balanced scorecard perspectives, or to create your own to reflect your fundamental business competencies. features
New Feature 1: Key Terminology Changes
In this release, the following terminology changes have been made:
- iBots have been renamed to agents.
- Requests have been renamed to analyses.
- Reports now refers to BI Publisher reports.
- Presentation columns have been renamed to attribute columns.
- Charts have been renamed to graphs.
New Feature 2: New Column Type and Related Operations
In this release, new column type Hierarchical Column is introduced.
Hierarchical Column holds data values that are organized and support the following hierarchy kinds:
- Level-based hierarchy,
- Parent-child hierarchy,
- Ragged or unbalanced hierarchy (in which all the lowest-level members do not have the same depth),
- Skip-level hierarchy (in which certain members do not have values for certain higher levels).
New Feature 3: Enhancements to Views
Several of the view types have been enhanced, including:
- New Table and pivot table functionality, hierarchical columns and drag and drop columns.
- New Slider functionality on graphs and gauges views.
- New Map view type to presents data in spatial form.
- New Master-detail linking of views, which enable to establish a relationship between two or more views such that one view, called the master view, will drive data changes in one or more other views, called detail views.
New Feature 4: Calculated Items and Groups
In this release, you can create a calculated item for the members of an attribute column or of a hierarchical column. 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.
New Feature 5: Multiple Subject Areas
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.
New Feature 6: Interaction with Other Oracle Products
- Oracle BI Publisher is a fully integrated member of the Oracle BI EE suite by default.
- Oracle Hyperion Smart View is available for download from the Oracle BI EE Home page.
- The integration of Oracle BI EE with Oracle Business Intelligence Add-in for Microsoft Office has been enhanced.
New Feature 7: SQL Functions for Time Series Calculations
- PERIODROLLING is a new function that computes the sum of a measure over the period starting x units of time and ending y units of time from the current time.
- AGGREGATE AT is a new function that aggregates columns based on the level or levels specified
- AGO is a time series aggregation function that calculates the aggregated value from the current time back to a specified time period. In this release, the time_level argument is optional, and there are additional syntax changes.
- 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.
New Feature 8: Embedded Database Functions
New supported functions EVALUATE, EVALUATE_AGGR, and EVALUATE_PREDICATE can be directly calling database functions from either Oracle Business Intelligence, or by using a Logical column (in the Logical Table source) within the metadata repository.
New Feature 9: Key Performance Indicators (KPIs)
In this release, you can create KPIs to represent business measures or metrics that you want to monitor, improve, and use to evaluate the performance of the objectives and initiatives that comprise levels of organizational strategy.
KPIs have measurable values that usually vary with time, have targets to determine a score and performance status, include dimensions to allow for more specific analysis, and can be compared over time for trending purposes and to identify performance patterns.
New Feature 10: Oracle Scorecard and Strategy Management
In this release, you can use Oracle Scorecard and Strategy Management to articulate, evaluate (scorecard), and evolve the performance of your organization or key business areas. You can use Oracle Scorecard and Strategy Management to define, depict, and monitor the progress of the strategic goals and requirements (objectives) key to corporate functions, and the tasks and projects (initiatives) that are required to achieve those goals.
Oracle Scorecard and Strategy Management also enables you to either align your objectives and initiatives with traditional balanced scorecard perspectives, or to create your own to reflect your fundamental business competencies. features
No comments:
Post a Comment