摘要: 成员百分比分析 函数:CurrentMember、Parent等;分析各城市的销售所占全部城市的总销售额百分比。WITHMEMBER Measures.[Unit Sales Percent] AS '((Store.CURRENTMEMBER,Measures.[Unit Sales]) / (Store.CURRENTMEMBER.PARENT, Measures.[UnitSales])) ', FORMAT_STRING = 'Percent'SELECT {Measures.[Unit Sales], Measures.[Unit Sales Perc 阅读全文
posted @ 2011-04-13 17:32 emmy 阅读(391) 评论(0) 推荐(1) 编辑