Looks like it is a known issue with SSMS 17:
https://connect.microsoft.com/SQLServer/feedback/details/3134389/sql-server-utility-explorer-missing-from-ssms-v17-0

If you could provide the code of your stored procedure, maybe one of us will be able to assist.
It is very difficult to give you an answer without seeing...

Thank you for all the feedback guys.

I'm glad my article was useful ??

Thanks Martin

I will give it a try and see if it resolves the issue.

Kind regards
Paulo

Using human-readable formats (eg. 20160913) for dates and times is a much better approach. These dates can very easily be converted and are much easier to read when one is...

I found the problem.

I wasn't combining PeriodsToDate with ATL into a single SET within the SUM function.

The second SUM line should be as follows:

SUM((PeriodsToDate([Date].[Financial Dates].[Financial Year], ParallelPeriod([Date].[Financial Dates].[Financial Year], 1,...

A good place to look for design tips is the Kimball Group:

http://www.kimballgroup.com/category/articles-design-tips/

Do you need to see the reasons in your "Production.DownTimeReason" table?

If not, you can create a CTE (Common Table Expression) or a #table (temp table), into which you insert the...

Not sure if I understand the problem 100% but perhaps you can join the first two tables using a FULL OUTER JOIN?

You would then see all products that match their...

Just a wild stab in the dark, but I think you want something like this:

SELECT

Orders.OrderDate,

Orders.OrderId,

Orders.OrderNotes,

Orders.Custom_field_vehicleinfo,

Orders.Salesrep_CustomerId,

OrderDetails.ProductCode,

OrderDetails.ProductName,

Products.CustomField4

FROM

Orders

INNER JOIN

OrderDetails

ONOrders.OrderId = OrderDetails.OrderId

INNER JOIN

Products

ONOrderDetails.ProductId = Products.ProductId

WHERE

Orders.OrderStatus IN ('Pending', 'Processing', 'New')

ORDER BY Orders.OrderDate ASC