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
9.94k stars 8.85k forks source link

Where is the file for Adventure works for analysis services 2012? #421

Open johnstaveley opened 6 years ago

johnstaveley commented 6 years ago

This is missing from https://github.com/Microsoft/sql-server-samples/releases/tag/adventureworks-analysis-services. Please can we have it back?

steed360 commented 6 years ago

In the Wideworldimporters simulation I noticed that at after around 2 weeks the values of Warehouse.StockItemHoldings.QuantityOnHand end up being in the 1000s despite the target values being around 100.  I think this is suboptimal if anyone wishes to practice reporting that class of standard distribution KPIs which tend to relate inventory holding cost and value to speed of turnover. Having been unable to locate the exact problem so far, I was wondering if anyone else has noticed this as an issue and has any insight on how to address it.   I'd be happy to share my notes - because I've spent a few days on it - but don't have the debugging skills needed at the moment. ThanksJohn  On ‎Wednesday‎, ‎July‎ ‎4‎, ‎2018‎ ‎03‎:‎24‎:‎58‎ ‎PM‎ ‎BST, John Staveley notifications@github.com wrote:

This is missing from https://github.com/Microsoft/sql-server-samples/releases/tag/adventureworks-analysis-services. Please can we have it back?

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub, or mute the thread.

steed360 commented 6 years ago

In the Wideworldimporters simulation I noticed that at after around 2 weeks the values of Warehouse.StockItemHoldings.QuantityOnHand end up being in the 1000s despite the target values being around 100.  I think this is suboptimal if anyone wishes to practice reporting that class of standard distribution KPIs which tend to relate inventory holding cost and value to speed of turnover. Having been unable to locate the exact problem so far, I was wondering if anyone else has noticed this as an issue and has any insight on how to address it.   I'd be happy to share my notes - because I've spent a few days on it - but don't have the debugging skills needed at the moment. ThanksJohn