Abstract: In an embodiment, for any structural change that is made to a relational database, a corresponding change is also made to the multidimensional database. In an embodiment, the system determines that a particular structure is not implemented on the multidimensional database system. Based on metadata that defines the structure that is supposed to exist in the multidimensional database, the appropriate structure is created.

Abstract: In an embodiment, for any structural change that is made to a relational database, a corresponding change is also made to the multidimensional database. In an embodiment, the system determines that a particular structure is not implemented on the multidimensional database system. Based on metadata that defines the structure that is supposed to exist in the multidimensional database, the appropriate structure is created.

Abstract: A mechanism and accompanying method adapted for use with a user interface for manipulating complex data strings. In an example embodiment, the method includes providing a dialog box that includes a first user option to input data pertaining to a complex data string; using data input pertaining to the complex data string to selectively verify that portions of the complex data string represent valid portions; providing a first user option via the dialog box to employ data input pertaining to the complex data string as one or more search criteria to selectively perform a search of preexisting complex data strings; and providing search results in response thereto, wherein the search results are displayed within the dialog box. In a specific embodiment, the method further includes providing a mechanism via the dialog box to trigger creation of a complex data string that a user has specified via the dialog box when search results for the complex data string to be created do not include a match.

Abstract: In an embodiment, for any structural change that is made to a relational database, a corresponding change is also made to the multidimensional database. In an embodiment, the system determines that a particular structure is not implemented on the multidimensional database system. Based on metadata that defines the structure that is supposed to exist in the multidimensional database, the appropriate structure is created.

Abstract: In an embodiment, for any structural change that is made to a relational database, a corresponding change is also made to the multidimensional database. In an embodiment, the system determines that a particular structure is not implemented on the multidimensional database system. Based on metadata that defines the structure that is supposed to exist in the multidimensional database, the appropriate structure is created.

Abstract: Various arrangements for posting a journal entry to a ledger are presented. The journal entry that comprises financial information related to a credit or debit from an account may be received. A request to post the journal entry to the ledger may be received. The journal entry may be determined to be subject to an approval process at least based on the ledger. At least one entity that is required to approve the journal entry as part of the approval process may be identified. An approval from the at least one entity may be received. After receiving approval, the journal entry may be posted to the ledger such that the ledger indicates the credit or debit of the journal entry. Posting of the journal entry to the ledger may require no input from the user following receiving the request to post the journal entry to the ledger.

Abstract: In an embodiment, for any structural change that is made to a relational database, a corresponding change is also made to the multidimensional database. In an embodiment, the system determines that a particular structure is not implemented on the multidimensional database system. Based on metadata that defines the structure that is supposed to exist in the multidimensional database, the appropriate structure is created.

Abstract: A method of detecting variances in a plurality of accounts from different organizations within an Enterprise Financial Accounting system includes receiving a selection of a first account with an account type; receiving a selection of a first time interval and a second time interval; determining a first amount that is associated with the first account during the first time interval; determining a second amount that is associated with the first account during the second time interval; receiving a selection of a comparison operator that relates the first amount to the second amount; receiving a selection of a threshold; determining a comparison value by comparing the first amount to the second amount according to the comparison operator; determining that the comparison value violates the threshold according to the comparison operator; and displaying a first indication in a portal comprised of the first amount, the second amount, and the comparison value.

Abstract: A method of previewing projected balance impacts in an Enterprise Financial Accounting System is presented. The method may include receiving journal entries that have not been posted to an accounting ledger; displaying the journal entries in a journal portlet; receiving a selection of a first journal entry with a first amount; determining a first ledger that is associated with the first amount; receiving a start date and a beginning balance of the first ledger on the start date; receiving an activity total including a sum of journal entries posted to the first ledger between the start date and a current date; determining a projected balance representing a combination of the beginning balance, the activity total, and the first amount; and displaying a projected balances portlet together with the journal portlet, that includes the beginning balance, the activity total, the first amount, and the projected balance.

Abstract: In an embodiment, for any structural change that is made to a relational database, a corresponding change is also made to the multidimensional database. In an embodiment, the system determines that a particular structure is not implemented on the multidimensional database system. Based on metadata that defines the structure that is supposed to exist in the multidimensional database, the appropriate structure is created.

Abstract: A mechanism and accompanying method adapted for use with a user interface for manipulating complex data strings. In an example embodiment, the method includes providing a dialog box that includes a first user option to input data pertaining to a complex data string; using data input pertaining to the complex data string to selectively verify that portions of the complex data string represent valid portions; providing a first user option via the dialog box to employ data input pertaining to the complex data string as one or more search criteria to selectively perform a search of preexisting complex data strings; and providing search results in response thereto, wherein the search results are displayed within the dialog box. In a specific embodiment, the method further includes providing a mechanism via the dialog box to trigger creation of a complex data string that a user has specified via the dialog box when search results for the complex data string to be created do not include a match.