CODEWITHSUNDEEP
iccubeiccube-reporting
Jack Shade
Jack Shade

Reputation: 501

IcCube Gantt Chart: How do I properly set up the MDX part for reporting?

How do I properly set up the MDX for a Gantt Chart, when I want to display a duration (start and end date) for several projects?

Currently, there is no documentation provided.

Upvotes: 1

Views: 47

Answers (1)

pinkpanther
pinkpanther

Reputation: 139

You need to have a start date, end date and a duration measures:

SELECT

  {[Measures].[start date],[Measures].[end date],[Measures].[duration]} ON 0,

  [Project].[Project].[projects].allmembers ON 1

FROM [Gantt]

Upvotes: 1

Related Questions