locked
Time filter threw an error RRS feed

  • Question

  • I have configured the time on my data source like this



    The current date on my system is 10/3/2008. My datawarehouse has data till December 2008.

    I created a filter with members month, month - 1, month - 2

    When I attach the filter to a analytical grid, I get the error

    Exception Message: Data source TestDS has an invalid Time Intelligence configuration.
    Inner Exception Message:
    Stack Trace:    at Microsoft.PerformancePoint.Scorecards.Server.PmServer.GetParameterMessageData(ParameterMessage parameterMessage, Guid parameterSourceId, ParameterMapping parameterMapping, ParameterMessage[] parameterMessages)

    Why am I getting Invalid Time configuration Error?


    Saturday, October 3, 2009 12:23 PM

Answers

  • You didn't make a selection in the Time Aggregation drop down list.  You will want to map your Month member level to the respective Time Aggregation like Months.  Once you have this setup you should be set.  This should work for you, but typically you would have a hierarchy setup in your time (date) dimension that would include Years, Quarters, Months, and Days.  I haven't set this up for a single attribute hierarchy before, but it should work for you since you have specified the hierarchy level of Month.

    Configure time and aggregation for a multidimensional data source
    http://office.microsoft.com/en-us/help/HA102408431033.aspx#1
    Dan English's BI Blog
    _____________________________________________________
    Please mark posts as answer or helpful when they are.
    • Marked as answer by MSDN Student Sunday, October 4, 2009 12:54 PM
    Sunday, October 4, 2009 12:39 AM