Post reply

MDX what is & symbol?

  • October 19, 2009 at 1:17 pm

    #205794

    Hi,

    I am learning MDX please be lenient with novice's silliness.

    A specific Dimension member can be addressed in two different ways:

    WHERE [Category].[CategoryName].[Hardware]

    or

    WHERE [Category].[CategoryName].&[6]

    Q1. Are they equivalent? If not why?

    Q2. What is the & operator?

    Thanks in advance for any help.

  • October 19, 2009 at 8:49 pm

    #1067923

    Both are the same. The first is the name of the dimension member and the second is the key of the dimension member (this is what the & means). This is most useful when the member name is not unique but the key is.

  • October 20, 2009 at 8:32 am

    #1068244

    Super, thanks very much for your help.

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

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