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
Categories
- All Categories
- 2K Forums
- 1.8K Platform
- 168 Academy
- 330 Resources
- 1 Board Knowledge Base
- 50 Best Practices
- 49 How-To Guides
- 19 Board Advocacy Program
- 196 Blog
- 4 Groups Hub
- 4 About Groups
- New Community Members
- DACH
- Japan
- 5 Community Captains
- 1 About Community Captains
- 3 Meet the Community Captains
- 1 Topics & Thought Starters
- Learn from the Board Captains
- Release Notes
- Academy
- 2 Board Academy
- 8 ILT/VILT Course Catalogue
- 13 e-Learning Course Catalogue
- 4 Academy Forum
- 1.3K Idea Exchange
- 338 Partner Hub
- 94 Support
- 14 FAQ's
- Customer Support Portal
- 54 Support Articles
- BEAP