How to limit the time Dimension to 24 months

MSAS Time Dimension Question

Well here it goes...I am trying to create a date dimension that will only pull in 24 months worth of date information.

Example: I want the end date to be the current date and the start date to be 24 months prior...as the current date changes (End date) the Start date will also change to reflect the date changes. I'm thinking something similar to a rolling 12 or 24 month time dimension.

NOTE: My time Dimension needs to be similar to that of a Bank account (NOT Accumulative)

Ex:

May 1 =$ 1.50

May 2 =$ 1.42

ect..

May 31 =$0.65

1-1 relationship on Date to Amount

NO rollup within the date dimension. I would love to have folder structures built into the Date Dimension Year/Quarter/Month but not rollup...more of an external rollup.

Just a side note...the date field within my SQL DB has Ten years worth of date fields but I want to limit it to only 2 years.

Anyone have any good ideas?

lochew

In this case, you should create your dimenison manually using the dimension wizard (Server Time dimenison). You can specify exactly the starting and end date of your dimension.

If you want to avoid the rollup you can siply associate the NONE additive aggregation funciton to the measure.

|||

Thanks tdhers,

Is this option available within MSAS/SQL 2000? I haven't seen the (Server Time Dimension) but I will take another look. I'll also look into the NONE additive aggregation funciton.

Thanks again

|||No it is AS2005 only