OLAP Planner
Hungarian
 
   
 
"It is vain to do with more what can be done with fewer." WILLIAM OF OCKHAM (1300-1350),
the creator of the principle of "Ockham's razor"

The multidimensional cubes can be deep analyzed with OLAP Planner.
You can be famailiar with OLAP Planner during operation with the following downloadable videos.
 
 
 
"What if analysis..." - example The downloadable video (8 MB) presents the main planning capabilities of OLAP Planner (the first four features listed below are shown).

Top-down budgeting of weighted average prices


Top-down budgeting in hierarchy


Data writeback


Goal-seek calculation


Creating calculated member



Searching for an OLAP member

Creating and deleting filters


Data versioning


Built-in features for rolling budgeting and forecast


How can we adjust the average price weighted by quantity on an accumulated level; what will be the price of each element?

The value of a specified level of hierarchy is the aggregated value of the values of descendant levels. It is possible to manipulate the data on a defined scope, with the associated elementary-level data are even modified.

If we are calulating the standard cost of a product for example how we have to change the amendment cost per unit by cost allocation.

Searching for a particular break even point is a difficult task, if the margin calulation is determined by a number of variables. The goal-seek calulation is working with a predefined MDX (Multi Dimensional Expression) formula and calculates the quantity or unit price for a certain margin.

With a simple MDX calulation a new calculated column is taken up to the Pivot table, which will be available even after saving the workbook.

An OLAP cube may includes many elements - even with similar names - and among the dimensions can be difficult to navigate. The special search helps looking for these elements which can be added to our report.

A dimension or hierarchy can also contain many elements, but just a few items you would like to see your report. For this task the OLAP Planner filter is the useful tool.

New data versions can be made from actual data or even from a budgeting version for further modification.

"Time shift" can be applied on data sources: we can make a budgeting version for the actual period from the actual data of previous period and can forecasting easier.

 
 

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