Date Dimension down to Day

[fabiosalles]

As a DW developer, I want to be able to use CDG to load data broken down to day. So, instead having facts generated by month, I want to have facts generated by day.

I believe it might be implemented changing function range(start date,end date) to iterate over days.

[fernandommota]

Hi @fabiosalles,

I did it:

range(2014,2015).map(function(year){
range(0,2).map(function(month){
var m = months[month];
range(1,2).map(function(day){
dateDim.push(
{"ano":year ,"mes_numero": m[0], "mes_abrev":m[1], "mes_desc": m[2], "dia": day}
);
});
});
});

Works well for me!

Regards

[fabiosalles]

Excellent! Thanks, Fernando.