AnsweredAssumed Answered

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

Question asked by malierta on Oct 4, 2019
Latest reply on Oct 7, 2019 by malierta



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.