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 Management Data: 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 management levels. It is a simple tool, easy to operate, integrated in Windows and Excel environment The Contiki Data presentation tools are: Pivot Table in Excel Pivot Table in Explorer Reports Generator in Excel Excel Function for On-Line linking to the data source Other OLAP Clients (Data Analyzer) Following are several examples: How does Contiki Works? Following is a flow chart: The organization’s Information Systems Contiki Flow Chart Auxiliary and Multidimensional Operation Database (Cube) General systems Preparing a Ledger Interface cube Contiki’s Data Warehouse Data Presentation Indexes.xls Defining dimensions in Excel files Other OLAP Clients Reports Function in Pivot Table in Pivot Table (Data Analyzer) Generator in Excel Excel in Explorer Excel System Establishment Before starting current work, system establishment should take place. It includes: 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 Finance Department 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 redundancies TO RUN… OPEN Contiki THE MENU LOOKS AS FOLLOWS: KEY 1 : DEFINITIONS Software parameters are defined in a sub-menu which opens KEY 2: OPERATION FROM HERE THE SOFTWARE IS OPERATED: 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 Etc. PLAN / BUDGET CONTIKI HAS TOOLS TO HANDLE PLANNING AND BUDGETING 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 YEAR ADVANTAGES 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 reports. 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.
Pages to are hidden for
"TiK Contiki"Please download to view full document