dbTalk Databases Forums  

Time Dimension ... getting details up thru a time period.

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


Discuss Time Dimension ... getting details up thru a time period. in the microsoft.public.sqlserver.olap forum.



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

Default Time Dimension ... getting details up thru a time period. - 07-18-2003 , 11:24 AM






One of our dimensions is time. We use OWC for accessing AS2K cubes
using pivot tables.
Our requirement is ... when a user selects a time period, say 200307,
we need to present the facts UP THRU 200307 (not FOR 200307).
Is this possible ? Please suggest some approaches.
Thanks a lot...Raju.

Reply With Quote
  #2  
Old   
Tom Chester
 
Posts: n/a

Default Re: Time Dimension ... getting details up thru a time period. - 07-18-2003 , 11:37 AM






Assuming you are doing year-to-date calculations, you will create a
calculated member similar to this:

SUM(YTD(), Measures.[MyMeasure])

tom @ the domain below
www.tomchester.net


"mangaraju venuturupalli" <mangaraju (AT) yahoo (DOT) com> wrote

Quote:
One of our dimensions is time. We use OWC for accessing AS2K cubes
using pivot tables.
Our requirement is ... when a user selects a time period, say 200307,
we need to present the facts UP THRU 200307 (not FOR 200307).
Is this possible ? Please suggest some approaches.
Thanks a lot...Raju.



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.