FINANCIAL REPORTING SYSTEM WITH REDUCED DATA REDUNDANCY

• US 20150227629A1
• Filed: 02/13/2014
• Published: 08/13/2015
• Est. Priority Date: 02/13/2014
• Status: Abandoned Application

• Current Assignee: SAP SE
• Original Assignee: SAP SE
• Inventors: Klensch, Christian
• Application Number:
  US14/179,746
• Publication Number:
  US 20150227629A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/24545 Selectivity estimation or determination
• CPC Class Codes: G06Q 40/12 Accounting

Abstract

The present disclosure involves systems, software, and computer-implemented methods for providing a split testing framework. An example method includes identifying a request for a particular financial report of one or more financial reports, each financial report based on financial data stored in a database, and including an execution plan representing how to select the financial data from the database and one or more calculations to be performed on the financial data; and in response to identifying the request for the particular financial report: selecting the financial data for the particular financial report, the selecting performed based at least in part on the execution plan for the particular financial report; performing the one or more calculations associated with the particular financial report on the selected financial data to produce financial report results; and presenting the financial report results.

Claims

1. A computer-implemented method executed by one or more processors, the method comprising:

identifying a request for a particular financial report of one or more financial reports, each financial report based on financial data stored in a database, and including an execution plan representing how to select the financial data from the database and one or more calculations to be performed on the financial data; and

in response to identifying the request for the particular financial report;

selecting the financial data for the particular financial report, the selecting performed based at least in part on the execution plan for the particular financial report;

performing the one or more calculations associated with the particular financial report on the selected financial data to produce financial report results; and

presenting the financial report results.

2. The method of claim 1, wherein the financial data is stored in a single location in the database without redundancy.

3. The method of claim 1, wherein the financial report results are not stored in the database.

4. The method of claim 1, wherein the one or more calculations associated with the particular financial report include a plurality of parallelizable calculations, and wherein performing the one or more calculations includes performing two or more of the parallelizable calculations concurrently.

5. The method of claim 1, wherein:

the database is a columnar database,

the financial data that the particular report is based on is included in plurality of different columns within the columnar database, and

selecting the financial data for the particular financial report includes selecting the data from two or more of the plurality of different columns concurrently.

6. The method of claim 1, wherein performing the one or more calculations associated with the particular financial report on the selected financial data includes performing the one or more calculations concurrently with selecting the financial data by performing the one or more calculations on each portion of the financial data associated with the particular financial report in response to it being selected.

7. The method of claim 1, wherein the financial data includes at least one of:

financial accounting data, asset accounting data, special ledger accounting data, or management accounting data.

8. The method of claim 1, wherein the one or more financial reports include at least one of:

a general journal report, a payables report, a receivables report, a revenue report, a cost report, a fixed assets report, or a material inventories report.

9. A non-transitory, computer-readable medium storing instructions operable when executed to cause at least one processor to perform operations comprising:

identifying a request for a particular financial report of one or more financial reports, each financial report based on financial data stored in a database, and including an execution plan representing how to select the financial data from the database and one or more calculations to be performed on the financial data; and

in response to identifying the request for the particular financial report;

selecting the financial data for the particular financial report, the selecting performed based at least in part on the execution plan for the particular financial report;

performing the one or more calculations associated with the particular financial report on the selected financial data to produce financial report results; and

presenting the financial report results.

10. The computer-readable medium of claim 9, wherein the financial data is stored in a single location in the database without redundancy.

11. The computer-readable medium of claim 9, wherein the financial report results are not stored in the database.

12. The computer-readable medium of claim 9, wherein the one or more calculations associated with the particular financial report include a plurality of parallelizable calculations, and wherein performing the one or more calculations includes performing two or more of the parallelizable calculations concurrently.

13. The computer-readable medium of claim 9, wherein:

the database is a columnar database,

the financial data that the particular report is based on is included in plurality of different columns within the columnar database, and

selecting the financial data for the particular financial report includes selecting the data from two or more of the plurality of different columns concurrently.

14. The computer-readable medium of claim 9, wherein performing the one or more calculations associated with the particular financial report on the selected financial data includes performing the one or more calculations concurrently with selecting the financial data by performing the one or more calculations on each portion of the financial data associated with the particular financial report in response to it being selected.

15. The computer-readable medium of claim 9, wherein the financial data includes at least one of:

financial accounting data, asset accounting data, special ledger accounting data, or management accounting data.

16. The computer-readable medium of claim 9, wherein the one or more financial reports include at least one of:

a general journal report, a payables report, a receivables report, a revenue report, a cost report, a fixed assets report, or a material inventories report.

17. A system comprising:

memory for storing data; and

one or more processors operable to perform operations comprising;

identifying a request for a particular financial report of one or more financial reports, each financial report based on financial data stored in a single location in a columnar database without redundancy and included in a plurality of different columns within the columnar database, each financial report including an execution plan representing how to select the financial data from the columnar database and one or more calculations to be performed on the financial data; and

in response to identifying the request for the particular financial report;

selecting the financial data for the particular financial report, the selecting performed based at least in part on the execution plan for the particular financial report, and including selecting the data from two or more of the plurality of different columns concurrently;

performing the one or more calculations associated with the particular financial report on the selected financial data to produce financial report results, wherein performing the one or more calculations associated with the particular financial report on the selected financial data includes performing the one or more calculations concurrently with selecting the financial data by performing the one or more calculations on each portion of the financial data associated with the particular financial report in response to it being selected; and

presenting the financial report results, wherein the financial report results are not stored in the database.

18. The system of claim 17, wherein the financial data includes at least one of:

financial accounting data, asset accounting data, special ledger accounting data, or management accounting data.

19. The system of claim 17, wherein the one or more financial reports include at least one of:

a general journal report, a payables report, a receivables report, a revenue report, a cost report, a fixed assets report, or a material inventories report.

20. The system of claim 17, wherein the one or more calculations associated with the particular financial report include a plurality of parallelizable calculations, and wherein performing the one or more calculations includes performing two or more of the parallelizable calculations concurrently.