SSAS - MDX N/A issue

• lak3567bo

  SSC Veteran

  Points: 276

  More actions

  August 9, 2017 at 1:26 pm

  #402405
• Hello everyone,
• As a part of my cascadingparameter for SSRS report, I want to show the list of Benefit names associatedto a Group . So here is my MDX query:
• WITH MEMBER[Measures].[ParameterCaption] AS [BenefitGroup].[Standard BenefitName].CURRENTMEMBER.MEMBER_CAPTION 
       MEMBER [Measures].[ParameterValue] AS[BenefitGroup].[Standard Benefit Name].CURRENTMEMBER.UNIQUENAME 
               MEMBER [Measures].[ParameterLevel]AS [BenefitGroup].[Standard Benefit Name].CURRENTMEMBER.LEVEL.ORDINAL 
  SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue],[Measures].[ParameterLevel]} ON COLUMNS ,    
   NONEMPTY([BenefitGroup].[Standard Benefit Name].CHILDREN
   )
      ON ROWS 
          FROM  [Cube]
  where [BenefitGroup].[Group ID].&[5001]&[N/A]

  Results of MDX query are:

• 
• But the Dimension table has 4benefits for the Group:

  select * from DimBenefitGroupwhere GroupID  = '5001' 

• 

  I believe the other 2 benefitdare no puled becuase they have N/A in the Link column. How do I modify my queryto pull all the 4 Benefitnames for the input Group?

  Thank you for your response inadvance!