Creating quarter dimension on month......

• elegantkvc

  SSCommitted

  Points: 1910

  More actions

  June 25, 2008 at 12:51 am

  #183976

  hi friends,

  I have a month column contains values as 1,2,3....12.

  I want to create a dimension on quarter as four sets

  Quarter1 -> 1,2,3

  Quarter2 -> 4,5,6

  How to create a dimension which contains the quarters...

  I have tried this query

  select distinct top 3 month as quarter1 from timetracker$

  But doesnot work out..How to denote second set....Any idea pls share...

  vijay

• Dfalir

  SSCrazy

  Points: 2486

  More actions

  June 27, 2008 at 7:26 am

  #835330

  are you talking about creating quarters in a dimension?

  ---

  "If you want to get to the top, prepare to kiss alot of bottom"