locked
Errors in the metadata manager. The data type of the 'AirlineCode' measure is not valid because the data type of the measure is a string type RRS feed

  • Question

  • Hi Team,

    Am building a new SSAS multidimensional cube with fact and dimension tables.

    In my fact table few of the fields data type is string.

    Fields name like AirlineCode, Country Code.

    While adding those fields to my measures list am getting bellow error message. Please help on same

    Errors in the metadata manager. The data type of the 'AirlineCode' measure is not valid because the data type of the measure is a string type


    Thanks Bala Narasimha

    Monday, September 30, 2019 11:00 AM

Answers

  • Yes, a measure is an aggregation of numeric data values, such as sum, count, minimum, maximum, average, or a custom MDX expression that you create. The source is mainly from numeric columns in fact tables in an external data warehouse.

    Measures

    Create Measures and Measure Groups in Multidimensional Models

    Best Regards,

    Will


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • Marked as answer by BaluChalla Tuesday, October 1, 2019 9:08 AM
    Tuesday, October 1, 2019 7:18 AM

All replies

  • What would you aggregate/calculate on a string measure beside a simple count? No, you can mainly use only numeric data types for measures.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Monday, September 30, 2019 11:08 AM
  • Yes, a measure is an aggregation of numeric data values, such as sum, count, minimum, maximum, average, or a custom MDX expression that you create. The source is mainly from numeric columns in fact tables in an external data warehouse.

    Measures

    Create Measures and Measure Groups in Multidimensional Models

    Best Regards,

    Will


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • Marked as answer by BaluChalla Tuesday, October 1, 2019 9:08 AM
    Tuesday, October 1, 2019 7:18 AM
  • Thanks for your response.

    am making changes as per your suggestions. 


    Thanks Bala Narasimha

    Tuesday, October 1, 2019 9:08 AM