By means of the transformation type timestamp you can transform imported values into a valid PPM data format of the TIME type.
The transformation is the same as the one used for the XML event import mapping of the process import. This means that the formatting characters of the Java class java.text.SimpleDateFormat are used.
Example
<event>
<attribute type="VBTYP">C</attribute>
<attribute type="POSNR"></attribute>
<attribute type="VBELN">0090018147</attribute>
<attribute type="ERZET">20121105160956</attribute>
</event>
Used with the data source configuration:
…
<realmvaluetransformations>
<realmvaluetransformation>
<eventattributetype>ERZET</eventattributetype>
<transformation type="timestamp" format="yyyyMMddHHmmss"/>
</realmvaluetransformation>
</realmvaluetransformations>
...
For Data analytics, the value 05.11.2012 16:09:56 is imported into the column ERZET of the analysis realm table.