Here's an example for the Adventure Works "Growth in Customer Base" KPI
- it isn't computed for the default date:
Quote:
|
select {KpiValue("Growth in Customer Base"),
|
KpiGoal("Growth in Customer Base")} on 0
from [Adventure Works]
-------------------------------------------------
Growth in Customer Base Growth in Customer Base Goal
NA NA
But if you set its Current Time Member to '[Date].[Fiscal].[Fiscal
Year].&[2003]':
Quote:
|
select {KpiValue("Growth in Customer Base"),
|
KpiGoal("Growth in Customer Base")} on 0
from [Adventure Works]
where KpiCurrentTimeMember("Growth in Customer Base")
-------------------------------------------------
Growth in Customer Base Growth in Customer Base Goal
46.06% 0.3
- Deepak
Deepak Puri
Microsoft MVP - SQL Server
*** Sent via Developersdex http://www.developersdex.com ***