Hi guys,

I have this type of a member that takes too long to run:

MEMBER test AS SUM(DESCENDANTS([Dim].[Hierarchy].CURRENTMEMBER, 2), 
TAIL(NONEMPTY({[Date].[Date].&[201406]:[Date].[Date].&[201407]} * [Measures].[Total Market Gross Sales])).ITEM(0))

How can I change it to run faster without moving date filter on WHERE clause?

Thanks!

Hi,

you don't want to put date filter in where clause, it is possible can we put in sub select

with MEMBER test AS SUM(DESCENDANTS([Customer].[Country].CURRENTMEMBER, 2),
TAIL(NONEMPTY({[Date].[Date].&[20061020]:[Date].[Date].&[20061021]} * [Measures].[Internet Sales Amount])).ITEM(0))


select test on 0,
[Customer].[Country].&[Australia] on 1

FROM (SELECT ( { [Date].[Date].&[20061020]:[Date].[Date].&[20061021] } ) ON COLUMNS   //Subcube
from [Adventure Works])

for performance improvement please go through

https://technet.microsoft.com/en-us/library/cc966527.aspx

please correct me if i understand your requirement wrong

Regards,

Manish

This looks like it could be a variation on the problem I describe here:

http://blog.crossjoin.co.uk/2011/03/24/last-ever-non-empty-a-new-fast-mdx-approach/

HTH,

Chris