SSAS 2008 MDX Query -Member properties access in a Query
friends , have below mentioend query mdx query : with member [last3monthsavg_sale] sum([last3monthdays],[measures].[sale qty])/3 member [last3monthsavg_prod] sum ([last3monthdays],[measures].[tot_unq_prod_out]) /sum([last3monthdays],[measures].[cov_tot_unq_out]) member [last3monthsavg_cov] sum ([last3monthdays],[measures].[tot_unq_cov_out]) /sum([last3monthdays],[measures].[cov_tot_unq_out]) member [gpil_perm] sum([last3months],sum(iif([measures].[perm_merch_qty]=0,null,[measures].[perm_merch_qty]),[product].[company-product].[company].&[3] )) member [prodcat_uniquename] strtomember(@prodcat).uniquename member [wd_uniquename] [outlet].[region].currentmember.uniquename member [number_outlets] as filter(descendants([outlet].[region].currentmember,[outlet].[region].[outlet]),[sale_qty_mtd] >0).count select {[number_outlets],[wd_uniquename],[sale_qty_mtd], [prodcat_uniquename],[measures...