Query View Menu

  • View - Toolbar
  • View - Status Bar
  • View - Graphic Mode
  • View - SQL and View - Cube/MDX (Beta)
    Beginning as a “beta” feature in STATISTICA version 10, queries against OLAP (Online Analytical Processing) “Cubes” are supported via a query language called MDX (Multi-Dimensional eXpressions). Queries against relational databases are expressed in SQL (Structured Query Language). The Query interface attempts to auto-detect the type of the database to which it is connected; these menu commands display the current mode (by the location of the check mark) and allow the user to switch between the modes. Note, however, that any given database connection will accept only one or the other query language.
  • View - Refresh Preview Data
    By default, Query automatically displays in the graphics pane a “preview” of the data that would be retrieved by the query that is under development. Because the preview process could be slow or even impossible (e.g., developing a query against a database schema that is not currently accessible), a command is provided to disable the automatic preview. If an error is encountered while attempting to generate a preview, the automatic preview feature may be switched off by STATISTICA as well.
  • View - More Preview Data
  • View - Automatically Preview Data
  • View - Suppress Blank MDX Data
    This command gives you control over whether to include empty categories in the result set of an MDX query. If for example you request total sales by salesman and product, the OLAP Cube will contain data only for those combinations of those two dimensions for which sales records exist in the underlying database. By default, MDX query syntax will return rows for all possible combinations (the Cartesian product of the two dimensions). This command inserts MDX syntax to suppress empty combinations.