SAP ABAP Data Element BSANLY_OP_BIA_DELETE_FIRST (Delete data before loading)
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_DELETE_FIRST
Short Description Delete data before loading  
Data Type
Category of Dictionary Type D   Domain
Type of Object Referenced     No Information
Domain / Name of Reference Type SAP_BOOL    
Data Type CHAR   Character String 
Length 1    
Decimal Places 0    
Output Length 1    
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 Delete 
Medium 15 Delete First 
Long 21 Delete Before Loading 
Heading 4 Del. 
Documentation

Definition

  • If the indicator is set, then before replicating new data, the BIA index is dropped and all data records currently replicated are deleted.
  • If the indicator is unset, data which is currently replicated to the BIA index is kept. A new data slice complementary to the one currently replicated is loaded in addition.

Use

If you want to load a data slice to the BIA index which is independent to the one currently replicated, unset the indicator.

Dependencies

If your BIA index is partitioned, and you want to extend the current selection condition, you have to select all current partitions. The global selection condition must not vary among different partitions.

Note:

If you choose the option not to delete data prior to loading (indicator is unset), only a selection complementary to the current selection condition is loaded.

Example

  • In this example, we assume that you do not use partitioning and you currently you have data for company code 0001 in the BIA index:

  1. You want to extend the selection condition to company code 0001 and 0002.
    • The indicator is set:
      • Data in the BIA index is deleted and data is replicated for company code 0001 and company code 0002.
      Data for both company codes is now up-to-date.
    • The indicator is unset:
      • Data for company code 0001 is kept and data for company code 0002 is loaded.
      Data for company code 0002 is now up-to-date, but this may not be true for company code 0001.
  2. You want to reload data for company code 0001 becaue the replicated data is no longer up-to-date.
    • The indicator is set:
      • Data in the BIA index is deleted and data is replicated for company code 0001 anew.
      Data for company code 0001 is now up-to-date.
    • The indicator is unset:
      • Nothing happens. Deletion is not requested, data for company code 0001 is kept, and no new data is replicated.

  • In this example, we assume that you use partitioning, and the partition criterion is fiscal year.

    Currently, you have data for company code 0001 in the BIA index, partitioned into fiscal years 2006, 2007 and 2008.

  1. You want to extend the selection condition to company code 0001 and 0002. It is mandatory to include all existing partitions in the selection, that is 2006, 2007and 2008 in this case. The list of partitions can be extended.
    • The indicator is set:
      • Data in the BIA index is deleted and data is replicated for company code 0001 and company code 0002 and all specified partitions.
    • The indicator is unset:
      • Data for company code 0001 is kept and data for company code 0002 is loaded for the years 2006 - 2008.
      If you extend the list of partitions, for example, create a partition for 2009, then data for company code 0002 is loaded for the years 2006 - 2009. Data for company code 001 is also loaded for 2009. That is, for 2009 both company codes are loaded. In this case, data for company code 0002 is up-to-date for all partitions. Data for company code 001 is up to date for 2009, but may not be for the preceding years, as no new data was replicated there.
  2. You want to reload the 2008 partition, and you do not include the other partitions in the selection. In this case it is not possible to extend the selection condition.
    • The indicator is set:
      • Data in the partition for 2008 in the BIA index is deleted and data is replicated for company code 0001 and fiscal year 2008.
    • The indicator is unset:
      • Nothing happens.

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