1. A method of processing report queries in a storage area network (SAN) comprising: identifying managed objects for inclusion in a report, the managed objects responsive to a management application for performing actions in the SAN; determining tables in an online database containing attributes of the managed objects, the attributes reflective of the performed actions; computing relations between the determined tables, the relations associating tables of a particular type to other tables of another type based on attribute values, computing relations further comprising: traversing an object model corresponding to the tables in the online database; identifying relations between the tables; and identifying key fields including at least one attribute of a table; computing fields applicable to the report by traversing the computed relations; transforming the online database to an offline query database, the offline query database having a star schema of tables corresponding to facts and dimensions, the dimensions further including at least one of time, location, region, product and department; displaying a Graphical User Interface (GUI) for selecting managed objects according to mnemonic labels; receiving selections of managed objects from the GUI; mapping the selections to corresponding tables; generating a query operable to compute the report from the determined tables, the query having a scripted format adapted for interactive modification and customization; generating a mapping of the identified managed objects to mnemonic query labels, the mnemonic query labels for displaying, to a user via a GUI, selections of the managed objects in an intuitive manner, the intuitive manner indicative of the managed object; displaying the mnemonic query labels to a query user; and receiving a selection of the mnemonic query labels, the mnemonic query labels for mapping to tables in the offline query database.