Error: The column is not valid

• BEIJCKM

  Mr or Mrs. 500

  Points: 583

  More actions

  August 7, 2003 at 5:00 am

  #106315

  Hi all,

  When I try to make changes to the "Member Name Column" (do some formatting) I receive the message as in the subject.

  Is their a way to avoid this message ?

  During the format I need to change a number i.e. 1 to a month let's say january, 2 --> february and so on.

  The tables/views are located in an Oracle DB.

  Thanks in advance.

  Regards,

  Bart

• August 11, 2003 at 12:00 pm

  This was removed by the editor as SPAM

• BEIJCKM

  Mr or Mrs. 500

  Points: 583

  More actions

  August 13, 2003 at 12:09 am

  #469675

  Hi all,

  How can I display the month's full name when

  I have only a number indicates each month i.e. 1=January, 2=February...

  Which formula can I use convert the number to a full month's name.

  Thanks in advance.

  Regards,

  Bart

  quote:

  ---

  No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!

  ---

• 5409045121009-7368

  SSCoach

  Points: 15740

  More actions

  August 13, 2003 at 12:22 am

  #469679

  Declare @Month INT

  Select @Month=5

  Select Datename(Month,'2001-'+Cast(@Month as Varchar(2))+'-1')

• BEIJCKM

  Mr or Mrs. 500

  Points: 583

  More actions

  August 13, 2003 at 12:34 am

  #469681

  I assume that this T-SQL.

  Do you perhaps know how I can input this in

  The dimension editor for the field "Member Name Column"

  Thanks in advance.

  Regards,

  Bart

  PS Thanks for the very quick reply !