O'Reilly logo

MDX with Microsoft SQL Server 2016 Analysis Services Cookbook - Third Edition by Sherry Li, 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 today's date using the string functions

Calculating today's date is one of those problems every BI developer encounters sooner or later. It is also a repeatedly asked question on Internet forums; probably because books do not cover this topic at all, or at least, not with concrete examples.

The Date dimension in the Adventure Works DW 2016 SSAS database has dates only up to December 31, 2014. If we are creating a current date expression, that is, after December 31, 2014, then the expression will not be valid. To overcome this little inconvenience, we will use string functions to only get the day and month of the current date, with the year being shifted to any year we need to.

In fact, this approach can not only explain the concept well, ...

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