Planning Analytics

 View Only
Expand all | Collapse all

Modifying Language setting in ODBC

  • 1.  Modifying Language setting in ODBC

    Posted Fri September 27, 2019 08:00 AM
    How can we insist the ODBC to use a specific language(say Norwegian). 


    I am using a view to import data from database into a cube , which contains date functions in format DD-MON-YYYY (ex: 01-DEC-2019 ). This is working as expected in SQL Server. In Norwegian , it would be 01-DES-2019 (Desember) and I want it to be 01-DES-2019. 

    My ODBC takes it only in English and I want to whether it is possible to change the locale settings for ODBC. 

    I have changed the Language as 'nor' in tm1s.cfg. 
    Server : linux

    Any thoughts??

    Thanks

    ------------------------------
    Manikandan Moorthy
    ------------------------------

    #PlanningAnalyticswithWatson


  • 2.  RE: Modifying Language setting in ODBC

    Posted Mon October 07, 2019 08:08 AM
    Hi Manikandan,

    I'm not aware of how to change the date format in an odbc driver configuration. Usually the format is to be changed on the database side or the application side.

    But if you're saying that the odbc driver is making this change because of the english driver then:
    - might be good to connect with Microsoft on this to understand if there's another driver.
    - test this driver against another application just to make sure that this is the driver doing this.

    Kind Regards,

    ------------------------------
    Robert VAUTOUR
    ------------------------------

    Original Message