Time Dimensions - Financial years.

[davidagnew37]

Hi,

I have a finance cube where the financial year runs from the 1 February to the 31 Jan. When creating a time Dimension you are able to select when the year starts (which is great for time dimensions such as financial years!) ...

However... when I query my db direct for the figures for March 2004 for example to check my figures are right in the cube.... In Analysis Services if I select
- 2004
- Quarter1
- March
from my time dimension, it gives me the previous years figures.

So to get the correct results for March 2004 I have to select:
- 2005
- Quarter1
- March
from my time dimension.

Is there any way to change this, so that when an end user eventually gets to query the database for March 2004 fugures they can actually select:
- 2004
- Quarter1
- March

Any ideas would be much appreciated.

david

 

[JohnEck]

I believe that when AS sets up a shifted time dimention the year is determined by the end of the fiscal year. If your fiscal year start in Feb isn't that fiscal year 2005?