DynAccSys Xabra

Download Report

Transcript DynAccSys Xabra

Xabra Tools ™
Reports
Source
Raw Data
Transformed
Data
XBRL Taxonomy
Target
Data
Integration
E-Partner
Integration
Business
Intelligence
Reporting
Administration
Design
Xabra XReport
Transport
services
Xabra Constructor
Xabra Loader
Meta data
repository
Encryption
Xabra Transformer
Fujitsu Xwand
Compression
Xabra Binder (Extract)
XBRL Taxonomies
Source Adapters
Databases
Legacy Applications
XML / XBRL
Web Services
Industry Focus: Public Sector, Financial Services, Mid Market
SQL
Flat File Gen
Design
Xabra XReport
Xabra Loader
Xabra Constructor
Xabra Transformer
Fujitsu Xwand
Xabra Binder (Extract)
XBRL Taxonomies
Summarize
Concatenate
Filter
Translator
Case 1:HUD - The Problem…
CSMS
System of
Record
US SGL Summary Entries
Journal data
Summary data out of balance
with transaction detail
MLS
PeopleSoft
Ongoing reconciliation
INTERFACE
Performance
AP/AR
Monthly Feed
INTERFACE
Data Warehouse
Translates MSA GL
account format to
US SGL; creates
summary uploads
Budget
Reporting
Audit
PMS
Business Analysis
AP/AR
Next Things
Rekey data for other
uses
Journal data
Challenge: Consistent,
timely, complete and
accurate data
…The Solution
CSMS
System of
Record
MLS
PeopleSoft
MAPPING TO
Contracts
XBRL GL
Performance
AP/AR
Budget
Reporting
Daily Feed
Audit
PMS
AP/AR
MAPPING TO
Business Analysis
XBRL GL
Next Things
Other Systems
Case 2: Mid Market Manufacturing
Asia
Universe
Europe 1
AS400
•
•
•
•
•
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
L1 - Great Plains
Ross MRP
South America
LOGIX
Europe 2
SAGE
L3 - Great Plains
PACKIT
L2 - Great Plains
Chameleon (MRP)
The Solution..
Brazil
France
MRP
ITALY
Finance
MRP
MRP
AON
AON
Other
Finance
Other
XBRL
Reports
Financials
System
AON
AON
Houston
Great Plain
XBRL
Reports
XBRL
MRP
MRP
Other
Finance
Other
AON
AON
Finance
Other
XBRL Taxonomy
database
Xabra
ID
Binder
Xabra
Xabra
csv,
Flat File
Generator
fixed
width files
XReports
PDF,
HTML
(S)ID
Summarizer
Reports
csv
Xabra
Binder
ID
Xabra
Loader
SQL
database
Xabra
Loader
database
Xabra
Binder
ID
Xabra
(S)ID
Summarizer
Filter
SQL
database
(SF)ID
Process
XReports
PDF,
HTML
Reports
database
Xabra
Binder
ID
Consolidation
Process
csv
Xabra
Binder
ID
(C)ID
Xabra
csv,
Flat File
Generator
fixed
width files