Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
davidagnew37
Starting Member
33 Posts |
 Posted - 2004-08-25 : 12:02:37
|
| 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 - Marchfrom 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 - Marchfrom 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 - MarchAny ideas would be much appreciated. david |
|
|
muntu
Starting Member
11 Posts |
Posted - 2004-09-02 : 08:11:07
|
| How is your fact table being build or Does your fact table have correct year and month. It seems to me the problem is not with anayysis sercives but with the way you have built your fact table. |
 |
|
|
rafala
Starting Member
1 Post |
Posted - 2004-09-21 : 17:23:41
|
| the good solution in this situation is to create the new time dimension (calendar),you can use the same date,key column from table, it's no problemother solution is to create the dimension table by yourself |
|
|
|
|
|
|
Time Dimensions - Financial years.