Hi, I have a dimension "mill name" for which I have production data measures in the same cube. The problem I have is that there are some days where a mill does not produce any product and their row is therefore missing in the tablix I have created to summarise the production data per mill. The customer would like to see every mill in the tablix, even if they have not produced anything. This is almost asking for an out-left-join on the cube dimension! How is this possible? Any advice would be greatly received. Thanks in advance Steve

Make sure to check the "Show Empty cell" check box in the query designer Or Remove the "NONEMPTY" keyword from your MDX query.