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 |
|
muntu
Starting Member
11 Posts |
 Posted - 2005-02-07 : 09:50:16
|
| Hi I want to use some MDX code to calculate the growth of products.I want compare this month against the same month last year. The problem my dimension is calendar and MDX does this calculation using time dimsion. Can someone tell if is possible to convert calendar dimension to time dimension?. |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-02-07 : 11:07:57
|
| You can set the dimension type and the type of all the levels under the advanced tab when you edit the dimension.Set dimension to type "Time", and the levels to "Year", "Quarter" etc...rockmoose |
 |
|
|
|
|
|
Converting calendar dimension to Time Dimension