We have a Rolap date type Cube and we try to load it in a table which field date type char(10). We need this date with the format DD/MM/YYYY.
The source is a date cube with format dates dd/mm/yyyy but when we doing a dataflow to rolap cube, the value can't save because Board try to extract Date Cube with format DD/MM/YYYY HH:MM:SS, but really the date cube hasn't hour, minute or second informed (we tested load rolap cube in a dummie table with a field type as char(20) and then it worked, but we saw that the date format contained HH:MM:SS).
We tried to put in a dataflow a algorithm like LEFT(a,10) to extract only the first 10 characters, but it didn't work neither.
Anyone knows any way to load this date in format DD/MM/YYYY without HH:MM:SS in a rolap cube?
Thanks in advance.