OLAP Planner
Hungarian
 
   
 
“Perfection is achieved, not when there is nothing more to add, but when there is nothing left to take away."  
                                                                                                                 ANTOINE DE SAINT-EXUPÉRY

The multidimensional business model of Your company can be driven in a familiar environment by OLAP Planner Excel add-in. The aim of your fully customized model is to solve e.g. optimalization of production system, consolidation of company group, forecasting cash-flow.
OLAP Planner opens the door for multidimensional financial budgeting, reporting, and  datawarehouse management.


 
 

The evolution of Excel files in a company...
































... with OLAP Planner


Client
- Server structure


Standardized solution

Multidimensional data management with
Microsoft Excel

Efficient Controlling



Tailored implementation 

If a company reaches the level of periodic reporting and budgeting tasks as basic needs, surely facing with the following problems

from the manager’s point of view:
  • The information contained in a Report to the latest? Instead of using monthly data could not we have information on weekly or daily basis?
  • Does it take still 3 days to compile a new report?
  • Why the controlling system is so complicated? Are we budgeting in accordance with the right business model? Does the model focus on the business objectives?
- from the controller’s point of view:
  • The right version is available? Each of the 89 pieces of file opened in the right order and all the attachments have been updated?
  • After inserting new data row, are the formulas being intact?
  • The Management asks for a new report. Gathering the base data for the report takes as much time as we used for all the regular reports?
  • This report will become a regular? What will happen if one of the data should be analyzed in detail by the Management?
- •    from the IT’s view:
  • Should we collect information separately from all island-systems? Can we make automate integration of data into a central database?
  • Central archiving and backup possible for users?
  • How to secure and make limited access to business data?
The solution is to build up a new, central, and organized database, which stores data in consistent state and the data can be easily updated.  With an OLAP query tool the latest information can be filtered, dynamically queried, typically using pivot tables If Excel is used as a query tool only the maintenance of the database needs to be paid attention, the purpose of the reports are only to save the query data structure. For further details, only a pivot table slicer or page-element should be changed.

All the above listed problems can be solved by OLAP Planner. Our experts* help you building up and operating clear and simple business models.

The SQL Server Analysis Services operates the multidimensional database, the clients are the Microsoft Excel software and its pivot tables tuned by OLAP-Planner.

The advantage of the application is that the users can use familiar environment for their controlling, and business budgeting work.

The multidimensional data can be quickly and easy referenced and integrated into Excel spreadsheet and in the existing budgeting framework.

Multidimensional reports can be prepared quickly, reducing time for ad-hoc reporting and significantly increases the efficiency of the controlling department.

Key performance indicators can be developed and own multidimensional calculations can be easily prepared for reports in the OLAP cube.


*“An expert is a man who has made all the mistakes which can be made, in a narrow field.”
NIELS BOHR, Danish Physicist, Nobel Prize for Physics in 1922

 
 
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.

*A multidimensional model means that e.g
. daily sales values could be aggregated by monthly and yearly levels, by customer groups or by geographical areas. If a cell value is retrieved from the OLAP cube, it will be much faster than calculating aggregates on the fly. We have a database where the aggregated data are in a consistent state.