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

Using a date calendar

A date calendar is commonly used for users to select a date range. A calendar widget is available in many front-end reporting tools. Many reporting writers prefer to use the calendar widget because it is easy to use in the reporting tool and report users are familiar with it.

Using a date calendar

Getting ready

Dates that come from the calendar widget are typically in the form of strings, for example, 7/29/2016, which might or might not be a valid date member in the Date dimension.

In this recipe, we will show you how to format the dates from the calendar widget in the reporting tool as a valid date member and then create an MDX query to take the ...

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