OMS options

You can use the OMS Options dialog box to:

  • Specify the output format.
  • Specify the image format (for HTML and Output XML output formats).
  • Specify what table dimension elements should go into the row dimension.
  • Include a variable that identifies the sequential table number that is the source for each case (for IBM® SPSS® Statistics data file format).

Specifying OMS options

  1. From the menus choose:

    Utilities > OMS Control Panel...

  2. Click Options .


Excel 97-2004 and Excel 2007 and higher formats. Pivot table rows, columns, and cells are exported as Excel rows, columns, and cells, with all formatting attributes intact -- for example, cell borders, font styles, and background colors. Text output is exported with all font attributes intact. Each line in the text output is a row in the Excel file, with the entire contents of the line contained in a single cell. Charts, tree diagrams, and model views are included in PNG format.
Output objects that would be pivot tables in the Viewer are converted to HTML tables. Text output objects are tagged <PRE> in the HTML. Charts, tree diagrams, and model views are embedded in the document in the selected format.
Output XML
XML that conforms to the spss-output schema.
Output is exported as it would appear in Print Preview, with all formatting attributes intact. The PDF file includes bookmarks that correspond to the entries in the Viewer outline pane.
IBM SPSS Statistics Data File
This format is a binary file format. All output object types other than tables are excluded. Each column of a table becomes a variable in the data file. To use a data file that is created with OMS in the same session, you must end the active OMS request before you can open the data file.See the topic Routing output to IBM SPSS Statistics data files for more information.
Space-separated text. Output is written as text, with tabular output aligned with spaces for fixed-pitch fonts. Charts, tree diagrams, and model views are excluded.
Tabbed Text
Tab-delimited text. For output that is displayed as pivot tables in the Viewer, tabs delimit table column elements. Text block lines are written as is; no attempt is made to divide them with tabs at useful places. Charts, tree diagrams, and model views are excluded.
Viewer File
This is the same format used when you save the contents of a Viewer window.
Pivot tables and text are exported as Word XML (*.docx) with all formatting attributes intact (for example, cell borders, font styles, and background colors). Charts, tree diagrams, and model views are included as high-resolution images (*.eps for macOS and *.emf for Windows).

Graphics Images

For HTML and Output XML formats, you can include charts, tree diagrams, and model views as image files. A separate image file is created for each chart and/or tree.

  • For HTML document format, standard <IMG SRC='filename'> tags are included in the HTML document for each image file.
  • For Output XML document format, the XML file contains a chart element with an ImageFile attribute of the general form <chart imageFile="filepath/filename"/> for each image file.
  • Image files are saved in a separate subdirectory (folder). The subdirectory name is the name of the destination file, without any extension and with _files appended to the end. For example, if the destination file is julydata.htm, the images subdirectory will be named julydata_files.
The available image formats are PNG, JPG, and BMP.
You can scale the image size from 10% to 200%.
Include Imagemaps
For HTML document format, this option creates image map ToolTips that display information for some chart elements, such as the value of the selected point on a line chart or bar on a bar chart.

Table Pivots

For pivot table output, you can specify the dimension element(s) that should appear in the columns. All other dimension elements appear in the rows. For IBM SPSS Statistics data file format, table columns become variables, and rows become cases.

  • If you specify multiple dimension elements for the columns, they are nested in the columns in the order in which they are listed. For IBM SPSS Statistics data file format, variable names are constructed by nested column elements. See the topic Variable names in OMS-generated data files for more information.
  • If a table doesn't contain any of the listed dimension elements, all dimension elements for that table will appear in the rows.
  • Table pivots that are specified here have no effect on tables that are displayed in the Viewer.

Each dimension of a table--row, column, layer--may contain zero or more elements. For example, a simple two-dimensional crosstabulation contains a single row dimension element and a single column dimension element, each of which contains one of the variables that are used in the table. You can use either positional arguments or dimension element "names" to specify the dimension elements that you want to put into the column dimension.

All dimensions in rows
Creates a single row for each table. For IBM SPSS Statistics format data files, this means each table is a single case, and all the table elements are variables.
List of positions
The general form of a positional argument is a letter indicating the default position of the element--C for column, R for row, or L for layer--followed by a positive integer indicating the default position within that dimension. For example, R1 would indicate the outermost row dimension element.
  • To specify multiple elements from multiple dimensions, separate each dimension with a space—for example, R1 C2.
  • The dimension letter followed by ALL indicates all elements in that dimension in their default order. For example, CALL is the same as the default behavior (using all column elements in their default order to create columns).
  • CALL RALL LALL (or RALL CALL LALL, and so on) will put all dimension elements into the columns. For IBM SPSS Statistics data file format, this creates one row/case per table in the data file.
List of dimension names
As an alternative to positional arguments, you can use dimension element "names," which are the text labels that appear in the table. For example, a simple two-dimensional crosstabulation contains a single row dimension element and a single column dimension element, each with labels based on the variables in those dimensions, plus a single layer dimension element labeled Statistics (if English is the output language).
  • Dimension element names may vary, based on the output language and/or settings that affect the display of variable names and/or labels in tables.
  • Each dimension element name must be enclosed in single or double quotation marks. To specify multiple dimension element names, include a space between each quoted name.
The labels that are associated with the dimension elements may not always be obvious.

Viewing all dimension elements and their labels for a pivot table

  1. Activate (double-click) the table in the Viewer.
  2. From the menus choose:

    View > Show All


  3. If the pivoting trays aren't displayed, from the menus choose:

    Pivot > Pivoting Trays

The element labels are dispalyed in the pivoting trays.