excel - MDX return caption as value -


i got following mdx query:

select    non empty      [measures].[closed events] on columns  ,non empty      filter     (       {           [date].[year].&[2017]*           ([date].[week number].&[36] : [date].[week number].&[52])*           [visited contact].[contact sf id].children*           [assignee].[role name].&[pl - sales rep hcp]       }      ,       [measures].[closed events] > 0     ) on rows [visit analysis]; 

how influence set within filter have both year , week number represented numbers in excel (data table) , not strings?

what measures?

with member [measures].[year] cint([date].[year].currentmember.name)  member [measures].[weak] cint([date].[week number].currentmember.name)  select    non empty      {[measures].[closed events],[measure].[year],[measure].[weak]} on columns  ,non empty      filter     (       {           [date].[year].&[2017]*           ([date].[week number].&[36] : [date].[week number].&[52])*           [visited contact].[contact sf id].children*           [assignee].[role name].&[pl - sales rep hcp]       }      ,       [measures].[closed events] > 0     ) on rows [visit analysis]; 

Comments

Popular posts from this blog

ZeroMQ on Windows, with Qt Creator -

unity3d - Unity SceneManager.LoadScene quits application -

python - Error while using APScheduler: 'NoneType' object has no attribute 'now' -