SQLTeam.com | Weblogs | Forums

Convert Mdx query to Sql query


#1

with member [Measures].[KA_performance] as sum([keyassignment].[ID].members,[Measures].[avg outcome score]) select [Measures].[KA_performance] on 1,[Academic Year].[CatalogYear].members on 0 from OutcomesPerformance where {Filter([Outcome].[Title].members,instr(",{value0},","," || [Outcome].currentmember.name || ",") > 0)}