 Oracle Essbase
Oracle Essbase is an OLAP (Online
Analytical Processing) Server that provides an environment for
deploying pre-packaged applications or developing custom analytic and
enterprise performance management applications. Oracle Essbase, along
with Oracle BI Suite Enterprise Edition Plus, is part of the Oracle BI
Foundation.
With a rapid application
development environment, Essbase enables business users to quickly
model complex business scenarios. Aside from its high scalability, a
key strength of Essbase lies in its ability to allow users to "write
back" to an application's data repository under security. This makes it
ideal for developing forward looking applications such as forecasting,
scenario modeling, and "what if" type analysis.
 With Oracle Essbase,
organizations define a dimensional view of their business—and
provide business users with new levels of self-sufficiency to access,
navigate, and gain actionable insight into critical business issues.
All of this through the various end-user tools for Essbase. For
example, Oracle Hyperion Smart View for Office (Excel, PowerPoint,
Word, and Outlook), Oracle Essbase Visual Explorer, and Oracle BI Suite
Enterprise Edition Plus, including Dashboards, Answers, Hyperion
Interactive Reporting, Hyperion Web Analysis, Hyperion Financial
Reporting, are some of the various Oracle tools that enable users to
interact with an Oracle Essbase application.
Oracle Essbase provides adaptable
data storage mechanisms for specific types of analytic and performance
management applications, thereby ensuring sub-second response times
regardless of the complexity of the analytics. For example, Block data
storage option (BSO) enables driver-based scenario modeling,
forecasting, and predictive analytic applications. Aggregate data
storage option (ASO) is optimized for massive sparse data sets,
supporting thousands of concurrent business users performing
sophisticated analyses at the speed of thought.
With the release of Oracle
Essbase 11 there is now stronger integration with the both Oracle
Fusion Middleware technologies as well as Oracle Database 11g. |
What's New
Oracle Essbase V.11.1.1 Release Highlights
- Single Environment to Build
and Maintain Essbase Cubes- Essbase Studio provides a single
interface for performing tasks related to data source modeling, cube
design, and construction of analytic applications. Seehttp://www.oracle.com/technology/products/bi/essbase/studio.html
- New Installation and
ConfigurationEssbase is now integrated into the EPM System
Installer, to streamline the installation of all EPM products within
one tool.
- Lifecycle Management- Provides a consistent, repeatable way to move Essbase cubes,
applications, or individual artifacts between development, test and
production environments. Also supports auditing and application
comparisons.
- Varying Attributes- Support for storing data in attributes that vary over one or more
dimensions, and calculate measures over the varying attributes.
- Typed Measures-
extends the analytical capabilities of Essbase beyond numerical data to
support for two new data types: text measures and date measures.
Applications can now use text and dates as measures in multidimensional
reporting. Essbase applications can now support analysis based on text
or date measures.
- Backing Up and Restoring
Block Storage Option (BSO) Databases- enables administrators
to back up and restore databases more efficiently.
- Transaction Logging and
Replay- a backed-up database can be restored to a specified
post-backup state by replaying transactions related to data loads, data
updates, and calculation (procedural)_scripts.
- Clearing Data from Specific
Regions of Aggregate Storage (ASO) Databases- clear data from
a specific region and retain the data located in other regions, such as
historical data.
- Environment Variables Used
in the Calculation Scripts and Formulas of Block Storage Option (BSO)
Applications- supports use system environment variables as
placeholders for user-specific system settings in calculation scripts
and outline member formulas
- New Calculation Functions- The following calculation functions are new in this release:
- @ILANCESTORS—Returns the
specified members and either all ancestors of the members or the
ancestors up to a specified distance
- @ILDESCENDANTS—Returns the
specified members and either all descendants of the members or the
descendants down to a specified distance
- @LANCESTORS—Returns all
ancestors of the specified members or the ancestors up to a specified
distance
- @LDESCENDANTS—Returns all
descendants of the specified members or the descendants down to a
specified distance
- @NEXTSIBLING—Returns the
next sibling (the sibling to the immediate right) of the specified
member
- @PREVSIBLING—Returns the
previous sibling (the sibling to the immediate left) of the specified
member
- @SHIFTSIBLING—Returns the
specified member or the nth sibling of the specified member
- Grid Expansion During
Queries of Transparent Partitions- forces the expansion of
the grid when transparent partitions are queried.
- Log Transaction Response
Times from Transparent Partition Target- log transaction
response times to monitor performance and satisfy service level
agreements with user communities.
- Grid Size Limits for
Aggregate Storage Transparent Partition Target- in ASO,
specify the maximum size of the request grid and the response grid.
- Target of Partition- An ASO cube can be a target of a transparent or replicated partition
for aggregation performance benefits.
- Batch Insertion As Data Is
Exported to Relational Databases- supports direct INSERT when
exporting data from Essbase into a relational database.
- Unicode Support for
Aggregate Storage
- Query Cancel-
;cancels execution of processes such as data load, MaxL, MDX, Calc
Script and others in Administration Services:
- Smart Search Administration
Enhancements- Advanced configuration of Google OneBox and
Oracle Secure Enterprise Search (SES) functionality including the
ability to select report scripts, calc scripts for metadata indexing.
- MDX Enhancements-
improvements to MDX time intelligence and member and hierarchy
calculations.
- XOLAP - eXtending OLAP on
Relational Database- support for Essbase cube that is
transparently and dynamically sourced from an RDBMS. Greatly increases
the potential size and scope of an Essbase cube through the use of a
hybrid aggregation strategy. RDBMS friendly with fewer, simpler, more
efficient SQL queries from Essbase to the RDBMS.
- Parallel SQL Data Loads- Supports up to 8 rules files via temporary load buffers.
- Oracle EBS Financials 11iSource Integration and Drill-back- when Essbase is used with
Hyperion Financial Data Quality Management, can now support drill back
into Oracle EBS to see account balances and drill even further from
there. This feature adds even further confidence in a customer's
financial data.
- Better Integration with
Oracle Fusion Middleware- further adoption of key components
of Oracle Fusion Middleware to provide lowest total cost of ownership.
- Security: Integration with
Oracle Access Manager, Oracle SSO, Desktop Kerberos Support, OID as the
Native Provider
- Systems Management, integration
with System Installer, Oracle Patch Installer, Lifecycle Management,
Auto Deployment to Oracle Application Server
- Support for Oracle Data Integrator
(ODI)
What's New In Oracle Essbase Release 11.1?
Oracle Essbase, Release 9.3
Highlights
- Supports dates as first class objects
- Time dimension wizard automates
creation of time dimension hierarchies within Essbase ASO databases
- Out of the box support for five
predefined calendars: Gregorian, Manufacturing, ISO 8601, Fiscal, Retail
- Supports query hints for frequently
used queries
- MDX optimizations:
- New functions enhance string
processing
- Handling formulae that involve
tuple/cross dimensional references
- Ranking tuples in sets
- Analysis of date hierarchies
- Supports high speed subset data
export:
- Data slices (including dynamic
calc members and aggregates) can be selected and exported lights out in
a number of different formats including directly into relational tables
- This feature is calculation
script enabled
- Expanded 64-bit support for AIX and
Sun Solaris
- "Reference cubes" improve @XREF
performance
- EXCLUDE / ENDEXCLUDE construct
allows calculation scripts to specify which members NOT to calculate
- MAXL has been enhanced to provide a
means to encrypting usernames and passwords in scripts
What's New in Hyperion Essbase Release9.3?
|
Bookmark
