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.
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]