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

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

Post by mangaraj » Sun, 20 Jul 2003 01:24:44


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.
 
 
 

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

Post by Tom Cheste » Sun, 20 Jul 2003 01:37:40

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