Archivi categoria: FDM

About DrillThrough on FDM

DrillThrough means tracing from the destination account of an EPM system to the source accounts of GL; here we talk about: #JDE as source, #FDM as ETL and #HFM as destination. Experlab, in collaboration with a system integrator, has implemented a solution that reduces the maintenance need of FDM maps for the users. In summary:

– Each new JDE account is associated, in a designated class, with the HFM destination account;

– There is a view, which points to the staging table on DB, where the account code and the JDE description are concatenated in a single field;

– In FDM, for the entire chart of accounts, we manage a “Like” type mapping, reducing maintenance activity to zero;

– In FDM a field called “Description-1” is enabled to display on each HFM account the account code and the description of the JDE source, both at the client workbench table level and in FDM execution reports.

For further information e-mail

Fdm Report Execution

Workbench table of FDMEE (Import / Validate / Export): extract on excel: the correct format of source account codes starting with zero, within separators inside them (example, master account/ account / cost center) has been lost.
The Fdm report “01_TB Current Location, by Target Acct”, under Workflow > Report Execution> Base Trial Balance Report, returns the correct formats launched on XLS.
Info and support: e-mail