Financial OLAP Tool
“Y.A.E. Financial Consulting Ltd.”
Established in 1989 the company has been engaged in
Finance, Economics, I.T. and Accounting Consulting.
All “under one roof”.
Today a major part of its activity is the Development,
Sale and Promotion of Software for
Preparing, Handling and Presenting
Contiki is an auxiliary software for the finance Department.
For the Controller, Accountant, Economist, CFO and CEO.
For quick preparation of the management output:
Statements, Booklets and OLAP presentations
for all management levels in the organization
Contiki provides a solution to all stages of Data preparation
Interface to Data Sources.
Data Processing, Improvement and Storage.
Both Hard Copy and On Screen output, suitable for all
It is a simple tool, easy to operate, integrated in Windows and Excel environment
The Contiki Data presentation tools
Pivot Table in Excel
Pivot Table in Explorer
Reports Generator in Excel
Excel Function for On-Line linking to the data
Other OLAP Clients (Data Analyzer)
Following are several examples:
How does Contiki Works?
Following is a flow chart:
Contiki Flow Chart
Operation Database (Cube)
General systems Preparing a
Ledger Interface cube
Defining dimensions in Excel files
Other OLAP Clients Reports Function in Pivot Table in Pivot Table
(Data Analyzer) Generator in Excel Excel in Explorer
Before starting current work, system establishment should take place.
Specification of Requirements
Specification of Data Interfaces
Definition and Establishment of Dimensions (in Excel)
Assignment of Entities (cards and items) to Dimensions
Preparing Presentations (Booklets for the Report Generator, Linked
Excel Sheets, opening pages for Pivot Tables)
Establishment is simple, fast and compatible with the work mode of the
When Establishing and Operating Contiki, stages and processes are
carried out that improve the way the Organization’s Information
Systems and Database are managed.
Contiki helps to manage orderly Information Systems, adjusted to the
Financial System and to identify inaccuracies, mistakes and
THE MENU LOOKS AS FOLLOWS:
KEY 1 : DEFINITIONS
Software parameters are defined in a sub-menu which
KEY 2: OPERATION
FROM HERE THE SOFTWARE IS
INTERFACES ARE DEFINED
DATA BANK IS PREPARED
CUBES ARE BUILT
RUNS ARE OPERATED
KEY3 : EXCEL
The data definition and their presentation are
carried out in Excel environment.
From this window you enter Excel to run Contiki.
To operate the excel Report Generator (TiK)
To define and maintain dimensions
PLAN / BUDGET
CONTIKI HAS TOOLS TO HANDLE PLANNING AND
EVRY EXCEL SHEET CAN BE ACCEPTED BY THE
CONTIKI DATA BANK
A BUDGET PREPARED INITIALLY IN EXCEL SHOULD
NOT BE RE-KEYED
ONE CAN PLAN IN FLEXIBLE TIME UNITS: MONTHS,
QUARTERS OR YEARS
BUDGET UPDATING MAY BE GENERATED DURING
The output: Reliable Reports for all management levels with the
ability to focus on specific issues.
Integrity and compatibility: Contiki extracts Data directly from
the organization's information systems thus assures reliable
Simple operation: The user's interface and the Excel.
environment do not require special qualifications and enable
independent operation of the software.
Time saving: Simple and Quick operation saves dear time.
Aesthetics: The reports are generated in quality graphic shape.
Feedback: The use of positively affects the
Organization's Information System.
audits and checks the Data.