Surely it depends on the requirement!

KPIs are normally an indication of how a measure is performing against
either a fixed or moving target. This is a calculation hence you will need a
calculated member.

Regards
Jamie Thomson
http://www.conchango.com


"Pratibha Agrawal" wrote:

SQL Server 2005 supports KPI's defined at the server:

http://www.microsoft.com/technet/pro...uate/dwsqlsy.m
spx

Analysis Services 2005 introduces a Key Performance Indicator (KPI)
framework, for server-side definition of calculations to measure your
business. These KPIs will be displayed in reports, portals, and
dashboards, through data access APIs and Microsoft and 3rd party tools.
For Beta 2, there are no client tools available that display KPIs.

Different commentators and vendors use the phrase "KPI" to refer to
different concepts. For Microsoft SQL Server Analysis Services 2005, a
KPI is precisely defined in four steps:

• Value to be measured: a physical measure such as Sales, a calculated
measure such as Profit, or a calculation that is defined within the KPI,

• Goal for the value: a value (or MDX expression that resolves to a
value) that defines the target for the measure,

• Status: an MDX expression to evaluate the current status of the value,
as a normalized value in the range -1 (very bad) to +1 (very good),

• Trend: an MDX expression to evaluate the current trend of the value.
Is the value getting better or worse relative to its goal?
...
The Office Business Scorecards Acclerator also sets up a specific
framework for defining KPI's using MDX:

http://www.microsoft.com/office/solu...recards/overvi
ew.mspx


- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

hi,
i know KPI theory but can anybody suggest any of its exmaple or how to
perform it using mdx query.

Thanks in advance

Thanks deepak and jamie..
actually i asked for some example that how to implememnt kpi.. but never
mind.. i got it.
thanks again

"Deepak Puri" <deepak_puri (AT) progressive (DOT) com> wrote