Re: Date Calculation..urgent please

Since the sample Adventure Works cube already has Date in multiple
roles, here's a query to illustrate how to sum the Sales Amount due to
be delivered 1-15 days following the Order Date (which is Jan 16, 2002
for illustration):


With Member [Measures].[SalesDueIn15Days] as
Sum({LinkMember([Date].[Calendar].CurrentMember,
[Delivery Date].[Calendar]).Lead(1)
:LinkMember([Date].[Calendar].CurrentMember,
[Delivery Date].[Calendar]).Lead(15)},
[Measures].[Internet Sales Amount])

select {[Measures].[Internet Sales Amount],
[Measures].[SalesDueIn15Days]}on 0,
{[Delivery Date].[Calendar].[Date].&[201]:
[Delivery Date].[Calendar].[Date].&[215]} on 1
from [Adventure Works]
where [Date].[Calendar].[Date].&[200]



- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***
.

Relevant Pages