Cannot load ROLAP date Cube with format DD/MM/YYYY

Hello,

 

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.

 

Regards,

 

Miriam

Answers