Single Window Systems
In the OIC Member States
104
Reference data is the definition of a data set that permits values to be used as a reference by other
data fields. The reference data must be coherent in mapping and syntax since they are data objects
used in processing and data transactions.
2. Data Warehousing
Data warehousing provides the separation of operational and retention data. The Data warehouse
is integrating data from one or more data sources in data cubes, organized in dimensions. Data
warehouse is a core component for Business Intelligence (BI)
SW should use BI systems to monitor of key performance indicators, analytic services, governance
and risks. The BI has an integrated portal as a presentation layer with a variety of dashboards, graph
and gauges presenting data in real time and in accurate manner. This is important analytic tool to
support the decision-making. .
5.1.7. Organisational Management
Three challenges occur or relate to the organizational management. The table below shows
these challenges and possible strategies and options to overcome these challenges.
Table 28: Organisational Management-Challenges and Options
Challenges
1. Financial Stability
Many SW operating entities report challenges to achieve financial stability and pressure due to
difficulties meeting revenue generation expectations. They operate under financial constraints, and
are dependent on budget allocations from the treasury or on own revenues, which often are just
sufficient to cover operational expenses. Often there is a mismatch between the official business
model of a self-reliable SW entity and the reality of dependence on funding from the annual
government budget.
Different funding and fee models are adopted for Single Windows.
 the public model where the government entirely funds the building and, in some cases also
the operating expenses of the SW,
 the public-private model where the funding for investment and operating costs are shared
between the government and a private partner76, and a private model where all the costs are
paid for by a private entity77.
Each of these models has different implications for the financial management and stability.
76 In these models the government contribution to the initial investment is commonly an equity investment.
77 The private model is very rare for Single Windows for Trade but frequent for Cargo Community systems