Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    163

    Unanswered: How do I display the day name instead of the day #

    Hi,

    I created a Time Dimension and ended up with the following (as shown in the attached image). The problem is that when I go to the Day level, I see numbers e.g. 1, 2, ..., 31. Instead I want to display the Weekday Name e.g. Monday, Tueday and so on (i.e. what we get with the datename(dw,<date>) function. Right?)

    However I am not sure what to change and where in order to get the desired results. Can someone kindly guide me.

    Thanks.
    Attached Thumbnails Attached Thumbnails question.jpg  

  2. #2
    Join Date
    Jan 2003
    Location
    India
    Posts
    523
    use:
    datename(dw,"dbo"."TimeDimension"."TheDate")


    ie

    select datename(dw,getdate())

  3. #3
    Join Date
    Oct 2003
    Posts
    163
    use:
    datename(dw,"dbo"."TimeDimension"."TheDate")
    Hi hirshal.

    I tried entering the above in the Member Name Column and the Member Key column but did not get the desired effect

    Can you kindly guide? Do I need to enter the above quoted formula in both fields (Member Name Column and Member Key column) or in only one of these?

    Thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •