Time DIm

[cognos05]

Hi,

I have an issue loading my transformer cube.

I have customer dimension , Products Dimension and Time Dimension.

My load file has the customer , product,sales value and for time it just has numbers from 1 to 31 (Ideally days of a month)

And load file will have days from 1 to 31.

So here how should I create a time dimension, what should be the earliest date and latest date range and should I enable automatically set current time period?


My time dim source file will be a text file with header day and values 1 to 31.
What should be the data class for the day source column ,should it be date or numeric ?
No I dont get any error but my data is not loaded, I see only 0 values loaded.

I think my dimension is screwing up. Any suggestions is appreciated

Thanks,
Nithya

[Ricardo Julio "Ricky" Villa]

You can't have a time dimension without dates.  Add a date field to your Transformer fact query.