How do I specify a calculated member as the default member of an attribute? RRS feed

  • General discussion

  • [This is just for sharing information for those common asked questions collected from forums. If you have any better way or feedback, please directly reply in this thread so that community users can benefit from your answers.]


    If you specify a calculated member as the default member in the properties window, then you will receive an error message. This is because you create the calculated member in MDX Script but process the default member specified in UI before the MDX Script is executed. So you will see the error because no calculated member was found.


    You can use ALTER CUBE statement at the end of MDX Script, or just execute the Script in SSMS:

    Alter Cube

    [Adventure Works]

    Update Dimension [Destination Currency].[Destination Currency],

    Default_Member = [Destination Currency].[Destination Currency].[US Dollar];


    For more information, you can refer to:



    Please remember to mark the replies as answers if they help and unmark them if they provide no help
    Monday, June 21, 2010 1:30 PM