How can I show kpi's to final user?

How can I show kpi's to final user?

• dukesta3

  You can use Excel 2007 (Office 2007 Beta 2 was anoounced earlier this week), which has built-in support for AS 2005 KPI's:

  http://blogs.msdn.com/excel/archive/2006/01/10/511487.aspx

  >>

  In Excel 12, KPIs are listed in the field list in a special KPIs folder.  Here is an example of a KPI for Profit Margin.

  
  (Click to enlarge)

  Each KPI component can be added to the PivotTable Values area by checking the checkbox just like any other field.  Let’s take a look at an example, specifically, and example of adding Value, Goal, Status, and Trend to a report on our Products and Product Categories.  Here is what the report looks like when I add those four components.

  
  (Click to enlarge)

   

  
  
  

• DouglasL

  Thanks Deepak!
  
  

• stentoner

  Deepak Puri wrote:

  You can use Excel 2007 (Office 2007 Beta 2 was anoounced earlier this week), which has built-in support for AS 2005 KPI's:

  it would be nice if in the future we would be able to use cube features that are actually usable with RTM versions of software.

  Asking a business user to go with a beta version is not an option and creating nice cube stuff that is not usable is frustrating.

  Now, The question I am asking is what features are revealed by the PTS9 as opposed to the Excel version Which one is allowing what

  Example; I would like to use sets not only internaly in the cube calculations but also at the front-end level in Excel 2003. Doable

  When my company will upgrade to Excel 2007, we will be in 2009-20010 and at that time cubes will have features that will require Excel 2015 :-)

  Thanks,

  Philippe

  
  
• How can I show kpi's to final user?