SAP ABAP Data Element RSDHIGH_CARD_CHA_UI (Characteristic with high cardinality (more than 2 bio recs.))
Hierarchy
SAP_BW (Software Component) SAP Business Warehouse
   BW-WHM-MTD (Application Component) Metadata (Repository)
     RSD (Package) BW: Data Basis InfoObjects and Core Services
Basic Data
Data Element RSDHIGH_CARD_CHA_UI
Short Description Characteristic with high cardinality (more than 2 bio recs.)  
Data Type
Category of Dictionary Type D   Domain
Type of Object Referenced     No Information
Domain / Name of Reference Type XFELD    
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 High Card. 
Medium 20 High Cardinality 
Long 30 High Cardinality 
Heading 40 High Cardinality 
Documentation

Definition

Use

Only use the High Cardinality option if you expect that the SID number range of 2 billion will not be sufficient. Otherwise create the characteristic without the high cardinality property.

If the High Cardinality property is set, the characteristic does not have persistent SID values or an SID table. This implies that it can only be used in InfoProviders that store the key value and not the SID value of the contained characteristics.

Restrictions:

High cardinality characteristics cannot be used

  • in InfoCubes
  • as a compounding parent
  • as a navigation attribute
  • in hierarchies

The high cardinality property is only supported for data type CHAR and NUMC with length >= 10.

Dependencies

During reporting, SID values need to be created as local SIDs as required. Therefore the response times of queries might be impacted.

Example

History
Last changed by/on SAP  20141013 
SAP Release Created in 740