date !!!

• bkarl

  Newbie

  Points: 1

  More actions

  June 11, 2003 at 3:44 pm

  #160251

  Hi,

  I have a dimension TIME and the members are ;

  Year QTR Month Week Date

  Now when I drilldown from "Month" to week, at certain places the week divides between two months with respective dates. ( see the attachment ).

  For example in year 2001, Q1, December 2000, 1/5/2001

  This actually has to be with

  January 2001, 1/5/2001

  I mean, The two records present in December 2000 1/5/2001 shoule be with January 2001, 1/5/2001

  Like January 2001

  1/5/2001

  12/30/2000

  12/31/2000

  1/1/2001

  1/2/2001

  1/3/2001

  1/4/2001

  1/5/2001

  Can any one have the solution.

  Thanks,

  Raj

• mworku

  Ten Centuries

  Points: 1311

  More actions

  June 11, 2003 at 8:45 pm

  #460941

  I Can't really understand your question.

  Give more details and query examples

  MW

  
  MW