 |
Advanced Budgeting is a multidimensional controlling planning and analysis tool
It simplifies and reduces the time needed for even the most complex and in-depth planning and analysis tasks
|
Planning
• Complete financial model, with integrated P&L, Balance-Sheet and Cash-flow planning: During the planning process users only need to plan the P&L and the system calculates the corresponding Balance-Sheet, and Cash-flow using the pre-customized Balance-Sheet connections
• Supports detailed (even daily) planning, in an any number of dimensions
o e.g. Product, Customer, Country, Cost center, Version, Time, etc. |
 |
 |
• Complex Business Logic, fully customizable by the user. Beyond normal financial planning tasks, the system is suited for in-depth planning tasks involving statistical figures |
• In addition to the standard OLAP functions (MDX) all Excel and VBA functions are accessible to users including all predefined financial and statistical functions, which greatly simplifies building new formulas
• Top-down planning based on original data, or reference values
o e.g. Plan values can be top-down allocated by last years fact data
|
 |
• Fast calculations, simulations
o When the base data changes, all calculations are immediately updated, no need to run any procedures (e.g. cost allocations)

• Wide-range simulation possibilities
o Undo option
o Multi-level versioning
• Bi-directional calculations
o Goal-seeking in even complex chained expressions and top down levels
o e.g. When modifying the Margin the system can recalculate the Sales quantity, , Unit price or Variable cost per unit
Data import
• Supports import from all kind of databases accessible via OLE DB or ODBC o e.g.: MS SQL Server, MS Access, MS Excel, Text, Oracle, DBF, DB2 etc.
• Monthly, weekly, daily, etc. automatically scheduled, or manual import

Analysis

• Fast, detailed reports using the OLAP data cube technology
• User friendly, drag & drop report creation, which does not require any previous knowledge of query or programming languages
• Fully customizable Chart Wizard
• Monthly, weekly, daily, etc. automatic scheduling of reports in many formats (PDF, Excel, Html, etc), and publication to various places (Web, email, Fileserver etc.)
• Data in the system is easily accessible / reportable from many existing systems (e.g. Excel), without installing any add-ins, or additional software
• Industry standard OLAP engine: MS Analysis Services. Minimum MS SQL Server 2005 Standard Edition, recommended MS SQL Server 2008 Enterprise Edition (x64)
• Online Ad-hoc reporting from web-client
|