My MDX code for the report is using a WHERE clause using a named set, which throws the above error complaining about circular reference. I had no clue what it referred to. Google returned with a solution, i.e. you cannot put a named set after WHERE clause. Put the definition of the named SET directly in the WHERE-clause it should work.
Example:
WITH SET [HS Events] AS {
{ [Event Types].[Hierarchy].[Event Type].&[Health & Safety]&[Health & Safety Hazard]
, [Event Types].[Hierarchy].[Event Type].&[Health & Safety]&[Health & Safety Injury/Illness]
, [Event Types].[Hierarchy].[Event Type].&[Health & Safety]&[Health & Safety Near Miss]
, [Event Types].[Hierarchy].[Event Type].&[Health & Safety]&[Health & Safety Plant or Property Damage/Loss] }
SELECT [Measures].[Events Count] ON COLUMNS
FROM Cube
WHERE [HS Events]
Solution:
SELECT [Measures].[Events Count] ON COLUMNS
FROM Cube
WHERE
{ [Event Types].[Hierarchy].[Event Type].&[Health & Safety]&[Health & Safety Hazard]
, [Event Types].[Hierarchy].[Event Type].&[Health & Safety]&[Health & Safety Injury/Illness]
, [Event Types].[Hierarchy].[Event Type].&[Health & Safety]&[Health & Safety Near Miss]
, [Event Types].[Hierarchy].[Event Type].&[Health & Safety]&[Health & Safety Plant or Property Damage/Loss] }