Post reply

Concatenating string to measures in MDX query

  • October 23, 2012 at 7:22 pm

    #265966

    Hi,

    I have MDX Query which is

    select non empty { ORDER( TOPCOUNT(NonEmpty({ [Measures].[Date] },( [Measures].[Date] )),1,( [Measures].[Date] )), ( [Measures].[Date] ), BDESC ) } on columns

    from cube

    The output of query is 20121023

    I want output as

    [Date].[Date hierarchy].[Date].&[20121023]

    Is there any way to concatenate string to the date.

  • October 24, 2012 at 2:39 am

    #1552166

    Try...

    member [Measures].[Date String] As

    "[Date].[Date hierarchy].[Date].&[" + CSTR([Measures].[Date].Value) + "]"

    ,non_empty_behavior = [Measures].[Date]

    Mack

  • October 24, 2012 at 2:40 am

    #1552167

    I also do something similar with this sort of MDX

    TAIL(NONEMPTY({[Date].[Month].[All].Children},{[Measures].[Net Revenue]}),1).Item(0).UniqueName

    Mack

  • October 24, 2012 at 7:44 am

    #1552271

    Thanks, I got error as

    Query (1, 36) Parser: The syntax for '"[Date].[Date hierarchy].[Date].&["' is incorrect.

  • October 24, 2012 at 8:04 am

    #1552287

    Can you provide he entire query as the syntax looks okay (have tested it on my cube)? Or have you added this to the cube itself?

    Mack

  • October 24, 2012 at 9:25 am

    #1552328

    it worked..sorry I made a mistake in my syntax.. Thanks!!

Viewing 6 posts - 1 through 5 (of 5 total)

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