0.00.0100011NY5000NN1000-2007/06/07 12:04:59.781Set Dimension Parameters
Start Date
Language
Length of dimension in days (Field Limit)141920760Microsoft Sans Serif8NN0002552550100100100NUnique rows for
filter duplicate rows45432810435Microsoft Sans Serif8NN0002552550100100100NGet the dimension level fields
Quarter,Month,Week,Day
with Java Calendar and javascript2521217447Microsoft Sans Serif8NN0002552550100100100NOutput
as you need
10233297635Microsoft Sans Serif8NN0002552550100100100NDay SequenceCalculate Dimension AttributesYCalculate Dimension AttributesDay Sequence 2YDay Sequence 2Select valuesYSelect valuesUnique rowsYSet Dimension ParametersDay SequenceYUnique rowsSelect values 2YSelect values 2add primary keyYadd primary keyExcel OutputYCalculate Dimension AttributesScriptValueModY1noneY0Script 1//Create a Locale according to the specified language code
var locale = new java.util.Locale(
language_code.getString()
, country_code.getString()
);
//Create a calendar, use the specified initial date
var calendar = new java.util.GregorianCalendar(locale);
var date = new java.util.Date(calendar.getTimeInMillis());
var load_date = java.text.DateFormat.getDateInstance(
java.text.DateFormat.SHORT
, locale
).format(date);
calendar.setTime(initial_date.getDate());
//set the calendar to the current date by adding DaySequence days
calendar.add(calendar.DAY_OF_MONTH,DaySequence.getInteger() - 1);
//get the calendar date
var date = new java.util.Date(calendar.getTimeInMillis());
//en-us example: 9/3/07
var short_date = java.text.DateFormat.getDateInstance(
java.text.DateFormat.SHORT
, locale
).format(date);
//day in year: 1..366
var simpleDateFormat = java.text.SimpleDateFormat("D",locale);
//day in month: 1..31
simpleDateFormat.applyPattern("dd");
var day_number = simpleDateFormat.format(date);
//en-us example: "Monday"
simpleDateFormat.applyPattern("EEEE");
var day_week = simpleDateFormat.format(date);
//4 digit representation of the year, example: 2007
simpleDateFormat.applyPattern("yyyy");
var id_year = simpleDateFormat.format(date);
//week in year, 1..53
simpleDateFormat.applyPattern("ww");
var id_week = simpleDateFormat.format(date);
var id_week_year = id_year+id_week;
//month number in year, 1..12
simpleDateFormat.applyPattern("MM");
var month = simpleDateFormat.format(date);
var id_month = id_year+simpleDateFormat.format(date);
//en-us example: "September"
simpleDateFormat.applyPattern("MMMM");
var des_month = simpleDateFormat.format(date);
//handling Quarters is a DIY
var des_quarter = "Quarter ";
var quarter;
switch(parseInt(month)){
case 1: case 2: case 3: quarter = "1"; break;
case 4: case 5: case 6: quarter = "2"; break;
case 7: case 8: case 9: quarter = "3"; break;
case 10: case 11: case 12: quarter = "4"; break;
}
var semester;
var des_semester="Semester ";
switch(parseInt(quarter)){
case 1: case 2: semester = "1"; break;
case 3: case 4: semester = "2"; break;
}
des_semester+= semester;
des_quarter += quarter;
var id_quarter= id_year + quarter;
var id_time_nk= id_year+month+day_number;
localelocaleString-1-1NcalendarcalendarString-1-1NdatedateString-1-1Nload_dateload_dateString-1-1Nshort_dateshort_dateString-1-1NsimpleDateFormatsimpleDateFormatString-1-1Nday_numberday_numberString-1-1Nday_weekday_weekString-1-1Nid_yearid_yearString-1-1Nid_weekid_weekString-1-1Nid_week_yearid_week_yearString-1-1NmonthmonthString-1-1Nid_monthid_monthString-1-1Ndes_monthdes_monthString-1-1Ndes_quarterdes_quarterString-1-1NquarterquarterString-1-1NsemestersemesterString-1-1Ndes_semesterdes_semesterString-1-1Nid_quarterid_quarterString-1-1Nid_time_nkid_time_nkString-1-1N291232YDay SequenceSequenceN1noneDaySequenceNSEQ_Y119999999291119YDay Sequence 2SequenceN1noned_tim_pkNSEQ_TIEMPO_HORAY119999999441232YExcel OutputExcelOutputY1noneYNY${Internal.Transformation.Filename.Directory}\time_dimension.xlsxlsNNNNNSheet1NNNEncrypted 0NNtemplate.xlsdateStringload_dateStringshort_dateStringday_numberStringday_weekStringid_yearStringid_weekStringid_week_yearStringid_monthStringdes_monthStringdes_quarterStringsemesterStringdes_semesterStringid_quarterStringid_time_nkStringd_tim_pkIntegerid_timeInteger954335YSelect valuesSelectValuesY1nonelanguage_code-2-2country_code-2-2initial_date-2-2local_yes-2-2local_no-2-2DaySequence-2-2locale-2-2calendar-2-2date-2-2load_date-2-2short_date-2-2simpleDateFormat-2-2day_number-2-2day_week-2-2id_year-2-2id_week-2-2id_week_year-2-2month-2-2id_month-2-2des_month-2-2des_quarter-2-2quarter-2-2semester-2-2des_semester-2-2id_quarter-2-2id_time_nk-2-2d_tim_pk-2-2N591232YSelect values 2SelectValuesY1nonedate-2-2load_date-2-2short_date-2-2day_number-2-2day_week-2-2id_year-2-2id_week-2-2id_week_year-2-2id_month-2-2des_month-2-2des_quarter-2-2semester-2-2des_semester-2-2id_quarter-2-2id_time_nk-2-2d_tim_pk-2-2N712335YSet Dimension ParametersRowGeneratorN1nonelanguage_codeStringca-1-1country_codeStringCA-1-1initial_dateDateyyyy-MM-dd2006-01-01-1-1local_yesStringsi-1-1local_noStringno-1-136529127YUnique rowsUniqueY1noneNNDaySequenceNload_dateNshort_dateNday_numberNday_weekNid_yearNid_week_yearNid_monthNdes_monthNdes_quarterNquarterNsemesterNdes_semesterNid_quarterNid_time_nkNd_tim_pkN591335Yadd primary keySequenceY1noneid_timeNSEQ_Y11999999999833335YN