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
You can't have a time dimension without dates. Add a date field to your Transformer fact query.