Create Months/Weeks Parameter and corresponding Periods parameter

• pwalter83

  SSChampion

  Points: 14575

  More actions

  November 18, 2011 at 9:50 am

  #260359

  Hi,

  I have a requirement to create 3 parameters:

  1. View- Would prompt the user to select Months or Weeks.

  2. Periods - Would then display either the monthly or weekly values as per the user selection. For e.g. if the user selected Months, the values would be displayed as 201101, 201102, 201103 and so on(the last 2 digits indicating month number) and if the user selected Weeks from the View menu, the values would be 201101, 201102, 201141, 201152, the last 2 digits indicating the week number.

  3. VesselType- This would be an independent parameter which would display all the distinct values for the Vesseltypes.

  The report should display data based on the 3 parameters, out of which the first 2 are inter-related.

  There is no Month or Week column in the table that I have to use for this SP. The month or week values need to be created from the CREATE_DT column. The problem I am facing is how to create an SP for the first and second parameter. Has someone done something siimar which I can use for writing the query ? Any suggestions would be appreciated.

  Thanks,

  Paul

• nheller

  SSC Enthusiast

  Points: 126

  More actions

  December 21, 2011 at 3:07 pm

  #1424488

  it sounds like you need a date dimension table.

  http://www.zachhunter.com/2009/09/how-to-build-a-date-dimension-table-for-olap/