PowerPlanner
Hungarian
 
   
 
“What information consumes is rather obvious: it consumes the attention of its recipients. Hence, a wealth of information creates a poverty of attention and a need to allocate that attention efficiently among the overabundance of information sources that might consume it.” HERBERT SIMON, Nobel Memorial Prize for Economics


Nowadays a huge amount of information collected and processed for our decisions. The need of coping with information overflow has also been recognized by software producers. Compared to its predecessors, for example, Excel 2010 is able to handle much more rows and data.

Internal data flows of a company are basically defined by spreadsheets, but the increasing information needs of users and data-flows poses several problems. On the one hand, these sources can be full of data entry and formula definition errors. On the other hand, growth in the size of stored data and cross-linking causes decrease of system manageability, performance and reliability.
 
The evolution of OLAP systems
Although database systems were made up for more effective data processing and management of two-dimensional tables, these permitted only two-dimensional data reviews. Thus “row-column" schemes were dominant. This gap has been filled by the OLAP (On Line Data Processing) technology. According to the predefined relationships and rules between dimensions and hierarchies, the OLAP system aggregates elementary data. Results are stored in own databases.
The OLAP system aggregates the elementary data between the tables according to the specified relationships.
Data Integration
The functions of OLAP Planner PowerPlanner is plugin software for Microsoft Excel's PowerPivot. A new approach can be applied on multidimensional budgeting, reporting and data warehouse management with this application. The PowerPivot application operates the "in-memory" multidimensional database as the part of Microsoft Excel and its pivot tables tuned by PowerPlanner. The PowerPlanner plugin specifically extends the functionality of Excel features which are necessary to manipulate PowerPivot models, as follows:

●    the data can be modified in the multidimensional database;

●    top-down budgeting will be available (top-down planning method);

●    goal-seek calculation for targeting financial objectives;

●    we can use calculated members within the our report;

●    we can edit the dimensional data directly;

●    we can work with different data-versions in parallel;

●    we can apply time shift on data sources: we can make a budgeting version for the actual period from the actual data of previous period and can forecasting easier.

The plugin feature means that the PowerPlanner application starts with Excel and the icons appear on the menu-ribbon.
 

Multidimensional budgeting plans allow for simulations, which can provide and predict accurate results in a variety of business scenarios. This is a competitive advantage, not to mention the value of a structured reporting system.