A system for performing analytical operations on transactional data, the system comprising: one or more computing nodes (710a,710b,710n) communicatively coupled to a transactional database; and one or more memories having stored thereon computer-readable instructions that, upon execution by the one or more computing nodes, cause the system at least to: identify analytical relationships in transaction data stored by the transactional database; and automatically generate analytical queries utilizing the identified analytical relationships, wherein the identifying of the analytical relationships comprises: receiving information from a query log, the received information describing a plurality of queries (300,302,304) processed by the transactional database; analyzing the information received to identify a plurality of attributes associated with a dimension based at least in part on recurrence of coinciding references to at least two fields in the plurality of queries (300,302,304), the plurality of attributes based on the at least two fields; identifying a hierarchy level associated with the dimension by at least analyzing the plurality of queries for information indicative of a hierarchical organization of the plurality of attributes, the information analyzed comprising a data type of a field of the at least two fields, a first association of the field with a grouping clause in the plurality of queries, and a second association of the field with an aggregating clause in the plurality of queries; and forming a hierarchy comprising the plurality of attributes and the hierarchy level. one or more computing nodes (710a,710b,710n) communicatively coupled to a transactional database; and one or more memories having stored thereon computer-readable instructions that, upon execution by the one or more computing nodes, cause the system at least to: identify analytical relationships in transaction data stored by the transactional database; and automatically generate analytical queries utilizing the identified analytical relationships, wherein the identifying of the analytical relationships comprises: receiving information from a query log, the received information describing a plurality of queries (300,302,304) processed by the transactional database; analyzing the information received to identify a plurality of attributes associated with a dimension based at least in part on recurrence of coinciding references to at least two fields in the plurality of queries (300,302,304), the plurality of attributes based on the at least two fields; identifying a hierarchy level associated with the dimension by at least analyzing the plurality of queries for information indicative of a hierarchical organization of the plurality of attributes, the information analyzed comprising a data type of a field of the at least two fields, a first association of the field with a grouping clause in the plurality of queries, and a second association of the field with an aggregating clause in the plurality of queries; and forming a hierarchy comprising the plurality of attributes and the hierarchy level. identify analytical relationships in transaction data stored by the transactional database; and automatically generate analytical queries utilizing the identified analytical relationships, wherein the identifying of the analytical relationships comprises: receiving information from a query log, the received information describing a plurality of queries (300,302,304) processed by the transactional database; analyzing the information received to identify a plurality of attributes associated with a dimension based at least in part on recurrence of coinciding references to at least two fields in the plurality of queries (300,302,304), the plurality of attributes based on the at least two fields; identifying a hierarchy level associated with the dimension by at least analyzing the plurality of queries for information indicative of a hierarchical organization of the plurality of attributes, the information analyzed comprising a data type of a field of the at least two fields, a first association of the field with a grouping clause in the plurality of queries, and a second association of the field with an aggregating clause in the plurality of queries; and forming a hierarchy comprising the plurality of attributes and the hierarchy level. receiving information from a query log, the received information describing a plurality of queries (300,302,304) processed by the transactional database; analyzing the information received to identify a plurality of attributes associated with a dimension based at least in part on recurrence of coinciding references to at least two fields in the plurality of queries (300,302,304), the plurality of attributes based on the at least two fields; identifying a hierarchy level associated with the dimension by at least analyzing the plurality of queries for information indicative of a hierarchical organization of the plurality of attributes, the information analyzed comprising a data type of a field of the at least two fields, a first association of the field with a grouping clause in the plurality of queries, and a second association of the field with an aggregating clause in the plurality of queries; and forming a hierarchy comprising the plurality of attributes and the hierarchy level.