11. A data processing device for processing report queries in a storage area network comprising: a decision support processor having a graphical user interface operable to identify managed objects for inclusion in a report, the managed objects responsive to a management application for performing actions in the SAN; query logic configured to determine tables in an online database containing attributes of the managed objects, the attributes reflective of the performed actions; and metadata employed for computing relations between the determined tables, relations logic configured to perform the following steps: 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, the relations associating tables of a particular type to other tables of another type based on attribute values, the query logic further operable to compute fields applicable to the report by traversing the computed relations; and 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, the metadata pertaining to a database other than the one from which the queried data is sought, the decision support processor further: displaying a GUI for selecting managed objects according to mnemonic labels, the managed objects responsive to a management application for performing actions in the SAN; receiving selections of managed objects from the GUI, the managed objects including storage arrays, connectivity devices, and hosts; mapping the selections to corresponding tables; and generating a query operable to compute the report from the determined tables, the query having a scripted format adapted for interactive modification and customization.
11. A data processing device for processing report queries in a storage area network comprising: a decision support processor having a graphical user interface operable to identify managed objects for inclusion in a report, the managed objects responsive to a management application for performing actions in the SAN; query logic configured to determine tables in an online database containing attributes of the managed objects, the attributes reflective of the performed actions; and metadata employed for computing relations between the determined tables, relations logic configured to perform the following steps: 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, the relations associating tables of a particular type to other tables of another type based on attribute values, the query logic further operable to compute fields applicable to the report by traversing the computed relations; and 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, the metadata pertaining to a database other than the one from which the queried data is sought, the decision support processor further: displaying a GUI for selecting managed objects according to mnemonic labels, the managed objects responsive to a management application for performing actions in the SAN; receiving selections of managed objects from the GUI, the managed objects including storage arrays, connectivity devices, and hosts; mapping the selections to corresponding tables; and generating a query operable to compute the report from the determined tables, the query having a scripted format adapted for interactive modification and customization. 12. The device of claim 11 wherein computing fields further comprises defining a join between applicable tables according to the identified relations.