I need to find MAX day (lowest level member) in Time dimension where a
particular metric in my Cube > 0
Here is what i have
I need to know if there is a better way to do this

with
member [measures].[systime] as '[measures].[inbound_system_time_Hours] +
[measures].[Adjusted_Outbound_System_Time]'
set [timeset] as '{
Tail(Filter (Descendants(Time.[All Time], [Time].[Day]),
[measures].[systime] > 0), 1) }'
select {[measures].[systime]} on columns,
{ [timeset] } on rows
from unifinal_web
where ([Function].[All Function].[01003])

If your particular metric is a real measure instead of a calculated
measure...then you can do a NonEmptyCrossjoin between it and the
members of the Day...also using the Tail function to get the last. The
NonEmptyCrossjoin should be faster for those cases.