October 3, 2012 at 3:59 am
Hi Am getting Numbers while browsing a cube in Week day column, how to get name instead of number.
1 1st week
2 2nd week
Thanks
Niha
October 4, 2012 at 8:36 am
Sounds like you are wanting a text string, like "First Week" instead of a week number, like 1, to appear. In the source table for your dimension, you will need to have columns for both. For example, for the entry in your date dimension for 10/4/2012, you will need a week number value of 40 and a week name value of "40th week".
In the Dimension editor in BIDS, you can assign both a Key and Name column to an attribute. So the week number can be the Key and the week name can be the Name value. By default it will order by the Key--which will keep the months in numeric order--but you can change this attribute value, also.
Hope that helps!
-Katherine
@sqlsassy
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply