Calculation Logic

From prevero Competence Center
Jump to: navigation, search
Last update: 01/2014

The Professional Planner framework is a multi-dimensional database system, purpose-built to process and analyze data linked by complex calculation operations, which makes it an advancement from OLAP to OLCAP technology. The framework uses relational databases to save the data to be managed and processed. It consists of a client/server architecture providing high-capacity clients to work directly with the database system. Standard interfaces are available as OLE DB providers.

Several steps are necessary to create an OLCAP database. First, we need a Business Content Library model. This model contains the structural design for the basic elements, the variables used in the database and the calculation links. It enables the Professional Planner framework to create and administer a relational database model. The actual dimensions and data manipulations are carried out in the client applications afterwards.

As creating a complete Business Content Library model can be quite time-consuming, Professional Planner is usually deployed as a ready-made application. This application consists of the Professional Planner Framework, one or more Business Content Library models and a complete set of documents for gathering and analyzing data.

Business Content Library[edit]

The BCL (short for: Business Content Library) determines the fundamental calculation and operational relationships within a company model in Professional Planner. As the calculation logic is saved in an external file, the BCL, the application is extremely flexible. It has the extension *.ped and is a non-readable binary file that can be processed directly in the Professional Planner framework. Therefore, each Professional Planner application is extremely flexible. Basically, any calculation logic can be used for a Professional Planner application by saving it in the respective BCL.

The business relationships within a company are illustrated in a BCL using structural elements.

Business Content Libraries can be created using the BCL Design Studio, but it is also possible to create Business Content Libraries that are especially designed for company-specific purposes together with a Professional Planner consultant within the context of a consulting project.

If you want to make minor modifications in your BCL, such as saving additional information, you can create additional fields yourself. For a detailed description of additional fields, click here.

See also[edit]

Operational Set of Formulas