How To Fix RSDHA179 - Column '&1' has to be registered as a key figure


RSDHA179 - Overview

  • Message type: E = Error

  • Message class: RSDHA - HANA Analysis in BW

  • Message number: 179

  • Message text: Column '&1' has to be registered as a key figure

  • Show details Hide details
  • What causes this issue?

    Output column &V1& is registered as a characteristic, but the data type
    of this output column is not valid for characteristics.

    System Response

    The registration procedure is cancelled.

    How to fix this error?

    You have two options. You can either register the output column as a key
    figure or you can change the data type of the output column.
    The data types for characteristics and key figures are listed below:
    ABAP data types for characteristics:
    CHAR,,- Character String
    STRG,,- String
    NUMC - Character string with only digits
    DATS - Date field (YYYYMMDD) stored as char(8)
    TIMS - Time field (hhmmss), stored as char(6)
    ABAP data types for key figures:
    DEC - Decimal Floating Point
    FLTP - Floating point number, accurate to 8 bytes
    INT4 - 4-byte integer
    The following SQL data types are supported:
    The following SQL data types are supported:
    TINYINT is mapped to INT4 (key figure),,
    SMALLINT is mapped to INT4,,(key figure),,
    INTEGER is mapped to INT4 (key figure),,
    DECIMAL is mapped to DEC (key figure)
    FLOAT is mapped to FLTP (key figure)
    DOUBLE is mapped to FLTP (key figure)
    CHAR is mapped to CHAR (characteristic)
    VARCHAR is mapped to STRG,,(characteristic)
    NVARCHAR is mapped to CHAR (characteristic)
    DATE is mapped to DATS (characteristic)
    TIME is mapped to TIMS (characteristic)

    The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

    Procedure for System Administrators


    Error message extract from SAP system. Copyright SAP SE.


Smart SAP Assistant

  • What is the cause and solution for SAP error message RSDHA179 - Column '&1' has to be registered as a key figure ?
    The SAP error message RSDHA179 indicates that a column in your InfoProvider (such as an InfoCube or DataStore Object) is being used in a way that requires it to be defined as a key figure, but it has not been registered as such. This typically occurs in the context of SAP BW (Business Warehouse) when working with data modeling and reporting.
    
    Cause: The error arises when: A column (characteristic) is being treated as a key figure in a query or report, but it has not been defined as a key figure in the InfoProvider. The data model is not correctly set up to reflect the intended use of the data, leading to inconsistencies in how data is processed and reported.
    Solution: To resolve this error, you need to ensure that the column in question is properly defined as a key figure in the relevant InfoProvider. Here are the steps to do this: Access the Data Model: Go to

    Already have an account? Login here!




Instant HelpGet instant SAP help. Sign up for our Free Essentials Plan.


Related SAP Error Messages

Click the links below to see the following related messages:

Click on this link to search all SAP messages.


Rating
ERPlingo simplifies finding the accurate answers to SAP message errors. I now use every week. A must have tool for anyone working with SAP! Highly recommended!
Rate 1
Kent Bettisworth
Executive SAP Consultant