locked
Extract Function MDX RRS feed

  • Question

  • Hi

     

    ven i execute this

    select

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

    EXTRACT([PassRate],

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

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

    ON ROWS

    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

Answers

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:

     

    EXTRACT([PassRate],

    ([Status].[MemberDescription]) )

     

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

    Hi,

     

    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