Skip to main content
Skip table of contents

Output Formats - SuperCROSS

To save a table or chart, use the File > Save or File > Save As menu options. The following formats are available:

FormatDescription
SuperCROSS (.SCS)The native SuperCROSS project file format.
SuperTABLE Dissemination (.SCS)For use in SuperTABLE.
Tab-delimited Table (.TXT)A tab-delimited text file format representing the table structure.
Comma-separated Table (.CSV)

For import into programs like Excel.

The file will include:

  • One Record Per Tabular Value. A separate record for every non-zero cell with the row/column/wafer headers, and the data value.
  • Enumerated Axis Item Numbers. For example where instead of writing the full axis header, a column number beginning at 1 is written.
Lotus 1-2-3 (.WKS)For import into Lotus 1-2-3. Supports multiple sheets spanning multiple cells.
Tabular Macro-data (.CSV)Designed for loading multiple tables into data warehouses. SuperTABLE tables with tabular metadata can be saved in comma-separated format. Table macro-data can be dumped into a sparse comma-separated format with minimal metadata. The default textual format separator can be changed to a character other than the comma (this is controlled by the Microsoft Windows locale settings).
Tabular Meta-data (.TXT)The table metadata. This includes the database, table subject population, table fields, and structure of enumerated axes (blank items are used to indicate spanners, and space indentation are used to indicate the hierarchy).
Parameter Log (.TXT)

A textual description of the table and tabulation. Parameter logs can be used for manually checking how a table was created or for reference.

The output text file includes:

  • The number and name of fields used in each axis of the table,
  • The values included in recodes.
  • How both derivations and User Defined Files (UDFs) were created.
  • Table file name.
  • User Name.
  • Computer Name.
  • Server user name (if saved via the server).
  • Server application name (if saved via the server).
  • Tabulation start time.
  • Axis derivations.
  • Ranges for individually added items (if medium number). 
HTML - Single File (.HTM)

The entire table saved as a single HTML file. If there are multiple wafers in the table they are displayed one after the other on the page.

There are a number configuration options you can set for saving to HTML. See super.ini for more information.

HTML - Multiple Files (.HTM)

Each wafer is saved to its own individual HTML file.

There are a number configuration options you can set for saving to HTML. See super.ini for more information.

XML - Display Model (.XML)

An XML file format containing data elements and table metadata.

The XML file contains the following:

  • Spanner labels.
  • Groups.
  • Summation options.
  • Field and cell values.
  • Annotation data.
  • Field derivations.
  • Axis derivations.

These elements are tagged for identification. Table wafer data is generated as a separate section of the XML output. However, hierarchical levels are not tagged, and nesting of levels is not supported.

  • Tables must be tabulated prior to saving out to XML format.
  • The XML output files cannot be read by SuperWEB1, or generated by the SuperSERVER Production System software.
  • If you want to display the XML file in a web browser you will need to attach the SuperCROSS XSL style sheet (available in the SuperCROSS\XML Style Sheets directory located in the SuperCROSS Program Files directory).  
XML - Structural Model (.XML)

This is a structured model XML file.

  • Tables must be tabulated prior to saving out to XML format.
  • The table can not contain a Block Percent.
  • This format is only available for SXV4 databases.
XML - CALS Model (.XML)

This is a statistical table model that is based on the CALS table model.

  • Tables must be tabulated prior to saving out to XML format.
  • The table can not contain a Block Percent.
  • This format is only available for SXV4 databases.
Excel 95 or 2003 (.XLS) and Excel 2007 or 2010 (.XLSX)

For opening in Microsoft Excel.

  • By default the table header displays left justified.
  • The .xls file format (Excel 95/2003) is limited to 65.536 rows.  
  • The .xlsx file format (Excel 2007/2010) is limited to 16,384 columns and 1,048,576 rows.

If SuperCROSS is set up with multilingual metadata, you can use this option to export to Excel with table and field titles in two languages. Learn more.

There are a number configuration options you can set for saving to Excel. See super.ini for more information.

PC-Axis (.PX) and PC-Axis 2000 (.PX)

For use in the PCAxis and PC-Axis 2000 software.

  • The .PX file format can be saved as Production Utility output and as an output format when the application is operating in server mode.
  • All table cells are saved to the PC-Axis and PC-Axis 2000 format regardless of what is currently selected.
  • A maximum of two table axes can be saved to PC-Axis and PC-Axis 2000 file format.
  • Tables containing wafer fields are nested in the row axis.
  • Axis derivations are not saved.
  • Table meta information is available from the Footnote section of the PC-Axis/PC-Axis 2000 window.  
SuperCUBE (.SRD)

A 'Summary Record Database' for distributing to other users of SuperCROSS and SuperTABLE.

For more information about the SuperCUBE output format, see SuperCUBE.

Textual Table Definition (.TXD)

A textual description of a table. TXD files do not contain table data, they only describe the table structure. The TXD must be loaded back into an application like SuperCROSS to view the table it describes.

For a full description of the TXD format, see: TXD Reference

If you save a table containing an annex file in TXD format, the annex file is saved in the same folder as the TXD file, with a RTF file extension. A reference to the RTF file is made in the TXD file. If you move or copy the TXD file you must also move or copy the RTF associated RTF annex information file.

There are a number configuration options you can set for saving to TXD. See super.ini for more information.

SDMX Structure Definition (.xml)

The SDMX (Statistical Data and Metadata eXchange) Technical Standards Version 2.0 format.

This output format saves the structure definition only. 

Items that can be saved to the SDMX download file include:

  • Simple tables.
  • Totals.
  • Mathematical functions applied to summations.
  • Non-default summation options.
  • Percentages.
  • Cell annotations.
  • Field annotations.
  • DAG classification hierarchies.
  • Derivations.
  • User defined functions.
  • Table language set to another language.
  • Survey dates.
  • Recodes.

Items that are not saved to the SDMX download file include:

  • Hidden fields.
  • Axis derivations.
  • Grand totals.

SDMX output cannot be saved from tables with concatenated fields.

For more information on SDMX, see http://sdmx.org/ or SDMX - SuperCROSS.

SDMX Archive (.zip)

The SDMX (Statistical Data and Metadata eXchange) Technical Standards Version 2.0 format.

This output format creates a ZIP archive containing both the SDMX data set and the SDMX structure definition, both in XML format.

The limitations are the same as those of the Structure Definition listed above.

To save the entire table you must have either nothing highlighted/selected or the entire table highlighted/selected.

If SuperCROSS displays a progress bar during the save process, you can cancel the save at any time by pressing Esc.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.