locked
MDX in Data source Mapping Problem RRS feed

  • Question

  • Hi all,
    I have added the following MDX in Datasource mapping
    SUM
    (PeriodsToDate([Time].[Year - Reporting Quarter - Reporting Month - Reporting Week - Reporting Day].[Reporting Year],[Time].[Year - Reporting Quarter - Reporting Month - Reporting Week - Reporting Day].CurrentMember ),[Measures].[Utilization])

    it is working fine,but when I add aggregate function

    AGGregate(PeriodsToDate([Time].[Reporting Year - Reporting Quarter - Reporting Month - Reporting Week - Reporting Day].[Reporting Year],[Time].[Reporting Year - Reporting Quarter - Reporting Month - Reporting Week - Reporting Day].CurrentMember ),[Measures].[Utilization])

    I didn't get anything only error in the cell
    Utilization is kpi from AS2005

    Utilization(KPI)---Actual/Goal/Trend/Cummulative
    Cummulative I have added in the Dashboard designer,when I entered MDX for Agg function I am getting error in the cummulative cell

    Give me the solution to rectify.

    Thanks,
    Ravitamil

    Tuesday, March 31, 2009 6:44 PM