Post reply

MDX syntax

  • January 19, 2010 at 9:30 pm

    #137504

    Can anyone please tell me when to use '{' and '(' while writing mdx queries. Any suggestions would be highly appreciated.

  • January 19, 2010 at 9:57 pm

    #1105822

    brackets (or for ppl like me, 'square brackets') for member names and dimension names --> [steve]

    braces (or curly brackets/braces) '{' for sets --> {mySet}

    parentheses (or 'round brackets' for ppl like me 😉 '(' for tuples --> ([dim1].[steve], [dim2].[notSteve])

    for some online reading, try hitting msdn (here)

    for some paper (or electronic now too) try Fast Track to MDX, by Rob Zaire and Mosha et al

    HTH

    Steve.

  • January 21, 2010 at 11:09 am

    #1106854

    Thanks a lot!!1

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

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