dbTalk Databases Forums  

advanced Time dimension

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


Discuss advanced Time dimension in the microsoft.public.sqlserver.olap forum.



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

Default advanced Time dimension - 11-19-2004 , 06:23 AM






Is it possible to make time dimension which will calculate all members from
1st day of year till pointed date. In other words I need to aggregate all
periods (yyyy0101-yyyymmdd, where mm - any month, dd - any date) of an year.



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

Default Re: advanced Time dimension - 11-19-2004 , 08:20 AM






Hi!

What about a calculated member "Cumulated": Sum(PeriodsToDate(Time.Year),
Measures.CurrentMember) ?

Glück Auf
Kalle

"gNM" <gedukas99 (AT) hotmail (DOT) com> schrieb im Newsbeitrag
news:%230rCMKjzEHA.3840 (AT) tk2msftngp13 (DOT) phx.gbl...
Quote:
Is it possible to make time dimension which will calculate all members
from
1st day of year till pointed date. In other words I need to aggregate all
periods (yyyy0101-yyyymmdd, where mm - any month, dd - any date) of an
year.





Reply With Quote
  #3  
Old   
gNM
 
Posts: n/a

Default Re: advanced Time dimension - 11-22-2004 , 02:23 AM



Graet many thanks! It works!!

"Kalle" <KHeuwes (AT) zeb (DOT) de> wrote

Quote:
Hi!

What about a calculated member "Cumulated": Sum(PeriodsToDate(Time.Year),
Measures.CurrentMember) ?

Glück Auf
Kalle

"gNM" <gedukas99 (AT) hotmail (DOT) com> schrieb im Newsbeitrag
news:%230rCMKjzEHA.3840 (AT) tk2msftngp13 (DOT) phx.gbl...
Is it possible to make time dimension which will calculate all members
from
1st day of year till pointed date. In other words I need to aggregate
all
periods (yyyy0101-yyyymmdd, where mm - any month, dd - any date) of an
year.







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.