Abstract: Certain aspects of the disclosure provide a method of constructing a report incorporating data stored in a plurality of database tables. The method generally includes receiving, via an interactive user interface (UI), a selection of a first database table, generating a visualization of data associated with the first database table organized in rows and columns, wherein each column includes data for a data field in the first database table, displaying, via the interactive UI, shared data fields associated with other related database tables and shared among all of the other database tables, receiving, via the interactive UI, a selection of a first shared data field, and displaying, via the interactive UI, data for the first shared data field from all the other database tables in a first new column added to the visualization, wherein each row in the first new column includes data from one of the other database table.

Abstract: Certain aspects of the disclosure provide a method of constructing a report incorporating data stored in a plurality of database tables. The method generally includes receiving, via an interactive user interface (UI), a selection of a first database table, generating a visualization of data associated with the first database table organized in rows and columns, wherein each column includes data for a data field in the first database table, displaying, via the interactive UI, shared data fields associated with other related database tables and shared among all of the other database tables, receiving, via the interactive UI, a selection of a first shared data field, and displaying, via the interactive UI, data for the first shared data field from all the other database tables in a first new column added to the visualization, wherein each row in the first new column includes data from one of the other database table.

Abstract: A system for analyzing an information system comprising a computer readable medium; and a set of computer readable instructions embodied in the computer readable medium for transmitting an audit application to a first store controller so that the audit application can generate audit data representing audit information from the first store controller, receiving audit data from the first store controller, transmitting an audit application to a second store controller so that the audit application can generate audit data representing audit information from the second store controller, receiving audit data from the second store controller, determining a comparison basis according to the audit information from the first store controller, comparing the audit date from the second store controller to the comparison basis, generating a set of comparison data resulting from the comparison, displaying items from the second store controller that are different from the comparison basis.