Add Measure Filters in the Scorecard RRS feed

  • Question

  • Hi,

        While Creating the Scorecard There is an "Add Measure Filters Page".

         e.x: In that page i have given "Date.Calender" in the Dimension "Select a Dimension for the Measure Filters" and
               "Year" in the  "Select a Members for Actual Measure Filters" and "Select a Members for Target Measure Filters".
             After creating the Scorecard  i dn't knw what its happening by using the Member Filters.
          what is the use of that? its actually the filter for the scorecard.

    Wednesday, February 20, 2008 2:10 PM

All replies

  • Once you have created a filter on the Filter Page of a dashboard, you can drag that filter into a zone on your dashboard to filter various views by the information in your "Date.Calendar" dimension.  In order to do this, you will have to create a Filter Link between the Filter and either a Scorecard or a Report View. 

    Here's some information from the Help file on creating Filter Links:


    To link filters to dashboard elements

    1. In the Workspace Browser, double-click the name of the dashboard that you want to modify.

    2. On the Editor tab, view the items that have been added to the dashboard.

    3. From the Details pane, drag a filter to a dashboard zone. Where you put the filter is where it will display on the deployed dashboard.

    4. On the filter, click the DOWN ARROW and select Create Link. The Filter Link Editor will display.

    5. On the Link Items tab, select the dashboard item to link to the filter.

    6. Click the Link Options tab.

    7. From the Dashboard item endpoint box, specify where you want filter values to appear in the linked dashboard item.

    8. From the Source Value box, select the value such as Display Value or MemberUniqueName to use the deployed dashboard. Source Value options vary by type of filter or report.

      You must use MemberUniqueName to link to any analytic data source, such as a scorecard, an Analytic Chart or Grid, a Pivot Chart or Pivot Table, and so on.

    9. (Optional) Click Filter Link Formula if you want to use a custom query. The language that you use is dictated by the data source. For example, you can use MDX or a TI time formula.

    10. Click OK.

    Wednesday, February 20, 2008 3:14 PM