Information sources are a combination of facts and dimensions which are structured
and holds information about a specific transaction table in IFS Applications. Currently
there are 26 information sources based on IFS Financials. One or many of these information
sources can be used when creating an IFS Business Analytics report.
An overview of each information source mainly based on IFS Financials is given below:
Budget Drivers information source is based on IFS\Budget Process. This information source carries the values for budget drivers that are used in driver-based budgeting processes. This information source can be used to design reports based on budget driver values that are entered in a budget template in IFS Budget Process functionality. These budget driver values can then be modified and written back to IFS Applications. The budget driver values can also be used to arrive at budgeted amounts for certain costs/revenues that are to be written back to IFS Applications through Budget Template Transactions information source.
The budget user roles which are defined when entering budget process basic data will be applicable when accessing and writing back budget driver values through Budget Drivers information source.
Zoom In: Available for all measures
Drill Down: Not available
Writeback: Enabled for currency amount, quantity and row comment measure/light items.
URL navigation: To the Budget Template window in Financials/Budget Process.
Online, DataMart
Budget Template Transaction information source is based on IFS/Budget Process. This information source can be used to design reports based on transactions in budget templates which are connected to budget processes. Information in the report can be modified and these modified values can be written back to IFS Applications. The budget user roles that are defined in the Budget Process Basic Data will be applicable when accessing and writing back budget amounts through Budget Template Transactions information source.
Zoom In: Available for all measures
Drill Down: Not available
Writeback: Enabled for currency amount, quantity and row comment measure/light items.
URL navigation: To the Budget Template window in Financials/Budget Process.
Online, DataMart
Currency Rate information source is based on IFS\Accounting Rules\Currency. This information source can be used to design reports using Currency Rate information.
Zoom In: Available for all measures
Drill Down: Not available
Writeback: Not available
URL navigation: To Currency Rates window in Accounting Rules/Currency.
Online, DataMart
Cash Flow Forecast information source is based on IFS/Cash Flow Analysis. The cash flow forecast information created in IFS Applications can be accessed through Cash Flow Forecast information source in order to carry out comparisons, trend analysis and cash flow planning activities. It is possible to modify manual cash flow forecast information in a Business Analytics report and write them back to the selected cash flow forecast in IFS Applications.
Zoom In: Available for all measures
Drill Down: Not available
Writeback: Enabled for currency amount, currency code and event date measure items.
URL navigation: Not available
Online
Customer Credit Management information source is based on IFS\Customer Credit Management. This information source can be used to design reports on customer credit and debt collection.
In order to get up to date information, customer credit information must be calculated from the Calculate Customer Credit Information dialog box.
Zoom In: Available for all measures
Drill Down: Available on ‘Total Sales’ measure item. Drills down to Customer Invoices
information source.
Writeback: Not available
URL navigation: To Customer Credit Analysis window in Financials/Customer Credit Management.
Online, Data Mart
Customer Invoices information source is based on IFS\Customer Invoices. This information source can be used to design reports and queries about customers and customer invoices. The customer invoice amount and tax amount in transaction currency and accounting currency together with open amount for invoices can be analyzed in different dimensions such as company, customer, invoice type, and the code string.
Zoom In: Available for all measures
Drill Down: Not available
Writeback: Not available
URL navigation 1:To Customer Invoices
Analysis window in Financials/Customer Invoice/Analysis.
URL navigation 2: To Customer
Invoice Postings Analysis in Financials/Customer Invoice/Analysis.
Online, Data Mart
Customer Open Balance information source is based on customer open balance history information generated in Financials/Accounts Receivables/Analysis. Customer open balance history can be created with user-defined time intervals. This information source has information about open amounts per customer invoices and can be analyzed based on customer, company, invoice types, currency, code string and project etc.
Zoom In: Available for all measures.
Drill Down: Not available
Writeback: Not available
URL navigation: Not available
Online
Customer Payments information source is based on IFS/Payments. This information source can be used to generate queries and reports on customer payments at an abstract level of total payments. The transaction level of customer payments can be assessed using Customer Payment Transactions information source.
Zoom In: Available for all measures
Drill Down: To Customer Payment Transactions
Writeback: Not available
URL navigation: To Customer Payments Analysis window in Financials/Cash Book/Analysis
Online, Data Mart
Customer Payment Transactions information source is based on IFS/Payments. This information source can be used to generate queries and reports at the transaction level of the customer payments, combined with customer and invoice information. Interest and fine, write-off, deductions, discounts, and currency difference related information are also available in this information source.
Zoom In: Available for all measures
Drill Down: Not available
Writeback: Not available
URL navigation: Customer Payment Analysis window in Financials/Cash Book/Analysis
Online, Data Mart
General Ledger Balance information source is mainly based on IFS/General Ledger. This information source can be used to design reports based on general ledger balances in accounting currency, transaction currency, and third currency for any accounting period, account and/or code parts. Quantity analysis based on accounts and code parts can also be performed. Detailed balance analysis can be carried out based on projects as well. In order to analyze the balances further the drill down feature can be used where the general ledger balance can be drilled down up to the related general ledger voucher rows in the IFS Applications.
Zoom In: Available for all measures
Drill Down: To General Ledger Transactions
Writeback: Not available
URL navigation: Not available
Online, Data Mart
General Ledger Period Budget information source is mainly based on IFS/General Ledger. This information source can be used to design reports based on general ledger periodic budget amounts in accounting currency and third currency with quantities for any budget version. Analysis can be extended to include accounts and other code parts including projects.
Used in combination with GL Balance information source for Variance Analysis
Zoom In: Available for all measures
Drill Down: Not available
Writeback: Not available
URL navigation: Not available
Online, Data Mart
General Ledger Project Transaction information source is mainly based on IFS /General Ledger - Project Accounting. This information source can be used to design reports based on general ledger transactions related to projects. These transactions can be analyzed based on accounting currency amounts, transaction currency amounts and third currency amounts for any accounting period. If you need to analyze project transactions for each project group or project type, it is possible to do so using this information source.
Zoom In: Available for all measures
Drill Down: Not available
Writeback: Not available
URL navigation 1: To GL
Voucher Rows Analysis window in Financials/ General Ledger.
URL navigation 2: To GL
Voucher Details Analysis window in Financials/General Ledger.
Online, Data Mart
General Ledger Project Balance information source is mainly based on IFS/General Ledger. This information source can be used to design reports based on general ledger balances in accounting currency, transaction currency, and third currency with or without quantity balances for any accounting period for each accounting project. Reports can be further analyzed based on accounts and other code parts.
Zoom In: Available for all measures
Drill Down: Not available
Writeback: Not available
URL navigation: Not available
Online, Data Mart
General Ledger Project Cost/Revenue Balance information source is mainly based on IFS/General Ledger. This information source can be used to design reports based on cost and revenue balance amounts for projects in accounting currency, transaction currency and third currency for any accounting period. In order to analyze the balances in detail, the drill down feature can be used where project cost/revenue balances can be drilled down up to project cost/revenue transactions.
Project cost/revenue balance analysis
Zoom In: Available for all measures
Drill Down: To General Ledger Cost/Revenue Transactions information source
Writeback: Not available
URL navigation: Not available
Online, Data Mart
General Ledger Project Cost/Revenue Transaction information source is mainly based on IFS/ General Ledger. This information source can be used to design reports to analyze project cost and revenue type transaction amounts in accounting currency, transaction currency and third currency for any accounting project. These amounts can be analyzed based on accounting periods, accounts, code parts, journal numbers, voucher types and voucher numbers.
Zoom In: Available for all measures
Drill Down: Not available
Writeback: Not available
URL navigation 1: To GL
Voucher Rows Analysis window in Financials/ General Ledger
URL navigation 2: To GL
Voucher Details Analysis window in Financials/General Ledger.
Online, Data Mart
General Ledger Snapshot Balance information source is based on Snapshot Consolidation of GL Balances in IFS/Consolidated Accounts. This information source consists of a snapshot of consolidated general ledger balances in a group of companies. Since this is only a snapshot, this information should not be used for legal reporting purposes. Snapshot balances should be used for internal corporate analysis purposes. General Ledger balances transferred from subsidiary companies to parent company during IFS/Consolidated Accounts can be accessed through General Ledger information source.
Zoom In: Available for all measures
Drill Down: Not available
Writeback: Not available
URL navigation: Not available
Online, Data Mart
General Ledger Snapshot Period Budget information source is based on Snapshot Consolidation of GL Budget in IFS/Consolidated Accounts. This information source consists of a snapshot of consolidated GL budget amounts in a group of companies. The snapshot of budget amounts from subsidiary companies can be used along with snapshot of GL balances from subsidiary companies to compare actual financial performance against the budget.
Snapshot variance analysis of consolidated GL balances of a group of companies (together with GL Snapshot Balance information source)
Zoom In: Available for all measures
Drill Down: Not available
Writeback: Not available
URL navigation: Not available
Online, Data Mart
General Ledger Transaction information source is mainly based on IFS/General Ledger. This information source can be used to design reports based on general ledger transactions in accounting currency, transaction currency and third currency for any accounting period. These amounts can be analyzed based on accounting periods, accounts, code parts, journal numbers, voucher types and voucher numbers etc.
Zoom In: Available for all measures
Drill Down: Not available
Writeback: Not available
URL navigation 1: To GL Voucher
Rows Analysis window in Financials/ General Ledger
URL navigation 2: To GL
Voucher Details Analysis window in Financials/General Ledger.
Online, Data Mart
Internal Ledger Period Budget information source is based on budget period amounts created for Internal Ledger in IFS/Budget Management. This information source can be used to design reports based on internal ledger periodic budget amounts in accounting currency and third currency with quantities for any budget version. Analysis can be extended to include accounts and other code parts including projects.
Variance analysis of internal ledger balances (together with Internal Ledger balances information source)
Zoom In: Available for all measures
Drill Down: Not available
Writeback: Not available
URL navigation: Not available
Online, Data Mart
Internal Ledger Balance information source is mainly based on IFS/Internal Ledger. This information source can be used to design reports based on internal ledger balances in accounting currency, transaction currency, and third currency for any accounting period for any account and code part. Quantity analysis based on accounts and other code parts can also be performed. In order to analyze the balances in detail, the drill down feature can be used where internal ledger balances can be drilled down up to related internal ledger voucher rows in IFS Applications.
Zoom In: Available for all measures
Drill Down: To Internal Ledger Transactions information source
Writeback: Not available
URL navigation: Not available
Online, Data Mart
Internal Ledger Snapshot Balance information source is based on IL Snapshot Consolidation in IFS/Consolidated Accounts. This information source consists of a snapshot of consolidated internal ledger balances in a group of companies. Since this is only a snapshot, this information should only be used for internal corporate analysis purposes.
Snapshot analysis of consolidated Internal Ledger balances of a group of companies
Zoom In: Available for all measures
Drill Down: Not available
Writeback: Not available
URL Navigation: Not available
Online, Data Mart
Internal Ledger Transaction information source is mainly based on IFS/Internal Ledger. This information source can be used to design reports based on internal ledger transactions in accounting currency, transaction currency and third currency for any accounting period in internal ledger. These amounts can be analyzed based on accounts, code parts, voucher types and voucher numbers etc.
Zoom In: Available for all measures
Drill Down: Not available
Writeback: Not available
URL navigation 1: To IL
Voucher Rows Analysis window in Financials/Internal Ledger/Analysis.
URL navigation 2: To
IL Voucher Details Analysis window in Financials/Internal Ledger/Analysis.
Online, Data Mart
Supplier Invoices information source is based on IFS\Supplier Invoices. This information source can be used to design reports and queries about suppliers and supplier invoices. Using this information source, supplier invoice amount and tax amount in transaction currency and accounting currency together with open amount for invoices can be analyzed in different dimensions such as company, supplier, invoice type, and the code string.
Zoom In: Available for all measures
Drill Down: Not available
Writeback: Not available
URL navigation 1: To Supplier
Invoices Analysis in Financials/Accounts Payable/Analysis
URL navigation 2: To Supplier Invoice Analysis in Financials/Accounts Payable/Analysis
Online, Data Mart
Supplier Open Balance information source is based on supplier open balance history information generated in Financials/Accounts Payables/Analysis. Supplier open balance history can be created with user-defined time intervals. This information source has information about open amounts per supplier invoices and can be analyzed based on supplier, company, invoice types, currency, code string and project etc.
Zoom In: Available for all measures
Drill Down: Not available
Writeback: Not available
URL navigation: Not available
Online
Supplier Payments information source is based on IFS/Payments. This information source can be used to generate queries and reports on Supplier payments at an abstract level of total payments.
Zoom In: Available for all measures
Drill Down: To Supplier Payment Transactions information source
Writeback: Not available
URL navigation: To Supplier
Payments Analysis window in Financials/Cash Book/Analysis
Online, Data Mart
Supplier Payment Transactions information source is based on IFS/Payments. This information source can be used to generate queries and reports on at the transaction level of the Supplier payments, combined with Supplier and invoice information.
Zoom In: Available for all measures
Drill Down: Not available
Writeback: Not available
URL navigation: To Supplier
Payments Analysis window in Financials/Cash Book/Analysis
Online, Data Mart
Tax Ledger Transaction information source is mainly based on IFS/Tax Ledger. This information source can be used to design reports to analyze tax base amounts, tax amounts and difference in tax amounts for any accounting period.
Zoom In: Available for all measures
Drill Down: Not available
Writeback: Not available
URL navigation: To
Tax Transactions window
in Financials/Tax Ledger
Online, Data Mart