dbTalk Databases Forums  

Current Time Member on KPI Def

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


Discuss Current Time Member on KPI Def in the microsoft.public.sqlserver.olap forum.



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

Default Current Time Member on KPI Def - 05-09-2006 , 02:26 PM






An SSAS 2005 KPI definition has a "Current Time Member" that can be
associated with it. Does anyone know what effect this has, and what can be
done with it? The docs a bit skimpy on the topic.



Reply With Quote
  #2  
Old   
Jeje
 
Posts: n/a

Default Re: Current Time Member on KPI Def - 05-09-2006 , 07:57 PM






you can simply use this formula or selected member when you create your
select statement which retrieve the value of the KPI.
you retrieve this formula using the ADOMD.Net API or using the
GetSchemaDataSet function.
then add this formula in the Select statement (in the where clause) to
filter the KPIValue for this specific date.



"Kevin Dente" <kevind (AT) no (DOT) spam.denteworld.com> wrote

Quote:
An SSAS 2005 KPI definition has a "Current Time Member" that can be
associated with it. Does anyone know what effect this has, and what can be
done with it? The docs a bit skimpy on the topic.




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.