Dynamic Target Based Upon TI Filter (Non-Analytics) RRS feed

  • Question

  • I have a KPI, Scorecard and Dashboard based off of a simple SQL table.  The table contains eval information for associates.  They are supposed to have 3 evals per quarter.  The KPI is based off of the COUNT of one of the fields in the SQL table.  Finally, I have a time intelligence filter configured that allows the user to select Y, Y-1, Y-2,Q,Q-1,Q-2,Q-3.

    All of this works fine.  However, I would like to set the KPI target based upon which time filter the user has selected since if they are looking at it by quarter, the Target of the KPI should be 3, but if looking at it by year, the target of the KPI should be 12.  Is this possible?

    Thursday, August 9, 2012 8:04 PM

All replies

  • This can be done by using conditional logic like CASE or IIF on your target column, inspecting the [Dim Time].currentmemeber.level or ordinal and choosing the value to display.

    Friday, August 10, 2012 1:38 PM