The Architecture

BI Reporting allows the user to view and if required modify, the data received from LN. To understand the transfer of data from LN to the BI Reporting module, the user must first understand the architecture of the Reporting tool.

[...]

The components that facilitate the data transfer to the BI:

  • Infor LN: Infor LN is the source of data for the BI reporting tool, as the data originates from various sessions such as budgeting, projects, revenues, scheduling, and so on. This data is transferred to Infor ION using BODs.
  • BOD (Business Object Document): BODs are the communication link between the components of the BI architecture. A BOD is an XML message used to exchange data between enterprises or enterprise applications. The BOD is composed of a noun, which identifies the message content, and a verb, which identifies the action to be taken with the document. The unique combination of the noun and the verb forms the name of the BOD. For example, the noun Project Master combined with the verb Sync results in the BOD SyncReceiveDelivery.
  • Infor ION (Intelligent Open Network): Infor ION connects and integrates applications, storing information in a common format and repository. ION allows information flow among applications and analytics to be accessed easily by users.
  • Stored Procedures and Database: Stored procedures are a set of SQL instructions used to perform a task. In EVMS, stored procedures are used to shred the XML and load the database.
Tracing the data transfer from Infor LN to BI
  1. Data is transferred from Infor LN to Infor ION using BODs.
    • The data from the BODs is transferred to ION.
    • The path to trace the BOD: Manage → Connect → Message Trace.
      • [...]
    • Identify the document, specify the date range.
    • Click Search.
    • Review the data that has been transferred to ION.
  2. Data is transferred from ION to the database through stored procedures that are executed according to the schedule specified for the EVMS Job in the Import Master. The data published is available in the database and reports only after the EVMS Job is executed.
    • [...]
    • Review the data in the database.