locked
MDX QUERY ERROR RRS feed

  • Question

  • wen i execute tis

     

     

    CREATE MEMBER [DEMAND_SUPPLY_REPORT].MEASURES.[Demand Count]

    AS

    '((IIF(ISEMPTY([Measures].[Demand Count]),

    0,

    [Measures].[Demand Count]),

    ( GENERATE([Demand].[DemandCount].CHILDREN,

    [Demand].[DemandCount].CURRENTMEMBER.NAME) )'

     

     

    IT THROUGHS AN ERROR:

    The end of the input was reached.

     

     

    CAN I VE A SOLUTION PLZ!!!!!!!!

    Wednesday, July 30, 2008 11:35 AM

Answers

  • You cannot have a dimension and measures both qualifying the demand count member.  Just use [Measures].[Demand Count New] rather than [Demand_Suppy_report].[measues].[demand count]

    Tuesday, August 5, 2008 5:14 PM