locked
scorecards RRS feed

  • Question

  •  

    thanks for the answer

     

    but what i actually want means,

     

    in scorecard rows i'm having one  KPI's namely  "Sales Amount"  under this i'm having two dimensions "2005", "2006"

     

    in scorecard columns i'm having products as dimensions

     

    with this report i create Trend analysis chart

     

    the chart shows products in x-axis and sales amount in Y-axis

     

    if i choose "sales amount" in scorecard the trend chart shows corresponding to that.if i choose "2005" the trend chart shows corresponding graph for the year of "2005" .if i choose "2006" the trend chart   shows corresponding graph for that.

     

     

    How can i achieve that

     

     

     

    Saturday, January 5, 2008 5:05 AM

Answers

  • Sathiyapriyan,

     

    Are you looking to see a trend of the KPI?  Or a trend of the Measure: Sales Amt that is from a cube that has Sales in it for 2005 and 2006? 

     

    If you create an Analytic Chart Report View from your cube with Product on the x-axis and Sales Amt on the y-axis, and the Time hierarchy in the background, you can create a link from the Scorecard to the Report View based on the 'Member Value: MemberUniqueName', this will show you the product sales for 2005 when you select the KPI row 2005 in the scorecard and 2006 when you select the KPI row 2006.

     

    Shannon

    Monday, January 7, 2008 7:56 PM