Hierarchy
⤷ 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 |