dbTalk Databases Forums  

Re: Problem with KPI and Time Dimension

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Re: Problem with KPI and Time Dimension in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Manfred
 
Posts: n/a

Default Re: Problem with KPI and Time Dimension - 12-09-2006 , 04:49 AM






Hi,

I tried to set the filter to some year. This effects the current Value but
not the goal.

Best Whishes,
Manfred



Reply With Quote
  #2  
Old   
Deepak Puri
 
Posts: n/a

Default Re: Problem with KPI and Time Dimension - 12-10-2006 , 03:11 AM






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
Quote:

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
Quote:

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.