our work for you

about us

our technologies

Oracle, Hyprion Essbase – PL-SQL, SQL, Oracle

Company: Hanex AG, Poznan

Technology: Microsoft Excel and VBA, Oracle

Link: Not available

People in the project: Stefan Tröhler

Implementation period: Mar 2005 – Sep 2005

Cost: no details

Support in the creation of an MSI for the group management of the company HANEX. The basis for this application is an Oracle database. Using Hyperion Essbase, multidimensional data structures are generated and mapped in Excel. The goal was to create consolidated reports for the management from these multidimensional data structures using Microsoft Excel and VBA. The project was implemented using Microsoft Excel and VBA.

  • Create a data warehouse with the data from different sources.
  • Loading data into the data warehouse using ETL processes.
  • Data mining of the long-term data stored in the data warehouse.
  • Evaluation of this data warehouse data.
  • Loading data from distributed and differently structured datasets.
  • Separation of the data used for the operative business.
  • Provision of the necessary infrastructure (Oracle, Excel, Essbase Add- In etc.).
  • Access to the necessary provided data via Excel Add-In (Essbase).
  • Filtering, sorting and refining the data using MS Excel (VBA, Array).
  • The Excel reports are created using VBA.
  • Creating the queries for data reference (SQL).
  • Interface development from SAP to the data warehouse (LDAP, ABAP).
Order a similar project
Add your project
If you want us to perform your project, upload all the necessary data and we will be happy to discuss with you all the details of our cooperation.
Want to order
Upload your brief
For message
Send Message
Order a template
To install and configure the theme, you need to specify your billing details and hosting data (FTP, PHP admin logins, passwords). After that, our specialists will install the template and you can test it.
Want to order
Hosting data and databases
For message
Send request
Add your Review
If you have worked with our company, you can add your review using the form below. Upload your review in A4 format (Microshoft World), Youtube url, text...
Upload your review
URL video-feedback Youtube
Write a review
Post a review
Add your review
If you have worked with our company, you can add your review using the form below. Upload your review in A4 format (Microshoft World)
Post a review

User Agreement

With this questionnaire (application) I officially express my consent to the processing (collection, systematization, accumulation, storage, clarification, (updates, changes), use, distribution (including transmission), depersonalization, blocking and destruction), including automated, my personal data specified in this Questionnaire (application), in accordance with the requirements of the law "On personal data".

The personal data specified by the client are provided for the purpose of communication with the client, as well as for informing about other products and services. Consent is provided from the moment of filling of this application for the entire life of the client.

This consent can be revoked by the client upon submission of an application in simple writing in accordance with legal requirements.

+41 (0)56 511 60 15

+41 (0)56 511 60 16 (fax)

+41 (0)76 737 00 84