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.

All Forums  SQL Server 2000 Forums  Analysis Services (2000)  Date Dimension Question (only display lowest level

Author  Topic  lochew Starting Member 3 Posts Posted - 2006-02-23 : 10:21:22 Hi, I have a requirement to build a date dim within MSAS 2000 that will only display the day level values. They still want the date dim level structure Example: Y/Q/M/D but want the Year /Quarter and Month levels to have NO values associated with them. The only values will be at the day level. I have setup the date dim via the wizard but can not find an easy way to perform this task. Any suggestions would be great. Similar to a bank account, but still having the folder structure. Example: Year = {Blank} Quarter = {Blank} Month = {Blank} Day -1st = $15.50 -2nd = $7.43 -3rd = $12.21 etc... Much Thanks to any suggestions BI World