We're pleased to announce the latest release of the Anaplan Connector for Informatica Cloud, which includes the following features and enhancements: The Connector now uses the settings in the proxy access configuration on the Secure Agent to send and receive data through a corporate firewall. You can now specify an absolute file path to the error dump file in the Agent folder. Each Import Action generates a copy of the dump file (in .csv format) with details, including a date/time stamp, of all records that failed. The following delimiters are now supported: Comma Semi-colon Tab Pipe Other delimiters defined by an Anaplan admin in an import or export definition can also be used with the Connector. You can now configure a DSS to upload a file without invoking an Action. This allows you to upload a file to Anaplan and run an import later. Informatica DST session logs are now populated with the results of each task, regardless of whether the integration succeeds or fails. You can now specify the chunk size for Imports (from 1MB to 50MB) to support fewer API calls. The chunk size for large data loads can be set to a higher value to help reduce load times and minimize error during the load process. Download the updated user guide from the Anaplan Connector for Informatica Cloud page in Anapedia. For more information, visit the Informatica Marketplace and search for 'Anaplan'.
... View more
There is some information in this associated post about limiting the time range over which the formula operates. https://community.anaplan.com/t5/Formulas-Functions/Help-with-NPV-Function-Anaplan-differing-from-Excel/td-p/7527
... View more