locked
Unable to create Year and Month filters RRS feed

  • Question

  • Hi, am trying to create a balance scorecard using PerformancePoint Server 2007 Monitoring module. I am having difficulty in creating Filters for Year and Month.

     

    I have below data in SQL Server table:

     

    Objective

    Actual

    Target

    Frequency

    Period

    Customer satisfaction

    10

    20

    Monthly

    Jan

    Customer satisfaction

    20

    20

    Monthly

    Feb

    Customer satisfaction

    15

    20

    Monthly

    Mar

    Financial Growth

    20

    20

    Quarterly

    Q1

    Learning

    15

    20

    Yearly

    FY 2008

     

    Using the above SQL table as Data source, am trying to build a Scorecard in PPS Dashboard designer and publish to Sharepoint. My Customer wants the scorecard to have filters for Year and Month and accordingly the scorecard should refresh as show below.

     

     

     Year: -select-   Month: -select-


    Objective

    Actual

    Target

    Period

    Frequency

    Trend

    Customer Satisfaction

    10

    20

    Jan

    Monthly

    Financial Growth

    20

    20

    Q1

    Quarterly

    Learning

    15

    20

    FY 2008

    Yearly

     


    I tried using Member filters but couldnt achieve the result. Appreciate help from this forum for the problem.

    Thanks,
    Syam Gumpalli
    Wednesday, June 24, 2009 6:48 AM

All replies

  • It doesn't appear that you even have a year and month column to filter on.  Do you even have a time column in the data that you can cofigure the Time settings on your tabular data source?  Looks to me that you would setup a Frequency and Period filter instead or look at setting up a Time dimension column in your tabular data source to accomplish this.


    Dan English's BI Blog
    _____________________________________________________
    Please mark posts as answer or helpful when they are.
    Saturday, August 1, 2009 1:25 PM