SAP ABAP Data Element BSANLY_OP_BIA_PARTITION_FLD (Partition criterion)
Hierarchy
SAP_BS_FND (Software Component) SAP Business Suite Foundation
   CA-EPT-ANL-BIA (Application Component) Operational BIA
     BS_ANLY_OPERATIONAL_BIA (Package) Business Suite Analytics: Operational BIA
Basic Data
Data Element BSANLY_OP_BIA_PARTITION_FLD
Short Description Partition criterion  
Data Type
Category of Dictionary Type D   Domain
Type of Object Referenced     No Information
Domain / Name of Reference Type AQT_PSNAME    
Data Type CHAR   Character String 
Length 8    
Decimal Places 0    
Output Length 8    
Value Table      
Further Characteristics
Search Help: Name    
Search Help: Parameters    
Parameter ID   
Default Component name    
Change document    
No Input History    
Basic direction is set to LTR    
No BIDI Filtering    
Field Label
  Length  Field Label  
Short 10 Partition 
Medium 15 Partition Crit. 
Long 24 Partition Criterion 
Heading 15 Partition Crit. 
Documentation

Definition

Not more than one of the InfoSet's Program Selections can be specified as a partition criterion.        

Use

In order to avoid full loads every time transaction data changes in the operational system, it is helpful to introduce a partition criterion. A good criterion is a characteristic with values describing data slices which, after a certain time, are no longer subject to change. See the example section below.

If you have constructed a partitioned BIA index, and you have loaded several partitions, you can treat these partitions independently. This means that you can delete specific, dedicated partitions without deleting all the data replicated to the BIA index. You can also reload data for specific partitions without the need for a full reload of all partitions.

Dependencies

Partitions must be specified as single values.

If you choose a partition criterion with a character-like data type, the BI Query can only consider the BIA index if you use the same single value restrictions in the query as you have used for replicating. For numeric fields like fiscal year, an interval selection (range) can be considered.

Example

Assume a partition criterion fiscal year has been introduced and partitions 2007, 2008 and 2009 exist in the BIA index.

If, considering your own business operation, only transaction data from fiscal year 2009 is subject to change, you can reload 2009 data to the BIA index independently of the other years. It is not necessary to replicate data of the previous years repeatedly.

If for a previous year (2007, for example), BI Queries no longer request data, and it is no longer necessary to have that data replicated in the BIA index, it is possible to delete that partition independently of the others.

As the fiscal year is a numeric characteristic, a BI Query selecting a fiscal year interval 2007-2009 can consider the BIA index.

History
Last changed by/on SAP  20110908 
SAP Release Created in 702