Data model

FMW Web contains a highly flexible series of structures which can be adapted, via an end-user point-and-click interface, to model the application requirements.

The budgeting / reporting timeline can be configured as required. Different timelines might apply to different parts of the model, for example a Capital plan might require a multi-year annual timeline whereas the Operating part of the plan might require a monthly timeline.

ScreenshotThe elements used in combination to define data rows are also fully user-definable. Often these are set up to reflect data captured in source systems such as a GL (accounts, departments etc.), a job or project system (jobs, phases, categories) or a payroll / HR system (position, employee number). There is no limit to the number of elements that can be established. Both variable and fixed length elements can be accommodated. These elements can either be synchronized automatically with a source system via the interfacing module, or may in some cases be maintained within FMW Web.

Any element (such as a department, account, job, employee) can be rolled up through multiple reporting trees. These trees are maintained using a highly graphical, drag-and-drop interface, making it exceptionally easy to perform "what-if" type analyses simply by rearranging these trees. Each element can also be rolled up through multiple trees, meaning that different consolidations and views of the data are easily obtained.