# US 10,319,044 B2 · Transaction functionality in a multidimensional database > Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt - Number: US 10,319,044 B2 - Document ID: US10319044B2 - Status: Granted - Kind: B2 - Application number: 15/332,238 - Filed: 2016-10-24 - Published: 2017-04-27 - Granted: 2019-06-11 - Earliest claimed: 2015-10-24 - Assignees: Oracle International Corporation - Applicants: Oracle International Corporation - Inventors: Donald Wayne Bean; Dinesh Balebail; Shailesh Phansalkar - Web page: https://patentgrep.com/patent/US10319044B2 ## CPC - G06Q 40/128: {Check-book balancing, updating or printing arrangements} - G06Q 40/02: Banking, e.g. interest calculation or account maintenance (credit or loans G06Q40/03) - G06Q: INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR ## Abstract Systems and methods that enable transaction oriented functions for a multidimensional database are provided. The systems and methods store a plurality of transactions in a multidimensional database, generate a first dimension including respective balances resulting from each of the transactions, and generate a second dimension identifying respective rules corresponding to each of the transactions. ## Claims ### Claim 1 A method for enabling transaction oriented functions within a multidimensional database, the method comprising: receiving financial data generated in response to a plurality of transactions; storing the financial data as multidimensional data in the multidimensional database, the multidimensional database comprising a plurality of dimensions, the dimensions comprising a balance dimension that stores a balance of the financial data at each of the transactions as data elements, and a rules dimension that stores each of a plurality of rules used to execute the plurality of transaction as rule elements; generating a visual representation of the data elements of the balance dimension and the rule elements of the rules dimension, the visual representation comprising visual cues that distinguishes between raw financial data and calculated financial data in the balance dimension, and that, for each of the calculated financial data, a corresponding rule element of the rules dimension that caused a calculation to generate the calculated financial data. ### Claim 2 (depends on 1) The method according to claim 1, further comprising rolling back at least one of the transactions using one of the balance dimension or the rules dimension. ### Claim 3 (depends on 1) The method according to claim 1, further comprising rolling back through the rules dimension to a starting point of the plurality of transactions. ### Claim 4 (depends on 1) The method according to claim 1, further comprising a first visual cue for a first rule elements that indicates that the first rule element caused calculated financial data for two or more corresponding data elements of the balance dimension. ### Claim 5 (depends on 1) The method according to claim 1, further comprising graphically identifying a movement of money between two entities based on the plurality of transactions. ### Claim 6 (depends on 1) The method according to claim 1, wherein input data of the transactions is unchanged after execution of the transactions. ### Claim 7 (depends on 2) The method according to claim 2, wherein the multidimensional database comprises an Essbase data structure comprising an aggregate storage option cube and using striped allocation and the rolling back comprises enabling undo functionality of the striped allocation. ### Claim 8 (depends on 1) The method according to claim 1, further comprising computing a remainder value or balancing value after each successive execution of the rules. ### Claim 9 A device comprising: a processor; and a memory storing one or more programs for execution by the processor, the one or more programs including instructions for: receiving financial data generated in response to a plurality of transactions; storing the financial data as multidimensional data in a multidimensional database, the multidimensional database comprising a plurality of dimensions, the dimensions comprising a balance dimension that stores a balance of the financial data at each of the transactions as data elements, and a rules dimension that stores each of a plurality of rules used to execute the plurality of transaction as rule elements; generating a visual representation of the data elements of the balance dimension and the rule elements of the rules dimension, the visual representation comprising visual cues that distinguishes between raw financial data and calculated financial data in the balance dimension, and that, for each of the calculated financial data, a corresponding rule element of the rules dimension that caused a calculation to generate the calculated financial data. ### Claim 10 (depends on 9) The device according to claim 9, further comprising instructions for rolling back at least one of the transactions using one of the balance dimension or the rules dimension. ### Claim 11 (depends on 9) The device according to claim 9, further comprising instructions for rolling back through the rules dimension to a starting point of the plurality of transactions. ### Claim 12 (depends on 9) The device according to claim 9, further comprising a first visual cue for a first rule elements that indicates that the first rule element caused calculated financial data for two or more corresponding data elements of the balance dimension. ### Claim 13 (depends on 9) The device according to claim 9, further comprising instructions for graphically identifying a movement of money between two entities based on the plurality of transactions. ### Claim 14 (depends on 10) The device according to claim 10, wherein the multidimensional database comprises an Essbase data structure comprising an aggregate storage option cube and using striped allocation and the rolling back comprises enabling undo functionality of the striped allocation. ### Claim 15 (depends on 9) The device according to claim 9, further comprising instructions for computing a remainder value or balancing value after each successive execution of the rules. ### Claim 16 A non-transitory computer readable storage medium storing one or more programs configured to be executed by a processor, the one or more programs comprising instructions for: receiving financial data generated in response to a plurality of transactions; storing the financial data as multidimensional data in a multidimensional database, the multidimensional database comprising a plurality of dimensions, the dimensions comprising a balance dimension that stores a balance of the financial data at each of the transactions as data elements, and a rules dimension that stores each of a plurality of rules used to execute the plurality of transaction as rule elements; generating a visual representation of the data elements of the balance dimension and the rule elements of the rules dimension, the visual representation comprising visual cues that distinguishes between raw financial data and calculated financial data in the balance dimension, and that, for each of the calculated financial data, a corresponding rule element of the rules dimension that caused a calculation to generate the calculated financial data. ### Claim 17 (depends on 16) The non-transitory computer readable storage medium of claim 16, further comprising instructions for rolling back at least one of the transactions using one of the balance dimension or the rules dimension. ### Claim 18 (depends on 16) The non-transitory computer readable storage medium of claim 16, further comprising instructions for rolling back through the rules dimension to a starting point of the plurality of transactions. ### Claim 19 (depends on 17) The non-transitory computer readable storage medium of claim 17, wherein the multidimensional database comprises an Essbase data structure comprising an aggregate storage option cube and using striped allocation and the rolling back comprises enabling undo functionality of the striped allocation. ### Claim 20 (depends on 16) The non-transitory computer readable storage medium of claim 16, further comprising a first visual cue for a first rule elements that indicates that the first rule element caused calculated financial data for two or more corresponding data elements of the balance dimension.