Date Dimension Question (Only display lowest level data)

[lochew]

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

Example:
Year= {Blank}
Quarter= {Blank}
Month= {Blank}
Day
-1st = $15.50
-2nd = $7.43
- 3rd = $12.21

Thanks in advance

BI World

 

[MDXer]

Use Calculated Cells. With calculated cells you should be able to supress values based upon your location within the dimensional hierarchy.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[lochew]

Thanks MDXer...I'll give the Cal Cells a try...

Cheers