Essbase ASO Limitations in 7.x
Ø Level 0 Data Loads only
Ø Data Load Performance
Ø No Time Balancing
Ø No Write Back
Ø No Complexity Calculations
New ASO Features 9.3/9.0/9.2
Ø Improved Restructuring
Ø Data base outline can be changed
Ø Ability to export level 0 data
Ø Kernel Improvements(Data base compression &De hierarchy)
Ø Support for duplicate member names
Ø Extended Substitutional variable support
Essbase 9.3 Release
Ø New ASO Features 9.3
Ø Time Intelligence
Time Balance
Ø Intelligent aggregations
Ø Dynamic ranking
Essbase 9.3.1
Ø New ASO Features 9.3.1
Ø -Concurrent Loads(multiple load buffers on ASO Cube)
Ø -Incremental Loads(Streams /tickled feeds)
Ø -Query Cancellation
Ø -Write Back to level zero(Not documented on 11.1.1)
EPM 11
Ø Partial Data clear
Ø ASO Partial Data Clear is a new option that enables you to
clear a well defined region of the ASO Cube
Ø Two types of clear region are available-
1. Physical clear of cells in region
2. Logical Clear of cells in a region
1. Physical clear of cells in region
2. Logical Clear of cells in a region
Ø Can be achieved by MDX Script.
Syntax.
1.alter database <appname>.<dbname> clear data in region
'{MDX Set Expression}' [physical]
2.alter database ASOSamp.Sample clear data in region '{[Jan]}';
ASO PARTIAL DATA CLEAR BENEFITS
Ø A portion of cube can be erased with out
affecting other data areas.
Ø Data can be cleared by setting the values to 0 can be removed with a
logical clear ,which is faster.
Ø Data that must bepermanently erased can be fully removed with a physical
clear which is slow.
Target of Partition
Previously in version 9.3.1
Ø Full support only for BSO Partioning
Ø ASO Could only be the source of a transparent partition
NEW FEATURE IN 11.1.1
Ø ASO Can be the source of a transparent partition
Ø BSO Can be used for complex calculations
Ø ASO Can be used for aggregation performance benefits.
New Calculation Scripts
New MDX Functions
Write back to level zero (Fully Documented)
ASO TARGET PARTITION BENEFITS
Ø Vertical portioning
Ø Consolidate
Multiple cubes into target.
Multiple cubes into target.
Ø Target provides unified view into multiple source cubes.
Ø Measures with different granularity
Overcomes limitation of write back to upper levels.
Cell can be a level 0
Overcomes limitation of write back to upper levels.
Cell can be a level 0
Ø Member in the source,but an upper level member in the Target
Ø New Calc script functions
Ø New Functions list
Ø New MDX Functions
Ø Julian date(Date)
Converts a given unix date to Julian equivalent
Ø UnixDate(date)
Converts a given julian date to its Unix Equivalent
Ø GetNextDay(Date)
converts a given date to
the next weekday date
