I want to import data from a CSV-file to an info-cube.
It work´s fine except the date data.
In the CSV-file it´s in this format '22.01.1997'. The destination info boject in the info cube is standard time formatted (DATES length 8).
What should the data format for the date in the dataSource/PSA look like, character 10 or also DATES?
What is then the right transformation to the destination?
Thanks in advance!
Siegfried Szameitat replied
in the infopackage, in the 3rd tab, you can set 'update psa only' and after scheduling the request, click on the little monitor in the upper left corner of the gui and you are in the request monitor. Now click on your request and once you see some details of your request on the right side, there is a button available to jump to psa or you can go there via Goto->Data->PSA maintenance