dbTalk Databases Forums  

Aggegration Function MAX and "Most Recent"

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


Discuss Aggegration Function MAX and "Most Recent" in the microsoft.public.sqlserver.olap forum.



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

Default Aggegration Function MAX and "Most Recent" - 05-19-2004 , 12:18 PM






Suppose a measure "A" with Aggregation function Max
is created.
Its normal range is between 1 and 99.
It is inialized by multiplying todays date(integer
format YYYYMMDD) * 100 plus its normal range.

I create a calculated member "B" which
"A" - "A"/100 which will give me the normal range back (1
to 99).

The Measure B is the most recent value of "A" with the
date removed.

Is this an appropriate method to retrieve the latest value
of a measure even though the time period of the other
measures in the query is some other time period.

Thanks
Gary

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.