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
-
Hi,
this should easily work with standard SQL Options like cast/convert:
Regards
Björn
0 -
Hi Bjorn,
Already we tried it but it didn't work, the value didn't load in SQL table.
Regards,
0