O'Reilly logo

MDX with Microsoft SQL Server 2008 R2 Analysis Services: Cookbook by Tomislav Piasevoli

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Calculating the number of days from the last sales to identify the slow-moving goods

Slow-moving or non-moving goods are the inventory which had no sales in a given time frame from today. It is of crucial importance for every company to maintain its inventory levels and to try to sell those two types of inventory even if it means reducing the price because that inventory represents money locked in the system. Timely handling of non-moving or slowly-moving goods releases that money which can in turn be invested in goods with a better turnover rate.

While it's possible to store the pre-calculated number of days from the last sales (or the date of the last sales) directly in dimension table, this is not the best solution. For example, if we use a ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required