Hi again,

Problem solved!

The source of the issue was the set DescUmbArtCat which come from a parameter.

There was another selection with [Articlegroup].[Umbrella Art].&[-1]. That's why the DESCENDATS takes so long....

This is the MDX I run:

with

member [Articlegroup].[Umbrella Art].[Other Branded] AS NULL

member [Articlegroup].[Umbrella Art].[Total Branded] AS NULL

member [Articlegroup].[Umbrella Art].[Total Own Branded] AS NULL

member [Articlegroup].[Umbrella Art].[Total] AS NULL

set DescUmbArtCat as

DESCENDANTS(StrToset("{[Articlegroup].[Umbrella Art].&[118],[Articlegroup].[Umbrella Art].&[602]}"),...

I already did this. Profiler shows that the MDX is running slow. Also I've checked the view ExecutionLog3 of the ReportingServices database, and the column TimeDataRetrieval have the much higher...