SSAS Tabular Cube: Character case is getting changed RRS feed

  • Question

  • Hi Team,

    In our project we are using SSAS Tabular Model, where the source is Hive Database.

    In Hive Table, we have a field called CountryName with Data like (United States, South Africa, new zealand etc)

    While processing the cube, the case character of the data is changing for some values(from upper case to lower case) in the Countryname field like below.

    • United Sates  --which is correct
    • south africa -- the case of the characters got changed which is the issue ( from S to s and A to a)
    • new zealand -- which is correct

    Could you please help me with the above issue.

    FYI: i have verified the field properties and it looks fine for me.



    Thursday, December 3, 2020 8:10 AM


  • I'd try asking for help over here.

    sql-server-analysis-services - Microsoft Q&A



    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows Server] Datacenter Management

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.

    • Marked as answer by SantoshKumarS Thursday, December 3, 2020 1:52 PM
    Thursday, December 3, 2020 12:27 PM

All replies