I'm still struggling with this
I am trying to create custom dimension where, for example, February,23,2011 would show as 02/23
1. I created interim dimension MonthNumber = num(month). It works.
2. Then I am trying to create dimension Month&Date = day([date])&"/"&[monthnumber]
It won't allow this as [monthnumber] is invalid filed name. Why?