Extract Function MDX RRS feed

  • Question

  • Hi


    ven i execute this


    {[Measures].[Value]} on columns,


    ([Status].[MemberDescription].&[Offer Accepted],

    [Status].[MemberDescription].&[Onboard]) )


    from [Pipeline_Report]


    error tat gets thrown is

    Parsing the query ...

    The 'MemberDescription' hierarchy appears more than once in the tuple.

    Parsing complete



    can i knw wat is te mistake here??????????????

    Friday, July 11, 2008 8:16 AM


All replies

  • [PassRate] is te named set tat im using in te analytical report.

    Friday, July 11, 2008 11:25 AM
  • Hi,


    Can any1 help me work on tis,,,,,,,,



    Very very urgent!!!!!!!!!!!!!!!


    Thanks in advance

    Tuesday, July 15, 2008 10:37 AM
  • The extract function expects different hierarchies separated by commas - you have members not hierarchies in your expression which will not work.


    Wednesday, July 16, 2008 8:41 PM
  • Im using a named set here,which is a hierarchy.

    Can i ve  a eg plzzzzzz

    Sunday, July 20, 2008 11:09 AM
  • See this link:  http://msdn.microsoft.com/en-us/library/ms145980.aspx

    But, I am assuming it would look something like this:



    ([Status].[MemberDescription]) )


    Assuming [PassRate] is a named set on that same hierarchy.
    Tuesday, July 22, 2008 7:10 PM



    I ve gne through tis link well before i posted te query Smile PassRate is a named set tat has members from  a different(InterviewStatus) dimension.

    Wednesday, July 23, 2008 10:37 AM
  • Wednesday, July 23, 2008 10:39 AM