Essbase Aggregate Storage (ASO) - Incremental Outline Updates Triggers a Full or Light Outline Restructure

When performing incremental updates to an Essbase Aggregate Storage (ASO) outline, depending on the nature of the incremental updates, could trigger either a full or light outline restructure.

When an incremental update triggers a full ASO outline restructure while input data and aggregate views exist in the database, Essbase will clear the aggregate views but the input data will remain.

When an incremental update triggers a light ASO outline restructure while input data and aggregate views exist in the database, Essbase will not clear the aggregate views or input data.

The Essbase Database Administration (DBA) Guide describes what triggers an ASO full vs. light outline restructure. See the following section of the Essbase DBA Guide for more details:

http://docs.oracle.com/cd/E17236_01/epm.1112/esb_dbag/frameset.htm?asysadmn.html#asysadmn1066094

The above section, specifically Table 235 Aggregate Storage Restructuring Levels, will be updated in Essbase v11.1.2.3.000 release documentation to reflect this expected behavior.

This post is only to confirm that depending on the nature of the incremental updates to an ASO outline could trigger a full restructure, which means aggregate views will be cleared; therefore, the performance impact is higher than if the incremental update triggered a light outline restructure.

Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

A blog focused on Tips & Tricks about Oracle Business Intelligence (OBI), Oracle Exalytics and Oracle Enterprise Performance Management (EPM) products.
[Blog Admin: ahmed awan]

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today