MDX syntax question

hello, starting play customizing of tfs reports , have been able create couple of
simple ones on own. trying head around mdx , learn basic syntax playing of
the box reports. having simple problem , don't understand wrong.
i trying modify remaining work report , add in filter in clause returns items
where exit criteria set false. i.e. [work item].[microsoft_vsts_common_exitcriteria].&[yes]. modified
query looks this.

---start
with
member [measures].[date key] as
    [date].[date].currentmember.uniquename

select
  {
    [measures].[date key],
    [measures].[cumulative count]
  } on columns,
  (
    [work item].[system_state].[system_state],
    (strtomember(@startdateparam):strtomember(@enddateparam))
  )
  on rows
from [team system]
where
(

  strtomember("[team project].[team project].["+@project+"]"),
  strtoset(@iterationparam),
  strtoset(@areaparam),
  strtoset(@workitemtypeparam),
[work item].[microsoft_vsts_common_exitcriteria].&[yes]

)
--end

however when save removes [work item].[system_state].[system_state] return columns. if remove
the last line in clause, puts back. again i'm learning , don't quite have full understanding
of syntax.

thanks,
darren mombourquette

hi darren,

the query designer uses returned data query figure out columns (i.e. fields) include in dataset.  when hit "execute query" inside query designer, see data coming back?  if not, can click on "query parameters" icon make sure values in there return rows back.

thanks,

-j

 

Archived Forums V  >  Team Foundation Server - Reporting & Warehouse