search

microsoft / sql-server-samples

Azure Data SQL Samples - Official Microsoft GitHub Repository containing code samples for SQL Server, Azure SQL, Azure Synapse, and Azure SQL Edge
Other
10k stars 8.86k forks source link

WWI-SalesOrders.pbix - Invalid object name 'Website.SalesOrders'. #391

Closed Pietervanhove closed 6 years ago

Pietervanhove commented 6 years ago

Hi Jos,

When I open the WWI-SalesOrders.pbix file and connect to my WideWorldImporters database (fresh copy I've just downloaded), I get an error message:

Error Message: Invalid object name 'Website.SalesOrders'.. The exception was raised by the IDbCommand interface.

When I check the sys.objects I can't find the object. Am I missing something or is the backup file not up to date?

Best Regards Pieter Vanhove

jodebrui commented 6 years ago

You need to install the sample databases from source code, because some of the views the dashboards depend on have not yet made it to the released version of the sample databases. I updated the readme for the dashboards to call this out.

wcmchan commented 5 years ago

HI Jobdebrui followed your instruction "install the sample DB from source code", but seem that not work . Object not found Website.SalesOrders. I have recreated the database using scripts under ...\samples\databases\wide-world-importers\ folder. please advise, thank you

FatherOSam commented 5 years ago

Message=Invalid object name 'Website.SalesOrders' Can someone just publish the design for this view ?

jwilki1 commented 3 years ago

I am getting this error as well Microsoft SQL: Invalid object name 'Website.SalesOrders'.

How do I create this view, user parthor and https://github.com/prthor/wwi-related/tree/master/wwi/views no longer exist. I know this is an old thread but it is still an issue in 2021.

Thank you for any assistance!

mvanreek commented 10 months ago

It looks like this issue is not solved yet (24/11/2023), but to have at least some data in the report, I changed the 2 queries:

1 Sales SELECT SO.OrderID, OrderDate, NULL AS OrderNumber, NULL AS CustomerName, NULL AS DeliveryLocation, NULL AS SalesPerson, SUM(Quantity UnitPrice) AS OrderPrice FROM Sales.Orders SO JOIN Sales.OrderLines SOL ON SO.OrderID=SOL.OrderID GROUP BY SO.OrderID, OrderDate

2 LastDaySales SELECT SO.OrderID, OrderDate, NULL AS OrderNumber, NULL AS CustomerName, NULL AS DeliveryLocation, NULL AS SalesPerson, SUM(Quantity UnitPrice) AS OrderPrice FROM Sales.Orders SO JOIN Sales.OrderLines SOL ON SO.OrderID=SOL.OrderID WHERE OrderDate >= DATEADD(day, -1, CAST(SYSDATETIME() AS date)) GROUP BY SO.OrderID, OrderDate