i am trying to run an mdx for the latest date per product but at the moment it is giving latest date but our latest date is always a 0, it is normally the day previous that has latest values. Is there a way i can get my mdx to say latest date greater than 0
SELECT NON EMPTY { [Measures].[value] } ON COLUMNS, NON EMPTY {({STRTOMEMBER("[Date].[Date].&["+FORMAT(NOW(),"yyyyMMdd")+"]").Lag(61):STRTOMEMBER("[Date].[Date].&["+FORMAT(NOW(),"yyyyMMdd")+"]")} * [Product].[Product].[Product].&[Shell] * [TFL].[TFL].[TFL].ALLMEMBERS * [ID].[ID].[ID].ALLMEMBERS) } ON ROWS FROM
(
SELECT TAIL(FILTER( [Date].[Date].[Date], NOT ISEMPTY([Measures].[Value]))).ITEM(0) ON COLUMNS FROM [ID/MK]
)
CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS