• Banking Information Available
• Loading Process
• Additional Information

• Home
•   »  Solutions
•   »  Features
•   »  Banking Information

Common banking information is included in the generic banking data model, so this means all such information is immediately available for viewing, analysis etc.

Banking Information Available

This information includes:

• Static data including Accounts, Account Officers, Branches, Countries, Currencies, Customers, Facilities, Holidays, Industries, Products, Profit & Cost Centres and Rates
• Transaction-related data including Account Balances, Derivatives, Events, Foreign Exchange, Loans, Money Market, Postings and Securities

All this information is typically loaded after the bank's close of business processing each night.

All current static data and live transactions are loaded every time which creates a snapshot of the business as at the end of that day.  All this history is kept which means it is very easy to view any day in the past and see what was happening on that day.

IMPORTANT: Granville processes do not restrict information to be loaded only at the end of day. Information can be loaded at any time and some specialist applications are provided that do exactly that.

Loading Process

Granville solutions include Adaptors i.e. packaged ETL (Extract, Transform & Load) processes that capture data directly from source systems. IMPORTANT: Source systems do not need to provide the data through queries or other extracts.

An important concept in ETL is Transform as the system transforms all data (e.g. numeric codes, dates etc.) into meaningful information in a consistent format.

Data is also transformed from the structures of a specific source system into the structures of the generic banking data model, converting it into information.

Additional Information

Once loaded, the system creates or calculates other information:

• Other static data such as the data source (if data is loaded from more than one system), other lookup tables etc.
• Other transaction-related data such as:
• a summary data cube of all transactions from all business areas. This makes it very easy to see the entire bank's business in a single view (see TM1 Web Examples for a view of this cube)
• a cube which fully reconciles transactions back to postings

Customised cubes can also be created to provide any further customised analysis and views required.