Hi, I am working with MS OLAP Server 7 and MS SQL Server 7 with many cubes and they all works fine. Some days ago I have installed MS SQL Server 2000 and MS Analysis Services, recreate the same cubes (same source tables, dimensions and measures) to test them with the new version but I encountered a big problem: when I see the results day by day or month by month I can see all fine, but the cube shows the result 1 (one) when I see the results year by year

Ex
Second
January 90
Februay 36

If I make a Drill Up

Second
2004

Do you know where is the problem

Thanks
Antonio Giossa