Consider the following query.





WITH MEMBER [MEASURES].[RANCE SALES] AS

'SUM(

INTERSECT(

DESCENDANTS([TIME].CURRENTMEMBER, [DAY]),

{[TIME].[DAY].[08-MAY-2003]:[TIME].[DAY].[21-SEP-2003]}

)

, [MEASURES].[SALES])'



MEMBER [MEASURES].[CORR] AS

'Correlation([time].[month].members,(product.currentmember,

product2.[all product2], measures.[RANGE SALES]),

(product2.currentmember, product.[all product], measures.[range sales])'



SELECT PRODUCT.CATEGORY.MEMBERS ON COLUMS,

PRODUCT2.CATEGORY.MEMBERS ON ROWS

FROM SALES

WHERE [MEASURES].[CORR]





I intend to calculate correlation on the time break of months, but

for each month the sales should be within the givien date range,

for e.g the sale of MAY-2003 will be sum from 8th may to 31 may

not the complete may -2003 sales.



will the above query give the results according to my requirement



Thanks


--
Posted via http://dbforums.com