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 | RSDHIGHPRECFL |
| Short Description | Process key figure with high precision |
Data Type
| Category of Dictionary Type | D | Domain |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | RS_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 | 5 | Prec. |
| Medium | 16 | High Precision |
| Long | 30 | Key figure with high precision |
| Heading | 30 | Key figure with high precision |
Documentation
Definition
Defining a certain calculation accuracy decides which number format will be used internally for calculating key figures. The level of calculation accuracy can be set in the InfoObject maintenance transaction for each key figure, and in the query monitor for all key figures of a query.
Use
In release BW 7.1 and higher, decimal floating point numbers are used for calculations in the Analytic Engine. This avoids problematic conversions of the data type float from the decimal system to the dual system and the other way round.
There are two levels of precision for decimal floating point numbers:
- Decimal floating point numbers with 16 places (#decfloat16#, #short decfloat#)
- Decimal floating point numbers with 34 places (#decfloat34#, #long decfloat#).
Short decfloats are used by default in the Analytic Engine for numerical data, to minimize the memory requirements for the main memory and the OLAP cache.
If you choose Calculate with High Precision in the query monitor, long decfloats are used instead. Choose this option for application areas where a high accuracy is required (for queries in the accounting and cost accounting areas for example).
The processing effort for long and short decfloats is similar. Due to the higher memory requirements for long decfloats, we advise against using this number format for all query key figures. Only use it for key figures that require a high degree of accuracy.
You have to make this setting in InfoObject maintenance for the corresponding key figure:
- In the Data Warehousing Workbench, choose Modeling -> InfoObjects.
- Choose Edit from the context menu for the key figure.
- To calculate with packed numbers, go to the Additional Properties tab page and choose Key Figure with Maximum Accuracy under Diverse.
Dependencies
Example
History
| Last changed by/on | SAP | 20130604 |
| SAP Release Created in | 730 |
