olap cube - MDX Calculated Members with Named Set -


i've calculated member named cwtd (current week date) sales , working need pass named set yesterday.

is possible include named set calculated member don't have pass named set in select statement?

the reason i'm asking power view doesn't show named set in field list.

example:

with member [measures].[cwtd sales test]  sum(             periodstodate(                 [date].[nzlc date].[nzlc week],                 [date].[nzlc date].currentmember             ),               [measures].[net sales - gross ik]         ) select    [measures].[cwtd sales test] on columns,   non empty [product].[product].[product group] on rows [daily sales]    tail(nonempty([date].[nzlc date].[day].members,[measures].[gross sales]),1) 

is there anyway can include part calculated member?

@dan has answered question alternative:

with  set [yesterday]   tail(     nonempty(       [date].[nzlc date].[day].members      ,[measures].[gross sales]     )   ) member [measures].[cwtd sales test]   sum(     wtd([yesterday].item(0).item(0))        ,[measures].[net sales - gross ik]   ) select    [measures].[cwtd sales test] on 0,   non empty [product].[product].[product group] on 1 [daily sales]; 

Comments