Email Contact Phone Company Visit Website

Vilnius, Lithuania Office Head Office

Tuskulenu 33 c
Vilnius
LT

Telephone

+370 98 49435

Contact

Andrej Zujev
[email protected]

FORPOST*Data Warehouse

FORPOST*Data Warehouse

 

FORPOST*Data Warehouse is a data repository designed for creation and management of analytical and statistical reports. This technology comprises preparation and automatic transfer of data from the main system to the Data Warehouse, preliminary consolidation, a system of report preparation and delivery to users, and a diversity of other functions.

 

Purpose of Data Warehouse:

 

§         Data warehouse is provided in a convenient form for analysis and archiving

§         Reducing of data volume on the banking system OLTP

§         Releasing of significant OLTP calculation resources

§         Consolidation of the data obtained from different sources

§         Data standardisation

§         Preparation of complex accounting and improved analysis models

§         Great possibilities of transferring the data (information) to customers

 

Functional Composition:

 

§         GUI

·         Integral space of administration and parameterisation interface for operation with screen forms and reports

·         WEB interface (if required)

·         Interface of sizes and facts control

§         Automation of processes

·         Task management (Oracle Jobs)

·         Protocols of data loading and performance of tasks (using STAGE technology);
management of uploaded data volume and complexity using parameterisation (XML)

·         Means of efficient informing of administrators
(e-mail, SMS)

·         Scripts of reports

§         Repository

§         Means of displaying

·         MS Office Reports

·         XSR Reports

·         Oracle Reports

·         Oracle Discoverer

§         Data upload is possible not only from BIS FORPOST, but also from other sources.  Data upload periodicity is set as required.

 

Report creation instruments:

 

§         MSO technology

·         Usual report formation

·         Information presentation in MS Excel, MS Word, HTML

·         Storing of open SQL requests in FDWH data base

·         Arranging of SQL requests library

·         Possibility of additional analysis of MS Excel data (data grouping, pivot-table)

·         Reports layout created in MS Office applications and separated from data preparation

§         XSR technology

·         Use of developed standards (SQL, XML, XSLT)

·         SQL requests (reports descriptions) stored in FDWH, easily co-ordinated, and supporting parameters

·         Internal (Oracle) and external (Microsoft) transformation

·         One report presentation in several ways (separation of data and layout)

·         Usual API (1 package) and large possibilities of integration (FORPOST*XML API)

·         Storing of the result and report performance protocol in the data base

·         Great efficiency

§         Oracle BI discoverer

·         Organisation of analysis according to user rights and rules

·         Operation in the customer-server mode and access via Web

·         Support of parameters, pivot-tables, and drill-down principles

·         Information export into MS Excel and other formats

§         Showcases technology

·         Using of XML (new!)

·         Detailed log of calculation (for each indicator)

·         Re-calculation of one indicator

·         Storing of detailed data

·         Storing of parameters

·         Administration

 

More detailed information may be found at: http://www.forbis.lt/pub/home/content/forpost/functionality/reporting/warehouse

 

View other products from FORBIS Ltd

FORPOST*Loans

FORPOST*Loans is a comprehensive set of typical credit products. FORPOST*Loans features accounting of mortgages and guarantees, calculation of special reserves, portfolio management, risk control and management of written-down loans. Products are accompanied by an advanced reporting system. Basic Products: Term loan Annuity loan  Credit line  Simple overdraft  Payment card overdraft It is also possible to …

FORPOST*Application Servicing

FORPOST*Application Servicing is a subsystem of BIS FORPOST designed to register and satisfy bank customers’ wishes (applications) to use certain banking services, or to buy certain banking products. The subsystem realization allows describing parameters that have to be entered during the moment when the application is registered and which later may be used to make …

FORPOST*Cards

For banks emitting and acquiring payment cards, the Forbis Company offers the FORPOST*Cards product, featuring three main components: FORPOST*Card Issuing, FORPOST*Merchant Acquiring, FORPOST*Off-Line Processing. All components are integrated with the most common Front-Office systems used by the processing centres. FORPOST supports magnetic and/or chip cards. Both local cards and cards of various international payment systems …