• Below is my MDX query,can you please let me know how do you filter for previous day , week and month...

    SELECT

    {[Measures].[CDR To MTF],[Measures].[Packet Loss],[Measures].[WAN Availability]} ON 0,

    [Dim Site Name].[Dim Site Name].MEMBERS ON 1

    FROM

    [TIMPO - AHLTA Status Report]