Contact Dave Hogg

Tel: +44 (0)7900 013007

At M&G used FDM to decode the XML Currency rates feed from Reuters to derive the required rate combinations and other fields required for loading into SUN GL, for dailiy Spot, Monthly Spot and (calculated) Monthly Average.

A handy new use for a tool they were already using. The Mapping feature in FDM allows easy setting of rate variance tollerances, mapping to target account ranges, realisation account, etc..

Since August I've been pretty much full time helping Simon and his team out at M&G both with Infrastructure and Integration.

The set of patches has been applied, and the great work that was done by Edgewater Ranzal to create HPCM based fully allocated Plan data has been enhanced to run more of the HPCM elements in parallel (e.g. ASO Genealogy). These speed improvements have allowed a fully allocated 48 period rolling forecast to become viable via overnight processes.

Some of the data movement back and forth between the BSO and ASO cubes has also been cut out by use of ASO Reports, in place of the JExports. All good stuff, and a great team to work with.

During July and August I was able to help Rexam migrate from to (yes I know it does not show that as a upgrade path, but I found no need to upgrade to first).

The upgrade went really well, with the new EPM configuration tool accepting most of the existing artefacts and security seamlessly from the EPMData folder or the migrated schemas.

There were a only a few gotcha's - esspecially arounf Essbase and EAS connectivity... consider doing your Essbase artefact copies (via EAS) before applying the .500+ essbase patches as after that EAS will not connect to the older versions of essbase, and it will need to be a filesystem copy.

As usual there are some new issues with the new release. These are the ones we spotted...

  • EAS unable to connect to older essbase versions.
  • Planning Form precision is used when copying values (instead of underlying Essbase numeric precision) so detail is lost
  • FR Export to Excel, new default behaviour is for 'pages' to become seperate workbook tabs. A patch 503 is needed to allow the FR config tool to change this default behavior
  • FR also seemed to occasionally merge data columns on export to Excel./

We were back at BT in July for a few weeks assisting them through Migration of the REFINE cost allocation system to UAT and PROD.


Go to top