100 likes | 241 Views
Xabra Tools ™. Reports. Transformed Data. Raw Data. Source. Target. XBRL Taxonomy. Data Integration. E-Partner Integration. Business Intelligence. Reporting. Administration. Design. Xabra XReport. Transport services. Meta data repository. Xabra Constructor.
E N D
Reports Transformed Data Raw Data Source Target XBRL Taxonomy
Data Integration E-Partner Integration Business Intelligence Reporting Administration Design Xabra XReport Transport services Meta data repository Xabra Constructor Xabra Loader Encryption Xabra Transformer Fujitsu Xwand Compression Xabra Binder (Extract) XBRL Taxonomies Source Adapters Web Services XML / XBRL Legacy Applications Databases Industry Focus: Public Sector, Financial Services, Mid Market
Design SQL Xabra XReport Flat File Gen Xabra Constructor Xabra Loader Summarize Concatenate Xabra Transformer Fujitsu Xwand Filter Translator Xabra Binder (Extract) XBRL Taxonomies
CSMS System of Record Journal data US SGL Summary Entries INTERFACE Performance MLS AP/AR Budget Reporting Data Warehouse Translates MSA GL account format to US SGL; creates summary uploads Monthly Feed Business Analysis INTERFACE PMS AP/AR Next Things Journal data Case 1:HUD - The Problem… Summary data out of balance with transaction detail PeopleSoft Ongoing reconciliation Audit Rekey data for other uses Challenge: Consistent, timely, complete and accurate data
…The Solution CSMS System of Record PeopleSoft Contracts MAPPING TO XBRL GL Performance MLS AP/AR Budget Reporting Daily Feed Audit MAPPING TO XBRL GL Business Analysis PMS AP/AR Next Things Other Systems
Asia Universe L1 - Great Plains Ross MRP South America LOGIX L3 - Great Plains PACKIT Case 2: Mid Market Manufacturing • No detail below summary information • Problems with capturing, consolidating and reporting • Only PO, GR and Invoice data are exchanged • Peripheral systems ( Excel) are not interoperable • Cannot talk to customers, partners or regulatory bodies • No information on COGS • MRP is not visible to the central financial application Great Plains Europe 2 SAGE Europe 1 AS400 L2 - Great Plains Chameleon (MRP)
Brazil France MRP MRP Finance Finance AON AON AON AON Other Other Reports Reports MRP MRP Finance Finance Other Other The Solution.. ITALY MRP XBRL Houston Great Plain Financials System AON AON XBRL XBRL Other XBRL Taxonomy
Xabra Flat File Generator csv, fixed width files (S)ID ID Xabra Binder Xabra Summarizer database PDF, HTML Reports XReports SQL ID Xabra Loader Xabra Binder database csv
Xabra Loader SQL database (S)ID (SF)ID ID Xabra Binder Xabra Binder Filter Process Xabra Summarizer database PDF, HTML Reports XReports Xabra Binder database ID csv, fixed width files Xabra Flat File Generator (C)ID Consolidation Process Xabra Binder ID csv