Post reply

Different results on different servers for MDX statement with MONTH()

  • September 6, 2017 at 4:05 am

    #149496

    Hi,

    when I use this MDX statement:


    WITH

    MEMBER [Measures].[m_key_month] AS [DimTime].[Month].currentmember.member_key
    MEMBER [Measures].[m_key] AS MONTH([DimTime].[Month].currentmember.member_key)

    SELECT

    {
    [Measures].[m_key]
    ,[Measures].[m_key_month]
    } ON COLUMNS,

    {
    [DimTime].[Month].    members
    } ON ROWS
    F    ROM [Sales]


    I get to different results for the MONTH() function in column m_key from two different server:                                      

    m_keym_key_month
    All#Error0
    January 201511/1/2015
    February 201512/1/2015
    March 201513/1/2015
    April 201514/1/2015
    May 201515/1/2015
    June 201516/1/2015
    July 201517/1/2015
    August 201518/1/2015
    September 201519/1/2015
    October 2015110/1/2015
    November 2015111/1/2015
    December 2015112/1/2015


    m_keym_key_month
    All#Error0
    January 201511/1/2015
    February 201522/1/2015
    March 201533/1/2015
    April 201544/1/2015
    May 201555/1/2015
    June 201566/1/2015
    July 201577/1/2015
    August 201588/1/2015
    September 201599/1/2015
    October 20151010/1/2015
    November 20151111/1/2015
    December 20151212/1/2015

    Both MDX statements are executed on my client pc with the same Management Studio. I thought it has to be with some system settings for date format but I couldn't find anything. Why is this? Where I have to look in order to know how MONTH() works? Or what kind of information do you need more?

    Thanks for your help

  • September 6, 2017 at 4:19 am

    #1958299

    I'd hazard a guess it's the language of the connection you're using. On one it's set to (at a guess) English, but on the other something else (non English).

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • September 6, 2017 at 5:27 am

    #1958307

    I thought the same but I executed both MDX on the same client pc with the same Management Studio. When I connect to the server I can't choose anything to change the language at the "Connect to server" window.
    Also when I look at the Analysis Server properties (right click on the connection) afterwards both have the same collation (Latin_1_General) and language (English (United States)).

  • September 6, 2017 at 5:32 am

    #1958309

    mr_mash - Wednesday, September 6, 2017 5:27 AM

    I thought the same but I executed both MDX on the same client pc with the same Management Studio. When I connect to the server I can't choose anything to change the language at the "Connect to server" window.
    Also when I look at the Analysis Server properties (right click on the connection) afterwards both have the same collation (Latin_1_General) and language (English (United States)).

    The language is set at Server level, rather than client, however, the bold part does answer that.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply