Date and transaction fields

Date and transaction fields are not available for analysis in Optimize as they are only saved in the database. Therefore, PPM does not automatically convert these fields into PPM dimensions; instead it creates a mapping for its system event attributes in the same way as for the attribute assignment. PPM assigns fields of the Date data type the TIME data type and assigns the transaction fields the TEXT data type. Date fields must contain time stamps in the Software AG standard date format (SAGDateTime) so that they can be imported by PPM. Detailed information about the SAGDateTime date format can be found in the webMethods documentation or in the PPM documentation PPM data import.