Joining Of Logistical And Financial Data Related to Procurement Spending
A system, method, and computer program product for joining logistical and financial data related to procurement spending in a database. Financial data can be replicated from a first source to an analytics database. Procurement data from a second source can be replicated to the analytics database. The financial data can be filtered for procurement-related items to obtain procurement-related financial data. The obtained procurement financial data can be joined with the procurement data in the analytics database based on related information between the financial data and the procurement data. One or more reports based on the joined financial and procurement data can be generated in the analytics database. Related apparatus, systems, techniques and articles are also described.
1 . A method implemented on a computer comprising one or more data processors and one or more computer-readable media, comprising:
replicating, by one or more data processors, financial data from a first source to an analytics database implemented on one or more computer-readable media;
replicating, by one or more data processors, procurement data from a second source to the analytics database;
filtering, by one or more data processors, the financial data for one or more nonprocurement-related items and procurement-related items to obtained procurement-related financial data;
joining, by one or more data processors, the obtained procurement financial data with the procurement data in the analytics database based on related information between the financial data and the procurement data, the joining comprising creating a new database table based on a first table containing the obtained procurement-related financial data and a second table containing the procurement data; and
generating, by one or more data processors, one or more reports based on the one or more nonprocurement-related items and the joined financial and procurement data in the analytics database.
2 . A computer-implemented method according to claim 1 , wherein the procurement data being joined with the procurement-related financial data include material information.
3 . A computer-implemented method according to claim 1 , wherein the procurement data being joined with the procurement-related financial data include contract information.
4 . (canceled)
5 . A computer-implemented method according to claim 1 , wherein the analytics database utilizes in-memory technology.
6 . (canceled)
7 . A non-transitory machine-readable medium storing instructions that, when executed by at least one programmable processor, cause the at least one programmable processor to perform operations comprising:
replicating financial data from a first source to an analytics database;
replicating procurement data from a second source to the analytics database;
filtering the financial data for one or more nonprocurement-related items and procurement-related items to obtained procurement-related financial data;
joining the obtained procurement financial data with the procurement data in the analytics database based on related information between the financial data and the procurement data; and
generating one or more reports based on the one or more nonprocurement-related items and the joined financial and procurement data in the analytics database.
8 . A non-transitory machine-readable medium according to claim 7 , wherein the procurement data being joined with the procurement-related financial data include material information.
9 . A non-transitory machine-readable medium according to claim 7 , wherein the procurement data being joined with the procurement-related financial data include contract information.
10 . (canceled)
11 . A non-transitory machine-readable medium according to claim 7 , wherein the analytics database utilizes in-memory technology.
12 . A non-transitory machine-readable medium according to claim 7 , wherein the joining includes creating a new table based on a first table containing the obtained procurement-related financial data and a second table containing the procurement data.
13 . A system comprising:
at least one programmable processor; and
a machine-readable medium storing instructions that, when executed by the at least one programmable processor, cause the at least one programmable processor to perform operations comprising:
replicating financial data from a first source to an analytics database;
replicating procurement data from a second source to the analytics database;
filtering the financial data for one or more nonprocurement-related items and procurement-related items to obtained procurement-related financial data;
joining the obtained procurement financial data with the procurement data in the analytics database based on related information between the financial data and the procurement data; and
generating one or more reports based on the one or more nonprocurement-related items and the joined financial and procurement data in the analytics database.
14 . A system according to claim 13 , wherein the procurement data being joined with the procurement-related financial data include material information.
15 . A system according to claim 13 , wherein the procurement data being joined with the procurement-related financial data include contract information.
16 . (canceled)
17 . A system according to claim 13 , wherein the analytics database utilizes in-memory technology.
18 . A system according to claim 17 , wherein the analytics database is implemented on a high performance analytic appliance system.
19 . A system according to claim 13 , wherein the joining includes creating a new table based on a first table containing the obtained procurement-related financial data and a second table containing the procurement data.