Legal claims defining the scope of protection. Each claim is shown in both the original legal language and a plain English translation.
1. A method of migrating financial data from a first financial consolidation application to a second financial consolidation application, said financial data comprising a plurality of transactions, said method being implemented in a digital processing system, said method comprising: identifying a set of categories according to which said plurality of transactions are classified in said first financial consolidation application; enabling a user to specify, for each of said set of categories, corresponding ones of the values for each of a set of dimensions, wherein each of the values represents a coordinate value in the corresponding dimension; storing, in said second financial consolidation application, said plurality of transactions classified according to said corresponding ones of values for said set of dimensions specified for said set of categories, wherein a transaction of a first category in said first financial consolidation application is stored in said second financial consolidation application associated with the values for said set of dimensions specified for said first category by said user, wherein said digital processing system comprises at least a processor which retrieves instructions from a memory and executes the retrieved instructions to perform at least one of said identifying, said enabling and said storing.
A method for migrating financial data from one financial consolidation application to another. The method identifies categories used to classify transactions in the first application. A user interface allows the user to map each category to specific values across a set of dimensions (e.g., scenario, year, entity) in the destination application. The system then stores the transactions in the second application, associating each transaction with the dimension values specified by the user for its original category. A computer processor performs these actions.
2. The method of claim 1 , wherein all of said set of dimensions are pre-specified in said second financial consolidation application, wherein said enabling comprises: displaying for each of said set of categories, said pre-specified set of dimensions and a corresponding list of values on a display unit, wherein said user selects said corresponding ones of the values from said corresponding list of values for each of said set of categories.
The financial data migration method described above has pre-defined dimensions in the second financial consolidation application. The user interface displays, for each category from the first application, the list of available dimensions and their corresponding values within the second application. The user selects appropriate values for each dimension for each category, ensuring compatibility between the source and destination systems.
3. The method of claim 2 , wherein said identifying further comprises determining a corresponding start year and a corresponding prior category for each of said set of categories, wherein said displaying also displays contemporaneously on said display unit, said corresponding start year and said corresponding prior category for each of said set of categories, wherein said displaying facilitates said user to select the appropriate ones of the values from said corresponding list of values for each of said set of categories.
In the financial data migration method, the system also determines the start year and prior category for each category in the first application. The user interface then displays the start year, the prior category, the predefined dimensions and the list of available values for each. This helps users select the appropriate dimension values, providing additional context during the mapping process.
4. The method of claim 3 , wherein said pre-defined set of dimensions comprises a scenario dimension and a year dimension, wherein the list of values for said scenario dimension includes at least one of “Actual”, “Budget”, and “Forecast”, wherein the list of values for said year dimension comprises a sequence of years, wherein said user specifies, for each of said set of categories, one of said values for said scenario dimension and one of said sequence of years for said year dimension, whereby said storing stores each of said plurality of transactions in said second financial consolidation application associated with the selected ones of values for respective two dimensions.
In the financial data migration method, two of the pre-defined dimensions are "Scenario" (with values like "Actual", "Budget", "Forecast") and "Year" (a sequence of years). The user interface allows the user to choose one scenario value and one year value for each category. The system stores transactions in the second application, associating them with the selected scenario and year values for their corresponding categories.
5. The method of claim 1 , said method further comprising: identifying a set of substructures storing break up information related to said plurality of transactions in said first financial consolidation application; enabling said user to specify, for each of said set of substructures, a corresponding one of a subset of dimensions, wherein said subset of dimensions is contained in said set of dimensions; and storing, in said second financial consolidation application, the break up information related to said plurality of transactions in said corresponding ones of said subset of dimensions.
The financial data migration method further handles substructures in the source application that contain detailed breakdown information for transactions. The system identifies these substructures and allows the user to map each substructure to a specific subset of dimensions in the destination application. The system then stores the breakdown information, associating it with the mapped subset of dimensions in the second application.
6. The method of claim 5 , wherein said subset of dimensions comprises a custom dimension and a value dimension, wherein said enabling comprises: determining, for each substructure, either a corresponding one of said custom dimension and said value dimension; and displaying for each of said set of substructures, said corresponding determined one of said custom dimension or said value dimension on a display unit, wherein said user is enabled to select said custom dimension for a substructure determined to be said value dimension.
In the financial data migration method, the subset of dimensions includes a "Custom Dimension" and a "Value Dimension." The system determines whether a substructure maps to the "Custom Dimension" or the "Value Dimension". The user interface displays the determined dimension for each substructure, but allows the user to override the automatic determination, specifically enabling the user to select the "Custom Dimension" even if the system initially determined "Value Dimension". This provides flexibility in mapping substructure information.
7. The method of claim 1 , wherein said first financial consolidation application contains an ordered sequence of accounts in a chart logic, said method further comprising: examining said chart logic to determine that a first account is defined to be a sum of a set of accounts by specifying a second account according to a first convention, wherein said first convention specifies that said set of accounts is formed by said second account and any intervening accounts between said second account and said first account in said ordered sequence of accounts, said first account and said second account being contained in said ordered sequence of accounts; adding in an account dimension hierarchy of said second financial consolidation application, said first account as an first inner node and each of said set of accounts as children of said first inner node, wherein said second financial consolidation application is designed to compute each inner node as a sum of the corresponding children, thereby computing said first account as a sum of said set of accounts.
The financial data migration method handles account hierarchies. If the first application uses chart logic where one account is defined as the sum of a range of other accounts, the system recognizes this pattern. It identifies the parent account and the child accounts within the defined range. The system then creates a corresponding account hierarchy in the destination application, placing the parent account as an inner node with the child accounts as its children. The destination application automatically calculates the parent account as the sum of its children.
8. The method of claim 7 , wherein said examining examines said chart logic to also determine that a third account is defined to be sum of a third set of accounts according to a second convention in said first financial consolidation application, wherein said second convention specifies that an account is to be included in said third set of accounts only if the sub-accounts of the account are identical to the sub-accounts of said third account, said third account and said third set of accounts being contained in said ordered sequence of accounts, wherein said adding adds to said account dimension hierarchy said third account as a second inner node and each of said third set of accounts as children of said second inner node, thereby causing said second financial consolidation application to compute said third account as a sum of said third set of accounts.
In the account hierarchy migration method, the system also identifies accounts defined as the sum of other accounts only if they share the same sub-accounts. If the first application defines account A as the sum of accounts B and C only if B and C have identical sub-accounts, the system recognizes this. The system creates an equivalent hierarchy in the destination application, placing account A as a parent node with B and C as children. The destination application automatically calculates account A as the sum of B and C.
9. A non-transitory machine readable medium storing one or more sequences of instructions for causing a system to migrate financial data from a first financial consolidation application to a second financial consolidation application, said financial data comprising a plurality of transactions, wherein execution of said one or more sequences of instructions by one or more processors contained in said system causes said system to perform the actions of: identifying a set of categories according to which said plurality of transactions are classified in said first financial consolidation application; enabling a user to specify, for each of said set of categories, corresponding ones of the values for each of a set of dimensions, wherein each of the values represents a coordinate value in the corresponding dimension; storing, in said second financial consolidation application, said plurality of transactions classified according to said corresponding ones of values for said set of dimensions specified for said set of categories, wherein a transaction of a first category in said first financial consolidation application is stored in said second financial consolidation application associated with the values for said set of dimensions specified for said first category by said user.
A non-transitory computer-readable storage medium contains instructions for migrating financial data from one financial consolidation application to another. The instructions, when executed, cause the system to identify categories used for classifying transactions in the first application. The system allows a user to map each category to specific values across a set of dimensions in the destination application. Finally, the system stores transactions in the second application, associated with dimension values specified by the user for each category.
10. The machine readable medium of claim 9 , wherein all of said set of dimensions are pre-specified in said second financial consolidation application, wherein said enabling comprises: displaying for each of said set of categories, said pre-specified set of dimensions and a corresponding list of values on a display unit, wherein said user selects said corresponding ones of the values from said corresponding list of values for each of said set of categories.
The computer-readable storage medium for migrating financial data, as described above, uses pre-defined dimensions in the second financial consolidation application. The instructions cause the system to display, for each category from the first application, the list of available dimensions and their corresponding values within the second application, so the user can select appropriate values for each dimension and category.
11. The machine readable medium of claim 10 , wherein said identifying further comprises determining a corresponding start year and a corresponding prior category for each of said set of categories, wherein said displaying also displays contemporaneously on said display unit, said corresponding start year and said corresponding prior category for each of said set of categories, wherein said displaying facilitates said user to select the appropriate ones of the values from said corresponding list of values for each of said set of categories.
The computer-readable storage medium for migrating financial data further causes the system to determine the start year and prior category for each category in the first application. When displaying the available dimensions and values, the system also displays the start year and prior category, providing more context for the user to select dimension values in the destination application.
12. The machine readable medium of claim 9 , further comprising one or more instructions for: identifying a set of substructures storing break up information related to said plurality of transactions in said first financial consolidation application; enabling said user to specify, for each of said set of substructures, a corresponding one of a subset of dimensions, wherein said subset of dimensions is contained in said set of dimensions; and storing, in said second financial consolidation application, the break up information related to said plurality of transactions in said corresponding ones of said subset of dimensions.
The computer-readable storage medium for migrating financial data further contains instructions to handle substructures in the source application that contain detailed breakdown information for transactions. The instructions, when executed, cause the system to identify these substructures and allow the user to map each substructure to a specific subset of dimensions in the destination application, then stores the breakdown information, associating it with the mapped subset of dimensions in the second application.
13. The machine readable medium of claim 12 , wherein said subset of dimensions comprises a custom dimension and a value dimension, wherein said enabling comprises one or more instructions for: determining, for each substructure, either a corresponding one of said custom dimension and said value dimension; and displaying for each of said set of substructures, said corresponding determined one of said custom dimension or said value dimension on a display unit, wherein said user is enabled to select said custom dimension for a substructure determined to be said value dimension.
In the computer-readable storage medium described above, the subset of dimensions includes a "Custom Dimension" and a "Value Dimension." The instructions cause the system to determine whether a substructure maps to the "Custom Dimension" or the "Value Dimension", and display the determined dimension. It further allows the user to override the automatic determination and manually select the "Custom Dimension" for a substructure.
14. The machine readable medium of claim 9 , wherein said first financial consolidation application contains an ordered sequence of accounts in a chart logic, further comprising one or more instructions for: examining said chart logic to determine that a first account is defined to be a sum of a set of accounts by specifying a second account according to a first convention, wherein said first convention specifies that said set of accounts is formed by said second account and any intervening accounts between said second account and said first account in said ordered sequence of accounts, said first account and said second account being contained in said ordered sequence of accounts; adding in an account dimension hierarchy of said second financial consolidation application, said first account as a first inner node and each of said set of accounts as children of said first inner node, wherein said second financial consolidation application is designed to compute each inner node as a sum of the corresponding children, thereby computing said first account as a sum of said set of accounts.
The computer-readable storage medium for migrating financial data also handles account hierarchies. If the first application uses chart logic where one account is defined as the sum of a range of other accounts, instructions cause the system to recognize this pattern, identify the parent and children, and create a corresponding account hierarchy in the destination application. The destination application then calculates the parent account as the sum of its children.
15. The machine readable medium of claim 14 , wherein said examining examines said chart logic to also determine that a third account is defined to be sum of a third set of accounts according to a second convention in said first financial consolidation application, wherein said second convention specifies that an account is to be included in said third set of accounts only if the sub-accounts of the account are identical to the sub-accounts of said third account, said third account and said third set of accounts being contained in said ordered sequence of accounts, wherein said adding adds to said account dimension hierarchy said third account as a second inner node and each of said third set of accounts as children of said second inner node, thereby causing said second financial consolidation application to compute said third account as a sum of said third set of accounts.
In the computer-readable storage medium's account hierarchy migration, the system also identifies accounts defined as the sum of other accounts only if they share the same sub-accounts. Instructions cause the system to create an equivalent hierarchy in the destination application, placing the parent account as a parent node with the matching children, so the destination application automatically calculates the parent account as the sum of its children.
16. A digital processing system comprising: a processor; a random access memory (RAM); a machine readable medium to store one or more instructions when retrieved into said RAM and executed by said processor forms a migration tool operable to migrate financial data from a first financial consolidation application to a second financial consolidation application, said financial data comprising a plurality of transactions, said migration tool performing the actions of: identifying a set of categories according to which said plurality of transactions are classified in said first financial consolidation application; enabling a user to specify, for each of said set of categories, corresponding ones of the values for each of a set of dimensions, wherein each of the values represents a coordinate value in the corresponding dimension; storing, in said second financial consolidation application, said plurality of transactions classified according to said corresponding ones of values for said set of dimensions specified for said set of categories, wherein a transaction of a first category in said first financial consolidation application is stored in said second financial consolidation application associated with the values for said set of dimensions specified for said first category by said user.
A digital processing system comprises a processor, RAM, and a storage medium storing instructions that, when executed, form a migration tool for financial data. The tool identifies categories classifying transactions in the source application, allows a user to map each category to dimension values in the destination application, and stores transactions in the destination system, associating them with the user-specified dimension values for each original category.
17. The digital processing system of claim 16 , wherein said machine readable medium further stores a first set of instructions and a second set of instructions, wherein said first set of instructions when retrieved into said RAM and executed by said processor forms said first financial consolidation, wherein said second set of instructions when retrieved into said RAM and executed by said processor forms said second financial consolidation application.
The digital processing system for migrating financial data also includes instructions to form the first financial consolidation application and second financial consolidation application when executed. This means the system can host both the source and destination applications internally.
18. The digital processing system of claim 16 , wherein all of said set of dimensions are pre-specified in said second financial consolidation application, wherein said migration tool for said enabling, performs the actions of: determining a corresponding start year and a corresponding prior category for each of said set of categories; and displaying contemporaneously, for each of said set of categories, said corresponding start year, said corresponding prior category, said pre-specified set of dimensions and a corresponding list of values on a display unit, wherein said user selects said corresponding desired values from said corresponding list of values for each of said set of categories.
In the digital processing system for migrating financial data, the tool determines the start year and prior category for each category in the source application, displaying these values alongside the available dimensions and values for each category in the destination application. This user interface element helps ensure accurate dimension value mapping.
19. The digital processing system of claim 16 , said migration tool further performs the actions of: identifying a set of substructures storing break up information related to said plurality of transactions in said first financial consolidation application; enabling said user to specify, for each of said set of substructures, a corresponding one of a subset of dimensions, wherein said subset of dimensions is contained in said set of dimensions; and storing, in said second financial consolidation application, the break up information related to said plurality of transactions in said corresponding ones of said subset of dimensions.
The digital processing system for migrating financial data also enables the migration tool to identify substructures containing breakdown information for transactions in the source application. The tool allows the user to map each substructure to a subset of dimensions in the destination application, and then stores this breakdown data in the destination system using this mapping.
20. The digital processing system of claim 16 , wherein said first financial consolidation application contains an ordered sequence of accounts in a chart logic, wherein said migration tool further performs the actions of: examining said chart logic to determine that a first account is defined to be a sum of a set of accounts according to a first convention, said set of accounts being contained in said ordered sequence of accounts; identifying the specific ones of said ordered sequence of accounts to be included in said set of accounts as indicated by said first convention; and adding in an account dimension hierarchy of said second financial consolidation application, said first account as a inner node and each of said set of accounts as children of said inner node, wherein said second financial consolidation application is designed to compute each inner node as a sum of the corresponding children, thereby computing said first account as a sum of said set of accounts.
In the digital processing system for migrating financial data, if the source application uses chart logic defining one account as the sum of a range of other accounts, the migration tool recognizes this. It identifies the parent account and the child accounts within the range according to those source application rules. It creates a corresponding account hierarchy in the destination system, placing the parent account as an inner node with the identified children, so the destination application calculates the parent account by summing its children.
Unknown
December 30, 2014
Browse 5M+ US patents with plain-English claim translations and AI-generated analysis.