Named set to filter Dimension member based on their value or text:
FILTER([License].[Seat Class].ALLMEMBERS,
INSTR([License].[Seat Class].CURRENTMEMBER.MEMBER_CAPTION,'Free') >0 )
The above MDX gives the set of Seat Class containing name like '%Free%'
FILTER([License].[Seat Class].ALLMEMBERS,
INSTR([License].[Seat Class].CURRENTMEMBER.MEMBER_CAPTION,'Free') >0 )
The above MDX gives the set of Seat Class containing name like '%Free%'
No comments:
Post a Comment