This is the documentation for SuperSTAR 8

SuperSTAR 9.9 is now available.
View this page in the SuperSTAR 9.9 documentation or visit the SuperSTAR 9.9 documentation home.

Skip to end of metadata
Go to start of metadata

Space Index

0-9 ... 0 A ... 37 B ... 16 C ... 125 D ... 35 E ... 12
F ... 27 G ... 11 H ... 9 I ... 18 J ... 6 K ... 4
L ... 14 M ... 33 N ... 6 O ... 16 P ... 20 Q ... 4
R ... 40 S ... 78 T ... 24 U ... 21 V ... 7 W ... 11
X ... 1 Y ... 1 Z ... 1 !@#$ ... 0    

0-9

A

Page: A
Page: account
This command allows you to create and manage users and groups. The account command is for managing local user accounts. As an alternative to managing a set of local user accounts in SuperADMIN, you can connect SuperSTAR to an external authentication servi
Page: Active Directory
Active Directory is an implementation of LDAP directory services by Microsoft for use in the Windows environments. Active Directory allows administrators to assign enterprise-wide policies, deploy programs to many computers, and apply critical updates to
Page: Active Directory and LDAP
This section describes how to configure SuperSTAR to authenticate users against an LDAP directory. LDAP (Lightweight Directory Access Protocol) is a very commonly used interface to user or account information. A very popular variant of LDAP is Microsoft A
Page: active table
A table that has been selected or built in SuperCROSS, SuperTABLE, or SuperWEB2.
Page: Add a Blank Row or Column to a Table - SuperCROSS
To make your table more readable, you can add spacing by using blank rows and columns. The blank rows and columns can either be completely blank rows/columns, or they can have headings. For example, you could use blank rows to group values in your table a
Page: Add a New Language - Metadata
Suppose you have followed the instructions and set up metadata already and now want to add an additional language to your deployment. Do not re-run the metadata configuration scripts, as this will replace your existing populated metadata database. To add
Page: Add a User Interface Language - SuperWEB2
To add a new user interface language to SuperWEB2, you need to create a resource bundle. This is a set of properties files saved in <tomcat_home>\webapps\webapi\WEB-INF\classes. For example, the file messages.properties contains values for various strings
Page: Add Databases and Tables - SuperWEB2
When a user logs in, SuperWEB2 displays the Data Catalogue, where they can select the database or table they want to work with: SuperWEB2-DB-Catalogue.png Users can select the data they want to work with from the list on the left. This list includes: All
Page: Add External Axis Item - SuperCROSS
You can import external data into a row, column or wafer axis. Table data can be imported into a maximum of two axis fields (e.g. columns and rows or columns and wafers). You have two options for importing external data: you can enter the data manually in
Page: Add H2 JDBC Driver to SuperCHANNEL
JDBC Drivers - SuperCHANNEL H2 H2 is a relational database management system http://en.wikipedia.org/wiki/Relational_database_management_system (RDBMS) written in Java http://en.wikipedia.org/wiki/Java_(programming_language). It is open source and can be
Page: Add MySQL JDBC Drivers to SuperCHANNEL
JDBC Drivers - SuperCHANNEL MySQL If your source data is stored in a MySQL database, then you need to configure SuperCHANNEL to use the MySQL JDBC driver. Step 1 - Download and Install the Driver The MySQL jdbc driver is called Connector/J. Download the l
Page: Add Oracle JDBC Drivers to SuperCHANNEL
JDBC Drivers - SuperCHANNEL Oracle If your source data is stored in an Oracle database, then you need to configure SuperCHANNEL to use an appropriate JDBC driver. Space-Time Research recommends version 11.1.0.6.0. This is backwards compatible with 10.2.x,
Page: Add PostgreSQL JDBC Drivers to SuperCHANNEL
JDBC Drivers - SuperCHANNEL PostgreSQL If your source data is stored in a PostgreSQL database, then you need to configure SuperCHANNEL to use the PostgreSQL JDBC driver. Step 1 - Download and Install the Driver Download the latest version of the driver fr
Page: Add SQL Server jTDS JDBC Driver to SuperCHANNEL
JDBC Drivers - SuperCHANNEL Microsoft SQL Server If your source data is stored in a Microsoft SQL Server database, then you need to configure SuperCHANNEL to use the jTDS JDBC driver. jTDS is an open source 100% pure Java (type 4) JDBC 3.0 driver for Micr
Page: Add SQL Server Microsoft JDBC Driver to SuperCHANNEL
JDBC Drivers - SuperCHANNEL Microsoft SQL Server If your source data is stored in a Microsoft SQL Server database, then you can configure SuperCHANNEL to use the Microsoft JDBC Driver for SQL Server. This driver is a pure Java (type 4) JDBC 4.0 driver for
Page: Add Sybase jTDS JDBC Driver to SuperCHANNEL
JDBC Drivers - SuperCHANNEL Sybase If your source data is stored in a Sybase database, then you need to configure SuperCHANNEL to use the jTDS JDBC driver. jTDS is an open source 100% pure Java (type 4) JDBC 3.0 driver for Microsoft SQL Server (6.5, 7, 20
Page: Add Teradata JDBC Drivers to SuperCHANNEL
JDBC Drivers - SuperCHANNEL Teradata If your source data is stored in a Teradata database, then you need to configure SuperCHANNEL to use the Teradata JDBC driver. Step 1 - Download and Install the Driver Download the latest version of the Teradata JDBC d
Page: Advanced Configuration - Job Queue Manager
This section describes some advanced configuration adjustments you may want to make to Job Queue Manager. You should install Job Queue Manager and confirm that the basic functionality is working before making any of these changes. Job Expiry and Removal B
Page: aggregated data
See summary data.
Page: annotation
Additional information associated with a table or chart. For example, a symbol in a cell to denote a special condition (such as Not Available). There are two parts to an annotation: a symbol in the cell and a footnote text for the symbol.
Page: Annotation Repository Schema - Data Control API
The annotation repository schema supports the following functions: Add/delete an annotation Update an annotation's symbol Update an annotation's description Enforce the uniqueness of annotation symbols Add/delete database assignments Add/delete field assi
Page: Annotations - Charts - SuperCROSS
You can add annotations to charts to highlight something or describe or draw attention to something on the chart: Chart-Example.png To add an annotation, select one of the options on the Annotations menu or the toolbar: Option Icon Select To... How to Add
Page: Annotations - Data Control API
The annotation functionality lets you create annotations and assign them to values in the table. Annotations can be assigned to various table components such as databases, fields, field values, and data cells (cross section of two or more field values). A
Page: Annotations - SuperCROSS
You can add annotations to cells, fields, and the table header. For example, you can use them to add notes, explain the recodes used or provide information about certain cell values within the table. The annotations appear at the bottom of the table with
Page: Annotations - SuperSERVER
The annotation functionality built in to SuperSERVER lets you provide additional information that will be displayed when particular fields and values appear in a table. Space-Time Research recommends no more than 100,000 annotations on any particular tabl
Page: Annotations Sample Code - Data Control API
The etc\annotation directory (C:\ProgramData\STR\SuperSERVER SA\etc\annotation) contains sample code for the annotations: etc\annotation\Financial.sxv4.sqlite.db etc\annotation\README.txt etc\annotation\financial.sql etc\annotation\schema.sql The annotati
Page: Application Programming Interface (API)
A programmatic interface into a software application. An API allows developers to write their own applications that interact with the software.
Page: attributes
The properties of objects, elements, or files. These usually consist of a name and value.
Page: auth, authentication
This command controls user authentication. Use it to configure an external authentication service, such as LDAP or Active Directory. auth and authentication are the same command and can be used interchangeably. Overview By default, SuperSTAR is configured
Page: Automatically Expand the Fields when Selecting All - SuperWEB2
By default, when you use the Select all at level option in SuperWEB2, the field does not automatically expand to show the selected values: SuperWEB2-Select-All-At-Level-Does-Not-Auto-Expand.png To view the selected values, you have to manually expand the
Page: Automation and SuperADMIN
SuperADMIN includes macro functionality. You can use this to automate repetitive tasks. Creating a Macro File There are two options: Use the macro command in SuperADMIN to record a series of commands to a macro file. Create the macro file in a text editor
Page: axis
One of three dimensions in a SuperCROSS or SuperWEB2 table (row, column, and wafer/layer).
Page: axis derivation
An axis derivation is an arithmetic expression that can use axis items from a specific axis in a table as variables. Axis derivations could be percentages, sums, subtotals and other such expressions. An axis derivation differs from a field derivation beca
Page: axis item
An axis item is an individual row, column, or wafer item not necessarily related to a specific field. For example, a row representing males aged 50 could be an axis item.
Page: axis reference item
Any axis item can be manually set as the axis reference item. You can have multiple axis reference items in a table, but only one per axis (row, column, or wafer). By default, the axis reference item will be either the first or last in the list depending
Page: AxisMapEntry
SuperCROSS Production System SuperWEB1 SuperWEB2 Element Format Description Save Load Load Save Load Save Load AxisMapEntry AxisMapEntryDefine AxisMapBody AxisMapEnd AxisMap is ignored if the axis is in large axis mode. AxisMapDefine 'AXIS

B

Page: B
Page: Backup Strategy - SuperSTAR
This section describes the components of SuperSTAR that should be backed up as part of a normal backup process. SuperSTAR Components Component Backup... Default Installation Location SuperSERVER The SuperSERVER Program Data directory. C:\ProgramData\STR S
Page: Batch Convert SXV3 Databases - SuperCHANNEL
SXV3 is an old SuperSTAR database file format. This format is now deprecated. If you have old databases in SXV3 format, you can use SuperCHANNEL to convert them to the current SXV4 format. You can either do this for each database individually, or use the
Page: Batch Insert Mode - SuperCHANNEL
SuperCHANNEL has two modes it can use to insert records from the source database into the target: Batch mode - records are inserted in groups. worddavc0672e1e10139f5130c3832c073d404d.png Classic mode - records are inserted one at a time. worddav51db5b94b4
Page: BINS - Registry Table
Cleansing actions allow you to clean up some of your source data when building your SXV4 database. Cleansing actions only apply to fields that are supposed to be one of a set of possible values; they control what SuperCHANNEL should do when it encounters
Page: bivariate statistic
A numerical value that indicates the relationship between two individual variables.
Page: BlockPercentEntry
SuperCROSS Production System SuperWEB1 SuperWEB2 Element Format Description Save Load Load Save Load Save Load BlockPercentEntry BlockPercentEntryDefine BlockPercentBody BlockPercentTotalEnd BlockPercentEntryDefine 'BLOCKPERCENT' Yes Y
Page: branched hierarchy
A branched hierarchy presents multiple paths that can be taken to drill down to the bottom level in the hierarchy. For example the layers in a hierarchy can be displayed in the following layer combinations where suburb is the bottom level in the hierarchy
Page: Branding - SuperWEB2
After installation, SuperWEB2 is configured with default Space-Time Research headers, footers, and data catalogue pages. You can apply your own branding to SuperWEB2. The items you can modify include: Logo Header and footer Login screen text Welcome scree
Page: Branding Downloaded Files - SuperWEB2
SuperWEB2 allows users to download data in various formats, including Excel, CSV, PNG and PDF. Each download format has a template file, which you can brand to suit your corporate style:
Page: Branding Excel and CSV Templates - SuperWEB2
SuperWEB2 users can download data from Table View in a variety of formats: SW2-Table-View-Downloads.png The templates for Excel and CSV downloads are located in <tomcat_home>\webapps\webapi\WEB-INF\templates: File Used For Template.csv CSV downloads from
Page: Branding KMZ Downloads - SuperWEB2
Users can download KMZ format files from Map View. This file format can be loaded into mapping applications such as Google Earth. By default, SuperWEB2 will include the table name in the file (this will appear in the layer list in Google Earth) and a lege
Page: Branding PDF Downloads - SuperWEB2
Users can download PDFs from Graph View and Map View. SuperWEB2 is supplied with a default template for the downloads, but you can replace this with your own version. You can also create separate PDF templates for graph and map downloads. In order to chan
Page: Branding PNG Downloads - SuperWEB2
Users can also download a graph as a PNG image. You can make some changes to this format by editing one of the SuperWEB2 template files. Open the file <tomcat_home>\webapps\webapi\graphViewTab.jsp in a text editor. Locate the following section of the file
Page: Branding SDMX Downloads - SuperWEB2
SuperWEB2 users can download data from Table View in a variety of formats, including SDMX (Statistical Data and Metadata eXchange) Version 2.0: SW2-Table-View-Downloads.png The two available SDMX options are: An archive (.zip) file containing the SDMX dat
Page: Build Logs - SuperCHANNEL
When you build the target database, SuperCHANNEL logs information about the build progress. If you run the build in the SuperCHANNEL GUI, the log information is displayed in the Build Logs pane. When you run a build from the command line (using the SNU ut

C

Page: C
Page: CALS table model
This is a Document Type Definition (DTD) standard representing tables in SGML/XML. For more information, see: http://en.wikipedia.org/wiki/CALS_Table_Model http://en.wikipedia.org/wiki/CALS_Table_Model
Page: cat
Use this command to configure the catalogue; the collection of folders, databases, tables and recodes available to SuperSERVER. Item Description Folder Similar to a folder in a filesystem, you can use folders to organise the items in the catalogue and gro
Page: catalogue
A database catalogue is a collection of folders, databases, tables, cubes and recodes.
Page: cell
A table cell contains the count or sum of a tabulation at the intersection of the axes in a table. A table always has one or more cells.
Page: cell key
A cell key is used as part of the perturbation confidentialisation process. It is the result of combining rkeys of all records that contribute to a specific cell. These cell keys are then used to look up an offset in a special table. The server adds the o
Page: Cells with No Contributors - Job Queue Manager
If you have modified the SuperWEB2 settings that determine what happens if a table cell has no records contributing to the result, then you must apply the same changes to Job Queue Manager. The settings for SuperWEB2 are configured in <tomcat_home>\webapp
Page: Change Default Summation Option - SuperWEB2
In SuperWEB2 you must have at least one summation option in the table at all times. When you first add a field to the table, SuperWEB2 automatically adds a summation option. For example, for the Retail Banking database, the default summation option is a c
Page: Change the Size of the Guest Login text - SuperWEB2
It is possible to customise the Guest log in text that appears on the SuperWEB2 login screen: SW2-Default-Guest-Login.png Some changes you might want to make include: changing the size of the text, modifying the colour, and making it bold. To make this ch
Page: Change the Strings used to Represent Calculations with No Result - SuperCROSS
If your tables use derivations to calculate some of the table cell values, then you may end up with cells that cannot be calculated. For example, the following table contains a derivation that calculates the ratio of Savings accounts to Savings Pensioner
Page: Change the Support Email Address - SuperCROSS
The SuperCROSS Help menu has an option to E-mail Support: SX-Email-Support.png By default, this menu option opens a new email message so that the user can contact support, with the To address of the email set to support@spacetimeresearch.com mailto:suppor
Page: Change the Supported User Interface Languages - SuperWEB2
The list of supported languages for SuperWEB2 is defined in <tomcat_home>\webapps\webapi\WEB-INF\faces-config.xml. To change the default and supported languages, edit the following section: <locale-config> <default-locale>en</default-locale> <supported-lo
Page: Change the User Interface Language - SuperWEB2
SuperWEB2 supports multiple languages for the user interface. If SuperWEB2 is not being displayed in your preferred language, then you may be able to change this by adjusting your web browser settings. You can only change to a language that SuperWEB2 has
Page: channel
In SuperSTAR this is a term used to describe the process of moving data into an SXV4 database from an external source, by use of the SuperCHANNEL application.
Page: Channel from Multiple Source Databases - SuperCHANNEL
SuperCHANNEL can only connect to a single database at a time. However, if you need to connect to multiple source databases to build your SuperSTAR database, you can do this by connecting to them one after the other and incrementally updating the target da
Page: Channelling on non-Microsoft Platforms - SNU
The SNU command line utility is a Java application. It therefore makes it possible to build target databases on non-Microsoft Windows platforms, such as Solaris and Linux. The SuperCHANNEL GUI application is only available on Windows, so you will still ne
Page: Channelling Without a Project File - SNU
If your source data has been prepared properly, it is possible to build your target database using SNU on the command line without a project file (i.e. without using the SuperCHANNEL GUI to design your database). Channelling without a project file is only
Page: Chart Explorer - Charts - SuperCROSS
Select Chart > Chart Explorer to open the Chart Explorer where you can change the components that make up the chart. Chart-Explorer.png Double-click a component in the list to edit the component properties.
Page: Chart Wizard - Charts - SuperCROSS
Select Chart > Chart Wizard to open the Chart Wizard, where you can dynamically edit the chart. Chart-Wizard.png The following settings are available: General Tab Element Description Change Setting Select a component within the chart to edit. A component
Page: Charts - SuperCROSS
SuperCROSS has built in charting functionality that allows you to easily create charts of your data with just a few clicks of the mouse. To create a chart: Create a table. Select the rows/columns you are interested in (or select all cells if you want to c
Page: Check and Reset Field Level Security Settings
How Do I Check the Current Field Level Security Settings? The following examples show how you can check the current Field Level Security settings configured on the database. Check If Field Level Security Is In Use To find out if a database has any Field L
Page: Classification Editor - SuperCHANNEL
The Classification Editor allows you to modify the display values for classification items after a SuperSTAR database has been built. This can be convenient if the database is big and takes a long time to build. The editor cannot be used during the design
Page: classification table
In SuperCHANNEL this is a table containing a discrete set of values used to define all possible results for a column. Classification tables are also referred to as value sets or dimensions.
Page: CLASSIFICATIONS - Registry Table
Use the CLASSIFICATIONS registry table to specify which tables are classification tables, and which columns in those tables represent the code and the name. A table cannot be both a fact table and a classification. If the same table is incorrectly specifi
Page: CLEANSING_RULES - Registry Table
Cleansing actions allow you to automatically clean up some of your source data when building your SXV4 database. Cleansing actions apply to columns that can only be one of a set of possible values. This includes: Classified columns - columns in fact table
Page: cohorts
Statistical term for a group of observations sharing a common factor. For example, people of the same age or the same income bracket.
Page: ColourVIEW - SuperCROSS
ColourVIEW uses colour to highlight potential relationships between table variables and help you identify ranges and patterns. This can provide an easier way of interpreting table results and help you understand their significance. It can be particularly
Page: column
In a database: a set of data values, one for each database row. In a table: a vertical list of values displayed in a table.
Page: COLUMN_LABEL - Registry Table
Use the COLUMN_LABEL registry table to specify a display names for a table column. By default a column will take its name for the source column, but you can use this registry table to change that. Only fact table column names are displayed to end users in
Page: ColumnEntry
SuperCROSS Production System SuperWEB1 SuperWEB2 Element Format Description Save Load Load Save Load Save Load ColumnEntry ColumnEntryDefine ColumnBody ColumnEnd ColumnEntryDefine 'COLUMN' Yes Yes Yes Yes Yes Yes Yes ColumnBody ColumnB
Page: Command Line Options - SNU
If you installed to the default location, SNU will be located in C:\ProgramData\STR\SuperCHANNEL\bin To run SNU, open a command prompt and change to this directory, then use the following command: snu <options> <project> Replace <options> with one or more
Page: Command Line Options - SuperCROSS
You can start SuperCROSS from the command line, as follows: super.exe {-c | -l | -s | -f | -d} [WorkGroupName] [-n] "database" [-crossPath "<path_location>"] [-configFilesPath "<path_location>"] [-superPath "<path_location>"] Where: Option Description -c
Page: Command Line Options - SuperSERVICE Manager
You can run SuperSERVICE Manager from the Windows command line, and use it to create and remove services. The following sections list the valid command line options. If you use an option that is not valid, all the command line options will be ignored and
Page: Command Reference - SuperADMIN
This section describes the main commands you will need to use in the SuperADMIN Console. Command Syntax The following command syntax is used throughout these instructions: Element Description { } Indicates a set of possible choices. | Separates two mutual
Page: commit points
In SuperCHANNEL, the number of records channelled before changes are written (committed) to the target database.
Page: Common Metadata Inferface (ComeIn)
This interface defines the functionality for mapping conceptual models to any type of metadata base. A specific ComeIn implementation is the BridgeNA-ComeIn interface that maps the conceptual metadata modules built by different statistical offices. ComeIn
Page: Compression - Job Queue Manager
When Job Queue Manager writes the table output result to the database, it compresses the data. By default, the compression level is set to level 5, which is a compromise between size and speed. You can change this setting: Setting a value lower than 5 inc
Page: concatenate
Two fields can be concatenated (merged) into one axis without sub-nesting. For example, a table could show nationality across the columns, and gender then religion down the rows. All values of gender are listed first, then all values of religion. In Super
Page: Concealment - Job Queue Manager
If you have configured the concealment settings for SuperWEB2, then you need to apply the same configuration adjustments to Job Queue Manager. The concealment settings for SuperWEB2 are defined in <tomcat_home>\webapps\webapi\WEB-INF\data\.repository\Cube
Page: Confidentialised Unit Record Files (CURF)
Confidentialised Unit Record Files are unit record data that has been modified to protect the confidentiality of respondents while also maintaining the integrity of the data. These files are produced by Statistical Agencies.
Page: confidentiality
The process of ensuring that confidential information is not revealed, and cannot be discovered by systematic cross-tabulation. SuperSTAR supports a number of techniques used to disclose information. See also Statistical Disclosure Control.
Page: Confidentiality - SuperCROSS
The confidentiality feature is used to hide or disguise sensitive or confidential data. There are two types of confidentiality: Server-side confidentiality is applied by SuperSERVER during cross tabulation. Cell values that do not meet the con­fidentialit
Page: confidentiality levels
In SuperCROSS this lets you specify the level on which the confidentiality rule is being applied. The levels available are defined in the database hierarchy. When the application calculates the number of contributors for a cell it has to know the level to
Page: Confidentiality Plugin Overview
The supplied Data Control confidentiality plugin offers two techniques for applying confidentiality to cell values: Rounding - Values that meet certain criteria (typically very small values) are randomly rounded up or down to a different value. Cell Suppr
Page: confidentiality rules
Rules that are applied to disguise potentially confidential data in a table.
Page: config.txt
This file contains various SuperCHANNEL preferences. The location of config.txt will depend on where you installed SuperCHANNEL. By default, it is located in C:\ProgramData\STR\SuperCHANNEL\bin. Within the file: Lines prefixed by the '#' character are com
Page: Configuration Files - SuperCHANNEL
You can change some of the SuperCHANNEL settings by editing the configuration files. In most cases you will not need to make changes to the default configuration (apart from modifying config.txt to include the JDBC drivers for connecting to your RDBMS). T
Page: Configuration Files - SuperCROSS
This section describes the SuperCROSS configuration files. You can use these files to configure the default SuperCROSS settings. SuperCROSS has many default settings that you can change. There are two ways to configure these settings: Using the Options wi
Page: Configuration Files - SuperWEB2
This section describes some of the main SuperWEB2 configuration files. Location File Description <tomcat_home>\webapps\webapi\WEB-INF\data\.repository\ administrationServerCatalog.xml Contains the settings for connecting SuperWEB2 to SuperADMIN. You will
Page: Configuration Guide - SuperCROSS
This section describes some of the configuration adjustments you might want to make to SuperCROSS.
Page: Configuration Guide - SuperWEB2
This section is aimed at SuperWEB2 system administrators. It contains information about the different ways to configure SuperWEB2. Branding You can apply your own branding to the SuperWEB2 interface. Learn more about what you can configure and how to make
Page: Configuration Reference - SuperCROSS
This section contains reference information for SuperCROSS configuration:
Page: Configure - Job Queue Manager
This section describes how to configure Job Queue Manager. Before you start to follow these steps, make sure you have followed the instructions to install Job Queue Manager. Step 1 - Configure SuperWEB2 to use an RDBMS for the User Data Repository If you
Page: Configure - User Data Repository
These instructions explain how to set up the User Data Repository to use a relational database such as MySQL, Oracle or SQL Server. Before starting, make sure you have installed SuperWEB2 and verified that it is working correctly. Step 1 - Create the User
Page: Configure Couchbase Memory Persistent Cache - SuperWEB2
To use the Couchbase Memory Persistent Cache strategy with SuperWEB2 you need to complete the following steps: Step 1 - Download and Install Couchbase Download Couchbase Community Edition 1.8.0 from http://www.couchbase.com/download http://www.couchbase.c
Page: Configure Display of Annotations - SuperWEB2
SuperWEB2 will display any annotations that have been configured for the database (learn more about how to set up and configure annotations in SuperSERVER): SW2-Annotations-Display.png There are a number of configuration options you can change that contro
Page: Configure Field Drop-down Labels - SuperWEB2
When you are selecting fields to add to a table, if you click the arrow to the right of a field, SuperWEB2 displays a drop-down box that allows you to quickly select all values from that field at a particular level in the hierarchy. For example, here the
Page: Configure Field Exclusion Rules - SuperWEB2
You can use the field exclusion rules to limit the number of fields from a defined group that can be added to the table at any one time. This feature is typically used to restrict the number of sub-state geographies that can be added into a table at the o
Page: Configure Field Level Security
Field Level Security (FLS) allows you to control access to specific fields, summation options, values and value sets on a per-user or per-group basis. Before you start configuring permissions, make sure you understand the Permissions Model - Inheritance a
Page: Configure Guest Access - SuperWEB2
You may wish to allow users to access SuperWEB2 without logging in (referred to as guest access). When guest access is enabled, users can access SuperWEB2 by clicking the guest login link on the login screen, or by visiting a special URL that bypasses the
Page: Configure Least Recently Used Memory Cache - SuperWEB2
To use the Least Recently Used Memory Cache strategy with SuperWEB2 you need to configure the following parameters in the web.xml configuration file. This file is located in <tomcat_home>\webapps\webapi\WEB-INF\ Parameter Configures Available Options Defa
Page: Configure Mandatory Fields - SuperWEB2
It is possible to configure certain fields as "mandatory fields" in SuperWEB2. These fields will be automatically added to all new tables. By default, users will be able to remove these fields from the table, but you can also activate a rule to prevent th
Page: Configure Metadata - SuperCROSS
Metadata is extra information about columns and fields that is stored in the database. This can include alternate names for fields, extra descriptions, and alternative languages (multilingual support). This section shows a worked example of one way to set
Page: Configure ODBC Driver to SQL Server
This section explains how to create an ODBC data source that allows Metadata Server (mdcorbaserver) to connect to a metadata database stored in SQL Server. Go to the Windows Control Panel and select System and Security > Administrative Tools > Data Source
Page: Configure Quantiles and Ranges - SuperWEB2
The Range button in SuperWEB2 allows users to create custom ranges: SW2-Summation-Options-Add-Range.png There are several aspects of this feature that you can configure. Configure Limits for Ranges You can set minimum and maximum limits for ranges, as wel
Page: Configure Query Caching - SuperWEB2
Query caching is designed to give a performance boost to SuperWEB2 by caching query results. This means that if the same table is created/tabulated more than once, the tabulation result can be obtained from the cache instead of using SuperSERVER to perfor
Page: Configure Record View Permissions
The Record View feature allows users of the clients (such as SuperWEB2 and SuperCROSS) to view the individual unit record data that contributes to a cell. Use the cat command to control which users and groups have access to the Record View feature. To giv
Page: Configure Relative Standard Error - SuperWEB2
The Relative Standard Error (RSE) function lets users view the relative standard error figures for weighted databases. This information is only available if: The database is weighted. The SuperSERVER has been configured to support the RSE feature. Learn h
Page: Configure Settings for Concealment and Cells with No Contributors - SuperWEB2
Concealment Concealment of data in SuperSTAR is achieved via the Data Control API. If a Data Control API module has been configured for a certain database, it may flag certain data values as being "concealed". Data values flagged as concealed will be disp
Page: Configure Settings for Large Tables - SuperWEB2
SuperWEB2 will automatically switch to large table mode if a user attempts to create a table containing more than a certain number of cells. By default, the threshold for large table mode is set at 8,000 cells, but you can change this setting. SuperWEB2 a
Page: Configure the Confidentiality Plugin
SuperSTAR is supplied with a Data Control plugin for confidentiality. You can use this plugin to apply random rounding of values and cell suppression to your databases. To configure the confidentiality plugin, you need to use the method command in SuperAD
Page: Configure the Connection to SuperSERVER - SuperWEB2
In a standard installation, the Tomcat server running SuperWEB2 is installed on the same machine as the machine running SuperSERVER. If you want to install Tomcat/SuperWEB2 on a different machine to SuperSERVER, you need to configure the connection betwee
Page: Configure the Console - SuperADMIN
The SuperADMIN console is the command-line application used to administer SuperSERVER. This section includes some tips for changing the console properties to make it easier to work with. Configure the SuperADMIN Console to Run as Administrator In order to
Page: Configure the Data Source and "You can customise..." Footnotes - SuperWEB2
SuperWEB2 can be configured to display 'footnote' text at the bottom of each table: worddav37365e82c4c41dc49bc18d61e0bb6f2b.png You can configure the text that is shown here, or remove it entirely. Configure the Data Source Text The first footnote line is
Page: Configure the Database Catalogue
Use the SuperADMIN command cat to manage the database catalogue. With the cat command you can add the following Databases Folders Tables Recode groups. Once you have created the catalogue, you can also use the cat command to configure user access permiss
Page: Configure the Fuzz Factor - SuperCROSS
Computers use binary representation (such as 0 and 1) to represent numbers. Therefore computers have a finite number of bits to represent numbers and cannot represent all the decimal numbers accu­rately. This is known as a representation error, and can le
Page: Configure the Text on the Data Catalogue Page - SuperWEB2
The Data Catalogue page is displayed when you first login to SuperWEB2. It shows a list of available databases and tables on the left, and some information about the databases and tables on the right: SW2-Data-Catalogue-Page.png The text shown on the righ
Page: Configure Timezone and Date Display - Job Queue Manager
Timezone By default, the Job Queue Manager times shown in SuperWEB2 (such as the time a job was submitted and the job expiry time) are in UTC/GMT: times-in-GMT.png To change the timezone to your local timezone: Go to the Tomcat instance that is running Su
Page: Configure User Permissions
Once you have created some user accounts, you need to give those users permission to access databases. Typically, you will find it easiest to manage permissions by adding users to groups and then giving those groups the appropriate permissions, rather tha
Page: Connect CSV and TXT Text Sources to SuperCHANNEL
SuperCHANNEL can read data from a text file, by using the Microsoft ODBC Text Driver through the jdbc:odbc bridge. Connecting to Excel - SuperCHANNEL Step 1 - Prepare the Text Source File The first step is to prepare your text source file(s) as follows:
Page: Connect to SuperSTAR Database Server - SuperCROSS
In order to open a database from a SuperSERVER, you need to configure the connection to the SuperSTAR database server in SuperCROSS. If your SuperSERVER connection is not configured, then the Catalogue - Select Database or Table window will only show opti
Page: Connecting to Access - SuperCHANNEL
SuperCHANNEL can read data from Microsoft Access through the jdbc:odbc bridge. Connecting to Excel - SuperCHANNEL Create an ODBC Data Connection In order to connect to Access you need to create an ODBC data connection. If you have not already installed th
Page: Connecting to Excel - SuperCHANNEL
SuperCHANNEL can read data from Microsoft Excel through the jdbc:odbc bridge. Limitations of the jdbc:odbc Bridge There are a number of limitations when using the jdbc:odbc bridge: It cannot recognize table joins. You will have to construct table referenc
Page: Connecting to Source and Target Databases - SuperCHANNEL
In order to use the SuperCHANNEL GUI to design and build your database, you need to connect to the source and target databases. Typically, the source database will be a relational database system and the target will be the Space-Time Research proprietary
Page: Connecting to SXV2 and SXV3 Data Sources - SuperCHANNEL
SXV2 and SXV3 are old SuperSTAR database file formats. These formats are now deprecated. If you have old databases in the SXV2 and SXV3 formats, you can use SuperCHANNEL to convert them to the current SXV4 format. To do this, you connect to the SXV2 or SX
Page: Connecting to TDD Data Sources - SuperCHANNEL
Space-Time Research's Textual Data Definition (TDD) standard allows you to create an SXV4 database based on data stored in text files, as an alternative to connecting to a relational database. This can be useful in situations where data is not available i
Page: connection
This command configures the settings used to connect to the administration domain. Usage Description connection Displays information about the connection to SuperADMIN. connection domain Displays the connection settings for the active SuperSTAR domain. co
Page: consequential suppression
The process of suppressing information which, whilst not necessarily confidential, may be used to allow imputation of confidential data. In conjunction with the Tau-ARGUS software, SuperCROSS can automate this task.
Page: console
This command controls the SuperADMIN display output and sets scripting options. Usage Description console off Turns off output in the SuperADMIN console. Commands you issue will continue to be executed, but the output from those commands will not be displ
Page: Control Which Fields can be Added to or Removed from Tables - SuperWEB2
There are a number of options you can configure to control what fields can be added to or removed from a table. Field Exclusion Rules You can use the field exclusion rules to limit the number of fields from a defined group that can be added to the table a
Page: Converting SAV and POR Files - SuperCHANNEL
The SPSS driver supplied with SuperCHANNEL can read the SPSS query language (.sps), but not the native formats (such as .sav and .por). Some tools can export directory to .sps, but if this is not the case you will need to convert the data to the SPSS comm
Page: Copy a Group - SuperWEB2
To copy a custom group you have created: Select the My Custom Data tab. SW2-Edit-CustomData-1.png In the My Custom Data and Geography section, select the check box next to the group you want to copy. SW2-Edit-CustomData-2.png Click Copy. SW2-Copy-CustomDa
Page: Copy and Drag Data Between Tables - SuperCROSS
You can copy and paste fields from one table to another and drag and drop data into another table. The tables must have at least one common axis (the field names must match, although case differences are acceptable). You can also copy and paste to an exte
Page: count of records
Count of records is the number of records in the database that match a given set of conditions, for example Male and Single. In the Retail Banking database you can count customers or accounts. Also known as Counts.
Page: COUNT_DEFAULT - Registry Table
Use the COUNT_DEFAULT registry table to define the default summation for a database. All SuperSTAR databases must have exactly one default summation defined. You can either set the default summation to be a count of the number of records in a given fact t
Page: Create a Comparison Field - SuperCROSS
A comparison field compares two existing fields. It creates three field values: Field A is less than Field B Field A is equal to Field B Field A is greater than Field B The fields being compared must be at the same hierarchical level. For example, if you
Page: Create a Custom Group - SuperWEB2
You can use the My Custom Data tab to create your own custom groups of values, which you can then use in a table. To create a custom group: Select the My Custom Data tab. SW2-MyCustomData.png In the section on the left, select the field values you want to
Page: Create a Derivation - SuperCROSS
To create a field or axis derivation: Right-click the field or axis where you want to add the derivation and select either Derivations > Add Field Derivation or Derivations > Add Axis Derivation (depending on whether you want to create a field or axis der
Page: Create a Group using the Map - SuperWEB2
If your data includes geographic fields, you can create groups using the map. For example, you can use the map to create a group for the Area field in the sample Retail Banking database: Select the My Custom Data tab. Click Use Map to Group Items. SW2-Cus
Page: Create a Math Field - SuperCROSS
A math field is a mathematical operation involving measures or other user defined fields. To create a math field: Select Cross > Define Field. The Define Fields window displays. Click Math. The Math Field window displays. SX-Math-Field.png Enter the follo
Page: Create a Multiple Level Field - SuperCROSS
A multiple level field is based on the relationship between tables. There are three options: Type Description Count Counts records in a table that are associated with a specific field in another table. For example, the number of accounts per customer. You
Page: Create a Quantile Field - SuperCROSS
A quantile field is similar to a range field, except that it is used to create a user-specified number of equally distributed ranges. These can be based on a field other than the one whose values are calculated. You can also apply a condition to restrict
Page: Create a Range Field - SuperCROSS
A range field consists of one or more custom ranges (for example "Account Balance < $500", "Account Balance $500 - $1000", "Account Balance > $1000"). You can define the range using fields that are measures, numerical or date/time fields. To create a quan
Page: Create a Service - SuperSERVICE Manager
This section describes how to use SuperSERVICE Manager to bundle one or more SuperSTAR applications together into a Windows service. Start SuperSERVICE Manager (go to the Windows start menu and select All Programs > SuperSTAR > SuperSERVICE Manager > Supe
Page: Create a Single Level Field - SuperCROSS
A single field counts the number of values for specified conditions (for example "Males aged over 75"). The condition can be constructed based on multiple existing fields, but they must all be from the same table. To create a quantile field: Select Cross
Page: Create a Time Span Field - SuperCROSS
A time span field is a measure that calculates the time difference between two date/time fields (or a date/time field and a specified date). To create a time span field: Select Cross > Define Field. The Define Fields window displays. Click Time Span. The
Page: Create a Unique Field - SuperCROSS
A unique field is a measure that counts the number of distinct results for a field. Saved tables containing a unique field cannot be read by SuperWEB1, or generated by the SuperSERVER Production System software. To create a unique field: Select Cross > De
Page: Create a Weight Field - SuperCROSS
A weight field applies a weighting to an existing field. To create a weight field: Select Cross > Define Field. The Define Fields window displays. Click Weight. The Weight Field window displays. SX-Weight-Field.png Enter the following details: Field Descr
Page: Create Classification Tables - SuperCHANNEL
When designing your target SuperSTAR database, in most cases you will want to create references between the fact table columns and the classification tables that contain the descriptions of the values in the fact table. For example, you might have a fact
Page: Create References - SuperCHANNEL
When you design your target database, you will need to create references (or joins) between tables. For example: A link between a fact table column and the classification table that contains the descriptions of the values in that column. For example, in t
Page: Create Users and Groups
To create local users and groups in SuperADMIN, use the account command. This page contains a worked example of: Creating new user accounts for the users John Smith and Jane Doe. Creating a group called standardusers. Adding the new users to this group. T
Page: createdatabaselist
This command creates a text file containing a list of all the databases in the catalogue. Usage Description createdatabaselist <prefix> <server_id> <filename> {true|false} Create a list of databases and save it to a text file. Parameter Description <prefi
Page: Creating Data Control Plugins
A number of Data Control API plugins are provided with SuperSERVER. You can also use the API to create your own DLL or Shared Object (depending on your platform) for programmatic modification of the cross tabulation results. See Module Life Cycle - Data C
Page: cross-tabulation
In SuperSTAR this is the process of aggregating the required fields from the underlying records in a SuperSTAR database. See also tabulation.
Page: cross.ini
Summary Stores SuperCROSS display settings. SuperCROSS updates the settings in this file every time the user closes the client so that it can apply the same settings next time. Default Location C:\ProgramData\STR\SuperCROSS [Preferences] This section stor
Page: CrossModule.ini
Summary Defines the executable modules used by SuperCROSS. Most of the entries in the file are populated when SuperCROSS is installed and should not be changed. Default Location C:\ProgramData\STR\SuperCROSS\ [DB Access 32] This section stores details of
Page: crossrv.ini
Summary Stores information about previous Record View sessions, as well as some Record View configuration options. Default Location C:\ProgramData\STR\SuperCROSS [RV Fields] This section stores details of the fields most recently selected fields for Recor
Page: cs.ini
Summary Stores settings for client/server work groups, including the settings for batch processing using SuperCROSS. These settings are only used if the cs.ini file has been selected in the Use Specific Work Group File option in the File > SuperSTAR I Ser
Page: cube
A database in SuperSTAR format which contains aggregated (or summary) records. Records for totals may also be included in a cube.
Page: CubeCatalog.xml
Location <tomcat_home>\webapps\webapi\WEB-INF\data\.repository\CubeCatalog.xml The following are some of the parameters in this configuration file that you can change: Parameter Example Description totals totals="true" Enables or disables table totals. Y
Page: custom.xsd
Summary Configures additional metadata parameters. Default Location C:\Program Files (x86)\STR\SuperCROSS\xsds Storage of additional metadata against each SuperSTAR database element type, such as valuesets and valueset values (beyond what SuperSTAR curren
Page: Customise Header, Footer and Logo - SuperWEB2
In order to modify the header, footer and SuperWEB2 logo, you need to modify <tomcat_home>\webapps\webapi\layout\configuration.xml Replace the Logo If you are replacing the logo then we recommend you use an image with a height of between 60 and 80 pixels.
Page: Customise On Screen Text - SuperWEB2
You can modify most of the text that appears in SuperWEB2 to suit your requirements. This section demonstrates just one example by showing how to change the labels that appear in the browser/tab title and on the login screen: SW2-Custom-Login-Labels.png T
Page: Customise the User Interface Language Based on Country - SuperWEB2
In most cases, you will only need to create a single version of each properties file for each language. However, if you need to support languages with regional differences, such as US and Australian English, or Canadian and French French, then you can opt
Page: Customised Resources - Job Queue Manager
If you have customised SuperWEB2, then you must make sure that any customised resources are available to Job Queue Manager when it processes jobs in the queue. Changes such as table labels, headings, copyright, file templates, even entire languages, which

D

Page: D
<div class="str-glossary"> </div>
Page: Data Access API
The Data Access API is a framework that provides a way of developing your own applications for users who need structured access to reports and data. It provides a way of retrieving cross tabulation results, as well as information about the structure of th
Page: Data Control
Data Control plugins provide a mechanism for applying pre- and post- processing to the cross tabulation results. The following external Data Control plugins are provided with SuperSERVER: Confidentiality / Disclosure Control Perturbation Relative Standard
Page: data cube
A multi-dimensional representation of data in which the cells contain "measures", and the axes or "edges" represent the dimensions by which the data can be interrogated.
Page: Data Type Mapping - SuperCHANNEL
The Data Type Mapping tool shows how data types are mapped between the source and target databases. This tool is only available when you are connected to a source and target database. The list on the left contains all the data types supported by the JDBC
Page: database
A database consists of one or more tables, which have one or more records which have one or more fields.
Page: Database Classification Hierarchies
A number of hierarchy types are logically possible in classifications. These include balanced, unbalanced, and ragged hierarchies, as shown in the examples below. Whatever the logical structure for a hierarchy, SuperSTAR requires that the physical structu
Page: Database Design
SuperSTAR is designed to provide fast cross-tabulation of large datasets without programming. In order to use your data in SuperSTAR you need to convert it to Space-Time Research's proprietary column-oriented database format, SXV4. You will use the SuperC
Page: Database Formats - SuperCROSS
SuperCROSS supports the following database file formats: Format Description SXV4 This is the proprietary SuperSTAR database format. SXV4 is a highly optimized, compressed file format used for tabulating complex hierarchies and relationships for unit recor
Page: Database Naming Conventions
This section describes the naming conventions recommended by Space-Time Research when using RDBMS sources to create SuperSTAR databases. While you do not have to following the recommended naming conventions, doing so can make it much easier to use SuperCH
Page: Database Performance Considerations
The following guidelines describe some best practices you can adopt to: Achieve high performance when using SuperCHANNEL to convert your source data to SuperSTAR format. Achieve high performance when cross tabulating the data in the SuperSTAR clients. Gui
Page: database-metadata.xml
Location <tomcat_home>\webapps\webapi\WEB-INF\database-metadata.xml This file contains database-level metadata used in SDMX downloads. For example: <!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd"> <properties> <entry key="ATTRIBUTE|SU
Page: DATABASE_LABEL - Registry Table
Use the DATABASE_LABEL registry table to specify a name/label to use for the SXV4 database. By default the database label has the same value as the SXV4 file name. This label is used in the Source View in SuperCHANNEL. It is not used in the Target View an
Page: date_time field
A field in a database that is stored in date/time format. Date/time fields can be used in special calculations.
Page: DDI - SuperCHANNEL
DDI (Data Documentation Initiative) is an international metadata specification for the social sciences. There is a custom version of SuperCHANNEL available that is supplied with a DDI driver. Any DDI document being prepared for consumption in SuperCHANNEL
Page: default recode
In SuperCROSS, a field available from the database in its original form i.e. without any recoding of its values.
Page: default summation
In SuperCROSS and SuperWEB2, this is the default sum or count used for tabulation. The default summation can be a column designated as a measure, or the row count for a table. Also known as a Default measure.
Page: Default User Accounts
For convenience we provide several default user accounts. These accounts are for you to complete the initial configuration and testing. The following accounts are provided by default: Username Password Default Permission Level user1 user1 Administrative u
Page: Delete a Group - SuperWEB2
To delete a custom group: Select the My Custom Data tab. SW2-Edit-CustomData-1.png In the My Custom Data and Geography section, select the check box next to the group you want to delete. SW2-Delete-CustomData-1.png Click Delete. SW2-Delete-CustomData-2.pn
Page: derivation
A derivation is a mathematical calculation that is applied to field items or axis items in a table. Derivations are used to perform calculations such as sums and percentages on tabulated data.
Page: Derivations - SuperCROSS
You can add new items to a table field or axis, such as totals, sub-totals, percentages, rates, and differences. These are known as derivations. Derivations can also include mathematical and statistical functions, such as the mean and standard deviation.
Page: DeriveEntry
SuperCROSS Production System SuperWEB1 SuperWEB2 Element Format Description Save Load Load Save Load Save Load DeriveEntry DeriveEntryDefine DeriveBody DeriveEnd DeriveEntryDefine 'DERIVE' IdentifierString IdentifierString – Display name
Page: DimensionEntry
SuperCROSS Production System SuperWEB1 SuperWEB2 Element Format Description Save Load Load Save Load Save Load DimensionEntry DimensionEntryDefine DimensionBody DimensionEnd DimensionEntryDefine 'DIM' Yes Yes Yes Yes Yes Yes Yes Dimens
Page: Disable Totals - SuperWEB2
When you drag field values to create a new table, SuperWEB2 automatically adds a Total row as shown below. You can disable this. image2013-3-14 9:24:34.png To turn off automatic totals, you need to edit the file <tomcat_home>\webapps\webapi\tableView\tabl
Page: Disclosure Control
Maintaining the confidentiality of information about individuals or organisations is becoming increasingly important in both business and government. At the same time, it is important to balance these privacy requirements with the need to maintain as much
Page: Disclosure Control SuperADMIN Macro
The following is a sample SuperADMIN macro that demonstrates the different confidentiality options that are available and how to configure them. The macro creates a method for each of the rules. It then creates a folder in the database catalogue called Co
Page: Display Name - Job Queue Manager
If you have multiple Job Queue Manager instances running against the same database, you may wish to set the display name. This name is displayed in the database, and will allow you to tell which jobs belong to which Job Queue Manager instance. If you do n
Page: displayoptions
This command is used to set the display precision for summation options in SuperWEB2. Usage Description displayoptions <database_id> Display the settings currently configured for the specified database. displayoptions <database_id> <summation_option> Disp
Page: Documentation Help
We've tried to make our online documentation system as easy to use as possible. You can find what you need by searching, browsing or following the links. And if you've got feedback, use the box at the bottom of the page to let us know: UsingTheDocsOnePage
Page: domain
This command displays and edits the current settings of the SuperSTAR domain administration server. If you have multiple SuperSTAR domains running on the same network, then you can use this command to manage the connections to those domains. Usage Descrip
Page: Download Library
The following files are available for download:
Page: Download Tables - SuperWEB2
Once you have created a table, you can download the table data in any of the following formats: Excel 2007 Excel 2003 Comma Separated Value (CSV) CSV string value SDMX Structure Definition SDMX Archive You cannot reload a downloaded table back into SuperW
Page: drill (down/up)
A field hierarchy can be traversed when it is used in a SuperCROSS or SuperWEB2 table. This is referred to as Drill Down (go to a more detailed level in the hierarchy), or Drill Up (go to a less detailed level in the hierarchy).
Page: dumpcodes.properties
Location <tomcat_home>\webapps\webapi\WEB-INF\classes\dumpcodes.properties This file allows you to blacklist certain field values from mapping. Users will not be able to access Map View if the table contains one of the blacklisted field values. The blackl
Page: duty of care
Functionality in SuperCROSS which, when enabled by the user, provides warnings when potentially erroneous tables may be generated.

E

Page: E
Page: Edit a Group - SuperWEB2
To edit a custom group you have created: Select the My Custom Data tab. SW2-Edit-CustomData-1.png In the My Custom Data and Geography section, select the check box next to the group you want to edit. SW2-Edit-CustomData-2.png Click Edit. SW2-Edit-CustomDa
Page: Enable Protection Against Session Hijaking - SuperWEB2
To provide an enhanced level of security for SuperWEB2, you can enable the following two configuration parameters in <tomcat_home>\webapps\webapi\WEB-INF\web.xml. These parameters are commented out by default: <!-- Session UserAgent Filter --> <!-- <filte
Page: Enable Record View - SuperWEB2
The Record View feature allows users to access information about the unit record data that makes up the values in the table. This feature is disabled by default. You can enable the feature on a per user basis if necessary. To enable Record View: Use the c
Page: Example - Create a Service to Start SuperADMIN and SuperSERVER - SuperSERVICE Manager
The following example shows how to use SuperSERVICE Manager to create a service called SuperSTAR that starts SuperADMIN and SuperSERVER. This example assumes that the applications have been installed to the default installation locations. Start SuperSERVI
Page: Example Macro - LDAP
As an alternative to typing out all the commands to configure LDAP/Active Directory, you can create a macro file and then run the macro in SuperADMIN. The following is an example of a complete macro for setting up an authentication service for an Active D
Page: Example of Channelling SPSS Survey Data - SuperCHANNEL
The following is a worked example of channelling using SPSS survey data. Make sure you have converted your source survey data to the correct SPS file format. See SPS File Format - SuperCHANNEL and Converting SAV and POR Files - SuperCHANNEL for more infor
Page: Examples - Field Level Security
The following are some worked examples of configuring Field Level Security: Hide a Cross Tabulation Field This example hides the field Customer Mail Indicator from the user vicuser1: > cat bank "Customer Mail Indicator" access vicuser1 read false Unrestri
Page: Examples - SNU
To completely build (or rebuild) a SuperSTAR database using the settings in the project XML file, use the following command: snu -create -insert <project> Replace <project> with the filename of the project file. This must be the full path if it is not loc
Page: export
This command exports the current database catalogue to a macro file. You might wish to schedule this task so that it can be completed out of hours with no user intervention as part of your backup strategy. Usage Description export Exports the database cat
Page: Export Records - SuperCROSS
You can use the Record View feature to export unit record data from SuperCROSS. You can either export the records direct from the table or after you have retrieved the individual records. Export Direct From the Table Click the cell you want to export to h
Page: exportswc
This command exports the current SuperWEB1 configuration to a macro file. Usage Description exportswc Exports the SuperWEB1 configuration to a macro. By default, the macro will be saved to C:\ProgramData\STR\SuperADMIN\console\export\exported_swconfigurat

F

Page: F
Page: faces-config.xml
Location <tomcat_home>\webapps\webapi\WEB-INF\faces-config.xml The following are some of the parameters in this configuration file that you can change: Parameter Example Description More Information enableTableAnnotations annotationPanelExpanded <proper
Page: fact table
In SuperCHANNEL this is a table containing the raw data about a particular database entity. For example, a person fact table in a census database. The table typically contains columns that are foreign keys referring to classification tables, as well as da
Page: FACTS - Registry Table
Use the FACTS registry table to specify which tables are fact tables. A table cannot be both a fact table and a classification. If the same table is incorrectly specified in both the FACTS registry table and the CLASSIFICATIONS registry table, then the FA
Page: field
A field is an attribute of a table in a database. This is a synonym of column.
Page: Field and Axis Reference Items - SuperCROSS
The field or axis reference item is a special type of field/axis item that you can reference in a derivation. Understanding Reference Items To understand reference items, you need to understand how derivations are constructed and calculated. When you crea
Page: field derivation
A field derivation is an arithmetic expression that can use field items from a specific field in a table as variables. Field derivations could be percentages, sums, subtotals and other such expressions.
Page: field hierarchy
A field hierarchy refers to a field which has items that can be aggregated to a higher level. As an example, a field relating to postal codes could be arranged in a hierarchy, as regions or states are determined by postal codes.
Page: field item
A part of field that can include field values as well as derived calculations such as sub totals and percentages.
Page: Field Level Security
Field Level Security (FLS) is a feature in SuperSTAR that allows administrators to control access to data. Access to fields and/or field values can be limited for specific users or user groups. Example This example uses the standard Retail Banking databas
Page: Field Level Security and Data Control - Job Queue Manager
Field Level Security Space-Time Research recommends that you set up field level security before creating saved tables and queries in SuperWEB2. Changes to field level security settings may cause problems with existing saved tables. For example, suppose a
Page: field name
The name used to describe a field in the database. For example, Occupation.
Page: field recode
See recode.
Page: field reference item
Any field value can be manually set as the field reference item. You can have multiple field reference items in a table, but only ONE per field. By default, the field reference item will be the first or last in the list depending on the Recode Total's set
Page: field value
A cross-tabulation field has a number of distinct values. For example, the values for the field sex are male and female.
Page: Files, Samples and Documentation - Data Access API
The Data Access API includes the following directories and files. Directory Contains... config Configuration files, including administrationServerCatalog.xml, which is used to configure the connection between the Data Access API and SuperSERVER/SuperADMIN
Page: Filters - SuperWEB2
Filters (or subjects in SuperCROSS) are an extra dimension that you can add to a table. When you apply filters to a table then only records that match the filters will be included in the results. For example: The following table shows Occupation by State
Page: flag records
Identify particular records that are in a database at that point in time. For example, flag the 90 year male records. This allows longitudinal analysis of data.
Page: Flag Records - SuperCROSS
You can flag records that meet certain criteria. When the records have been flagged they can then be used in tabulations. This can be useful when performing studies over time on groups of spe­cific individuals, such as customers or patients. The records a
Page: flat field
A field that has a single set of discrete values associated with it.
Page: folder
A folder or directory is a part of a file system which organises folders, sub-files or files.
Page: foonote_footer
Descriptive text displayed at the bottom of each SuperCROSS table providing additional information about a table.
Page: Forecasting - SuperCROSS
SuperCROSS includes a forecasting feature, which allows you to predict future values based on past data. For example, you can use forecasting to answer the question: “what will next year’s sales be, based on sales for the last 10 years”? Example: Forecast
Page: foreign key
In SuperCHANNEL this is a field or a group of fields that points to a primary key of another table. See also key field and primary key.
Page: Format Tables - SuperCROSS
There are a number of options you can use to format and configure your tables. You can: Make changes to the field headings, and table header and footer to add extra information and notes. Sort tables, based on the cell values or the row/column/wafer label
Page: FunctionEntry
SuperCROSS Production System SuperWEB1 SuperWEB2 Element Format Description Save Load Load Save Load Save Load FunctionEntry FunctionEntryDefine (Large_NFunction | Small_NFunction | GiniFunction | CountDistinctFunction | PercentileFunction | VarianceFun
Page: fuzz factor
A method of dealing with representation errors (resulting from binary to decimal conversion) is to add a small number know as a fuzz factor to the number. There is no single fuzz factor that can solve all representation errors for all numbers. For more in

G

Page: G
Page: gc, config, globalconfiguration
This command manages some global configuration properties, most of which relate to the creation of personal folders in SuperWEB1 (Note: the personal folder settings do not apply to SuperWEB2). gc, config and globalconfiguration are the same command and ca
Page: Getting Started - SuperCROSS
This section is designed to help you get started with SuperCROSS. It shows how to launch the client and start creating tables with the supplied sample databases. Launch the application either by clicking the icon on your desktop or selecting the SuperCROS
Page: Getting Started - SuperWEB2
This section describes how to get started with SuperWEB2. It shows you how to login to SuperWEB2 and start creating tables. Step 1 - Login SuperWEB2 is a browser application. Your system administrator will provide you with a URL or link for your SuperWEB2
Page: Glossary
Page: grand total
In SuperCROSS this displays the totals for all axes.
Page: Graph View - SuperWEB2
Click the Graph View tab to generate a graph based on your current table: SW2-GraphView.png Graphs in SuperWEB2 display a maximum of 216 data items. If your table contains more than 216 data items you need to reduce the number of data items in your table
Page: group
In SuperCHANNEL fields are by default grouped according to the table they belong to. The Grouping tool can be used by the user to define field groupings. In SuperCROSS the groups display in the Fields dialog for each database table, and the group contains
Page: GROUP - Registry Table
Use the GROUP registry table to arrange fields into groups. These groups will be displayed in the field lists in the SuperSTAR clients, making it easier for the end user to navigate. For example: The Fields window in SuperCROSS with no groups: SX-Fields-N
Page: Group-based Authorisation - Active Directory and LDAP
Once your LDAP or Active Directory authentication service is up and running, any groups in the LDAP directory that match the criteria set by the various auth <service_name> group commands will be available as groups in SuperADMIN. Such a group can then be
Page: Grouping Tool - SuperCHANNEL
Use the Grouping tool to create groups of fields and change the order the fields display in the SuperSTAR clients. This can be particularly useful when your database contains a large number of fields. It does not change the structure of the database, but

H

Page: H
Page: HeaderEntry
SuperCROSS Production System SuperWEB1 SuperWEB2 Element Format Description Save Load Load Save Load Save Load HeaderEntry 'HEADER' { StandardHeader } DatabaseId {LoadStdRcd} {TableHeading} {TableFooter} {Alignment}* {SaveOption} {PrintOptions} {Prefere
Page: help
This command displays a list of currently available commands and details of what they do. Usage Description help Displays a list of available commands and a brief description of what each command does. help <command> Displays detailed information about th
Page: hidden data
Data that has been used in calculations or other parts of the table that is not to be shown as part of the final table.
Page: hierarchical field
See field hierarchy.
Page: hierarchy
A hierarchy presents classification information in a graded order. For example: A suburb is a part of a city. A city is part of a state or region. A region is part of a country. In this example the layers in the hierarchy are: Country State/Region City Su
Page: How To... - SuperCHANNEL
This section describes how to accomplish a number of tasks in SuperCHANNEL.
Page: How To... - SuperCROSS
This section describes how to configure a number of SuperCROSS features:
Page: How To... - SuperWEB2
This section describes how to configure a number of SuperWEB2 features:

I

Page: I
Page: I18n/I18n/I18N
Abbreviation for internationalisation. The means of adapting products such as publications, hardware or software for non-native environments, especially other nations and cultures.
Page: Import and Append Data to a Table - SuperCROSS
Use the File > Import option to append imported data to a table. The imported data must be column based data. You can also import data using derivations. See Add External Axis Item - SuperCROSS for more information. Create your table. Select File > Import
Page: Index
Page: initialization files
Initialization or "INI" files are used by SuperCROSS to store configuration information.
Page: Install - Data Access API
Software Requirements To install and use the Data Access API, you need the following software: SuperSTAR Java Development Kit (JDK) 6 or above Apache Ant 1.7.0 or above Make sure you have set up your PATH system environment variable so that it includes th
Page: Install - Job Queue Manager
Installation Requirements Requirement Details SuperSTAR installation Job Queue Manager requires SuperADMIN, SuperSERVER and SuperWEB2. Relational Database (RBDMS) JQM requires a relational database to store tabulation results, such as Oracle, Microsoft SQ
Page: Install - SuperCHANNEL
These are the instructions for installing just SuperCHANNEL. Alternatively, you can install the SuperSTAR Suite, which installs all the SuperSTAR applications, including SuperCHANNEL, as part of a single install process. These instructions are for Microso
Page: Install - SuperCROSS
These are the instructions for installing just the SuperCROSS client. Alternatively, you can install the SuperSTAR Suite, which installs all the SuperSTAR applications, including SuperCROSS, as part of a single install process. To install your software: I
Page: Install - SuperSERVER
These are the instructions for installing just SuperSERVER. Alternatively, you can install the SuperSTAR Suite, which installs all the SuperSTAR applications, including SuperSERVER, as part of a single install process. These instructions are for Microsoft
Page: Install - SuperSTAR
To install your software: Open Windows Explorer and browse to the installation package. This will either be on a DVD that has been supplied to you or a package that you have downloaded. If you have downloaded the installation package, then you may need to
Page: Install - SuperWEB2
These instructions explain how to install and set up the web server for SuperWEB2. If you are an end user of SuperWEB2 then you do not need to follow these steps–your system administrator will already have set up SuperWEB2; all you need to connect is your
Page: Install Multiple Instances - SuperCROSS
It is possible to install multiple instances of SuperCROSS on one computer. This is useful when you want to run multiple copies of SuperCROSS in server mode, or to have different SuperCROSS configurations available. Install the first copy of SuperCROSS by
Page: Install SuperSERVER and SuperADMIN on Different Machines
These instructions explain how to set up SuperSTAR when you want to install SuperSERVER and SuperADMIN on different machines. Step 1 - Install SuperSERVER The first step is to run the SuperSERVER installation process: Go to the machine where you want to i
Page: Installation Requirements, Compatibility and Supported Platforms
This section defines the hardware and software requirements for the SuperSTAR suite of products. This information is subject to change. Please contact customer support if you wish to confirm specific details. Support Levels The following table defines fou
Page: Interpreting Logs - SuperCHANNEL
When you start a build in SuperCHANNEL, the progress log displays automatically. SC-Build-Logs.png Log Overview The log messages start with details of the exact build of SuperCHANNEL in use, followed by the command line options passed to the SNU command t
Home page: Introduction
Welcome to the Space-Time Research customer documentation for SuperSTAR 8.0 Where Do I Start? New to Space-Time Research products? Start here: Overview - SuperSTAR Interested in Upgrading from an Earlier Release? Read what's new in version 8.0 Need help u
Page: Introduction - SuperCROSS
Welcome to SuperCROSS, the desktop client for the SuperSTAR platform. This section introduces some of the key SuperCROSS features: Record View One of the major strengths of a SuperSTAR database is the inclusion of unit record data. The record view feature

J

Page: J
Page: Java and Tomcat
Java is a programming language and computing platform first released by Sun Microsystems in 1995. It is the underlying technology that powers state-of-the-art programs including utilities, games, and business applications. Java runs on more than 850 milli
Page: JAVA Naming and Directory Interface (JNDI)
A service that allows software clients to discover and look up data and objects via a name. This standard is supported by most of the application servers - Tomcat, Websphere, JBoss.
Page: JDBC Drivers - SuperCHANNEL
JDBC (Java Database Connectivity) is a programming interface that lets Java applications access a relational database. SuperCHANNEL needs a JDBC driver so that it can access the relational database system (e.g. SQL Server, Oracle, etc) where your source d
Page: Job Expiry and Removal - Job Queue Manager
By default, processed jobs remain in the database and will continue to be available to download from the My Tables page. If you wish to automatically remove jobs after a period of time you need to: Configure the job expiry time (this specifies that a job
Page: Job Queue Manager
Some complex tasks in SuperWEB2 may take a long time to run. Examples include large queries or tables, or a big group of cross-tabulation requests. The Job Queue Manager diverts user requests for large tables to a background processing queue so that the u

K

Page: K
Page: key field
A field in the database that can be viewed in Record VIEW but not used in tabulations. For example unique IDs and long text fields. Key fields are plain fields. This field is guaranteed to be unique for the record you see in the Record View. See also: key
Page: Known Issue with Kaspersky Security Software and SuperWEB2
Kaspersky Security Software has been found to cause issues with SuperWEB2 in certain situations. The issues include delays logging in, and problems loading tables and databases (particularly large tables). If you are experiencing problems such as these an
Page: Komodo driver
The Komodo driver is a JDBC driver supplied with SuperCHANNEL for accessing Space-Time Research's older (deprecated) SXV3 and SXV2 database formats. This driver allows SuperCHANNEL to read data from SXV3 and SXV2 databases using the standard JDBC 1.0 inte

L

Page: L
Page: Large Tables - SuperWEB2
If you attempt to create a table containing a very large number of cells, then SuperWEB2 will automatically enter "large table mode". SuperWEB2 displays the following message: SW2-LargeTableMode.png In large table mode, you will no longer be able to use t
Page: layer
In SuperWEB2, a layer contains field values for one field. You can add multiple layers to a table, for example, male and female, and then select which layer you want to display. This is a way of filtering data and makes complex tables more readable.
Page: Layers - Charts - SuperCROSS
Use the Layer Control window to configure the main features of the chart and to add additional layers, such as annotations. Select View > Layer Control to show or hide the Layer Control window. Chart-Layer-Control.png You Can... Do This... Add additional
Page: Lightweight Directory Access Protocol (LDAP)
This is a networking protocol for querying and modifying directory services ruining over TCP/IP. An LDPA directory structure is a tree of entries, each with a set of name attributes with values. For more information, see: http://en.wikipedia.org/wiki/Ldap
Page: List of Suggested JDBC Drivers
The following is a list of JDBC drivers for different relational database systems. RDBMS Recommended Driver Example of JAR File Driver Class Download From H2 H2 driver h2-1.3.171.jar org.h2.Driver http://www.h2database.com/html/download.html http://www.h2
Page: Loading SPSS Survey Data - SuperCHANNEL
SPSS (Statistical Package for the Social Sciences) is a tool for statistical analysis of survey data. SuperCHANNEL can import SPSS survey data and convert it to a SuperSTAR database. The SPSS driver supplied with SuperCHANNEL (spsscmd) can read the SPSS q
Page: Log Out - SuperWEB2
To log out of SuperWEB2, click the link in the top right corner: SW2-Logout.png Or simply close your browser.
Page: Logging - Job Queue Manager
You can configure the amount of logging information that Job Queue Manager writes to its log files. Go to the Tomcat instance that is running Job Queue Manager and open <tomcat_home>\webapps\jobQueueServer\WEB-INF\classes\META-INF\persistence.xml in a tex
Page: Logging - SuperSERVER
SuperSERVER logs information during its operation to the SuperSERVER logs directory (for example: C:\ProgramData\STR\SuperSERVER SA\logs if you installed SuperSERVER to the default location). The settings for logging are defined in log4j.scsa.properties.
Page: Logging - SuperWEB2
SuperWEB2 logs information during the lifetime of the application to the log files located in <tomcat_home>\logs There are a number of logging levels available for SuperWEB2: Level Logs... ERROR Runtime errors and unexpected conditions. This is the defaul
Page: Logging - User Data Repository
You can configure the amount of logging information that the User Data Repository writes to its log files. Open <tomcat_home>\webapps\webapi\WEB-INF\classes\META-INF\persistence.xml in a text editor. Locate the following line: <property name="eclipselink.
Page: login
Logs in to SuperADMIN. You must login to start configuring users and permissions. Usage Description login Logs in to SuperADMIN. If you type the login command without entering your username and password, you will be prompted to enter them. login <username
Page: logout
Logs the current user out of the console. Usage Description logout Logs out of the console.

M

Page: M
Page: macro
When performing repetitive tasks, instead of entering each command at the command line, you can enter the commands in a macro and then run the macro. You can use the macro command to: Record all the commands you type into the console to a file. Play back
Page: macrodata
See summary data.
Page: Manage the Job Queue - Job Queue Manager
You can check the status of jobs that have been submitted to Job Queue Manager by querying the database directly. You can also direct database access to remove failed jobs from the queue, change the job priority, and restart failed jobs. Follow these guid
Page: mandatory fields
Mandatory fields are fields that are always in the table.
Page: Mandatory Fields - SuperCROSS
It is possible to configure SuperCROSS to require specific fields in a table. SuperCROSS will not allow the user to perform the cross tabulation unless the mandatory field(s) have been added to the table. If a user attempts to cross tabulate a table that
Page: Map View - SuperWEB2
If your table contains geographical data, then you can use Map View to display the results on a map. The Map View tab becomes enabled whenever you create a table containing a geographical field. Create a Map Create a table containing a geographical field.
Page: measure
A column in a database table that can be summed. In SuperCROSS, a measure is a numeric field that can be used with mathematical and statistical functions. For example, income, weight, or expenditure. The sum is the default function applied. In SuperWEB2,
Page: MEASURES - Registry Table
Use the MEASURES registry table to specify the columns in a fact table that are to be treated as measures. Table Definition Column Name Data Type Size Primary Key Specifies... COLUMNNAME string 128 YES The name of a column to be set as a measure. TABLENAM
Page: Menu Options - Charts - SuperCROSS
This page describes the menu options available in chart mode. For details about the standard SuperCROSS menu options, see Menu Options - SuperCROSS. File Menu Option Icon Keyboard Shortcut Select To... New File-New.png Ctrl+N Open the Catalogue dialog to
Page: Menu Options - SuperCHANNEL
File Menu The File menu allows you to connect to the source and target databases, and save and reopen project files. Option Icon Keyboard Shortcut Select To... New Project New.png Ctrl+N Create a new SuperCHANNEL project. You will be prompted to save the
Page: Menu Options - SuperCROSS
File Menu Option Icon Keyboard Shortcut Select To... New File-New.png Ctrl+N Open the Catalogue dialog to choose a database and create a new table. Open File-Open.png Ctrl+O Open a SuperCROSS project, saved table definition, or database file. Open With
Page: merge
See concatenate.
Page: metadata
Metadata is information about a particular database, fields and field items. For example it may describe how, when, and by whom it was received, created, accessed, and/or modified, and how it is formatted. Also known as meta-information.
Page: Metadata - SuperWEB2
You can add metadata about databases, tables, and fields within tables to SuperWEB2. Once the metadata is set up, end users can click the links in the SuperWEB2 interface to read the additional information about the data they are working with. Metadata li
Page: Metadata and Multilingual Tables - SuperCROSS
Metadata is extra information about columns and fields that is stored in the database and available to the client applications. What Can I Do With Metadata? There are two main ways you can use metadata: Descriptive Information You can use metadata to add
Page: metadata driver
A program module or library that provides access to a metadata repository.
Page: method
The method command is used to set parameters for data control plugins and apply the plugins to a database.For more information about configuring Data Control plugins, see Method Catalogue Overview - Data Control. Usage Description method Displays a list o
Page: Method Catalogue Overview - Data Control
To use the Data Control plugins (either the supplied plugins or ones you have written yourself using the API), you need to configure the method catalogue in SuperADMIN. A "method" is simply a configurable group of Data Control plugins that can be applied
Page: Method Catalogue Permissions - Data Control
By default, only administrators are allowed to select table methods in SuperCROSS. Grant or Deny Permission to Select Table Methods in SuperCROSS If users have permission to select table methods in SuperCROSS, then the Select Table Method icon Edit-Selec
Page: microdata
See unit record data.
Page: mode
This command sets one of the SuperADMIN commands as the current "mode" of the console. The specified command is then automatically prefixed to future commands so you do not have to type it each time. For example, setting the mode to auth means that you ca
Page: Modify Table Header, Table Footer and Field Heading - SuperCROSS
You can modify the table header and footer: Modify-Header-Footer.png To edit the header, footer, or a field heading: Double-click the item. The Edit Table Header / Edit Heading / Edit Table Footer dialog displays. Edit-Table-Header.png Make your changes a
Page: Module Callback API - Data Control API
JobInfoT has a member struct m_Callbacks that contains a set of function pointers that provide modules with access to table structural information and the results of a cross tabulation request. The full set of callback functions accessible to a module, an
Page: Module Life Cycle - Data Control API
A Data Control module is a DLL or Shared Object that provides the custom implementation. Each module must implement the interface defined in the externaldcmodule.h header file (if you have installed SuperSERVER to the default location, this is located in
Page: Monitoring - SuperCHANNEL
This section describes how to configure monitoring in SuperCHANNEL. You can use monitoring to check the progress SuperCHANNEL has made converting your source data into the target sxv4 format. Activating monitoring will slow down the conversion, particular
Page: Multi-Homed Hosts
A multi-homed host is a computer that has multiple IP addresses to connected networks (it is physically connected to multiple data links that can be on the same or different networks). In situations where the server hosting SuperSTAR is multi-homed (has m
Page: Multi-Homed Hosts Worked Example - SuperSTAR
This example demonstrates how to configure SuperSTAR for a multi-homed host, using the following example system architecture: Multi-Homed-Example.png In the example architecture: The SuperSTAR host runs Windows Server 2008. It hosts SuperADMIN, SuperSERVE
Page: multi-response field
Surveys often have rating based questions. For example modes of transportation versus rating of use for each mode, normally this could be defined as multiple questions, however often it makes sense to group these similar questions into a single field/ques
Page: Multi-Response Questions in Survey Data - SuperCHANNEL
Multi-response questions or fields are commonly found in survey data. These are questions where the survey respondent can give more than one answer. For example: Q1: How do you usually travel to work (please tick all that apply)? [ ] Walk [ ] Bus [ ] Car
Page: Multilingual and Localisation Support - SuperWEB2
SuperWEB2 supports multiple user interface languages. When a user accesses SuperWEB2, it attempts to select the most appropriate language for the user interface, based on the list of accepted languages sent by the user's web browser. This means that if yo
Page: MULTIRESPONSES - Registry Table
Use the MULTIRESPONSES registry table to list all the tables in the database that are to be treated as fact tables with multi-response data. Table Definition Column Name Data Type Size Primary Key Specifies... TABLENAME string 128 YES The name of a table
Page: My Custom Data - SuperWEB2
You can use the My Custom Data tab to create your own custom groups of values (also referred to as recodes). Once you have created a custom group, you can use it in your tables. Your custom groups will be saved on the server and you can access them again

N

Page: N
Page: naming service
The naming service is an example of an object repository. It is a standard CORBA service, implementing the Interface Definition Language specified by the Object Management Group. Application servers export object references into the naming service, provid
Page: Navigate Hierarchies (Drill Down, Drill Up) - SuperCROSS
If you have a hierarchical field in your table, then you can use the options on the right-click menu to navigate the hierarchy: Right-click a field. Select Drill > Down or Drill > Up. For example, the sample Retail Banking database includes a hierarchical
Page: nesting
Two fields can be nested into one axis. For example, a table could show nationality across the columns, and gender then religion down the rows. The first value (eg Female) of gender is listed first, then all values of religion, followed by the second valu
Page: Nesting Fields in an Axis - SuperWEB2
You can add multiple fields to a single axis in your table, with the fields nested underneath each other. For example, the following is an excerpt from a table containing three fields nested on the row axis: SW2-Table-Nested-Fields.png However, to build t
Page: New Features
This is a summary of the new features we added in SuperSTAR 8.0. We're currently working on SuperSTAR 9.0. You can check out the new features that are coming in SuperSTAR 9.0 here. General Get Running Faster, Keep Running Easier setup.png Installer Revamp

O

Page: O
Page: Online Analytical Processing (OLAP)
A category of software tools that provides analysis of summarised data stored in a multidimensional database. OLAP tools enable users to analyse different dimensions of the summarised multidimensional data.
Page: Online Microdata Analytical Processing (OLMAP)
A category of software tools that provides analysis of microdata stored in a multidimensional database While the software has some similarities to online analytical processing (OLAP) packages, it is unique in that it operates directly on microdata without
Page: Open a Database - SuperCROSS
Use the Catalogue - Select Database or Table window to open a database, table, or cube. SX-Catalogue.png By default, the Catalogue window opens automatically when you start SuperCROSS. You can also open it at any time by selecting File > New. There are th
Page: operator
A symbol representing a mathematical or arithmetic operation. Such as %, +, -.
Page: Options - SuperCROSS
You can set various options and settings for the SuperCROSS client from the Options window (Edit > Options). This section explains the options available on each tab. You can use the Set As Default check box to save your settings as the defaults for the ne
Page: OrderEntry
SuperCROSS Production System SuperWEB1 SuperWEB2 Element Format Description Save Load Load Save Load Save Load OrderEntry OrderEntryDefine OrderBody OrderEnd OrderEntryDefine 'ORDER' Yes Yes Yes No Incorrect results. Data uses both axi
Page: Other Useful Commands - Active Directory and LDAP
The following are some other useful commands for configuring an LDAP authentication service. Command Description auth <service_name> remove Remove the specified authentication service. Note: To avoid having to reconfigure the service, you might want to de
Page: Output API - SuperCROSS
The SuperCROSS Output API lets programmers add new output formats to the SuperCROSS Save options. New output formats are described in Microsoft Windows DLLs called output plugins. The plugins contain the functionality needed by SuperCROSS to present the f
Page: Output API Functions - SuperCROSS
The OutputCallBackType struct provides all the information and functionality you need to thoroughly examine a SuperCROSS table. This section provides a comprehensive listing of the available functions: short QuerySuperMARTID(HANDLE hTable, LPSTR IDBuff, s
Page: Output API Variables - SuperCROSS
Variable Description long LenOCBT Length of the OutputCallBackType struct. HTABLEOBJECT hTable Handle to the table data. This needs to be passed to most callback functions. If you get compiler warnings or errors when using hTable, assign it to a variable
Page: Output Formats - SuperCROSS
To save a table or chart, use the File > Save or File > Save As menu options. The following formats are available: Format Description SuperCROSS (.SCS) The native SuperCROSS project file format. SuperTABLE Dissemination (.SCS) For use in SuperTABLE. Tab-d
Page: Overview - SuperCROSS
The following is an overview of the elements available in the SuperCROSS interface: SX-Overview-Annotated-GS.png To start creating a table, simply drag and drop a field onto one of the axes. You can nest multiple fields on a single axis (as shown in the e
Page: Overview - SuperSTAR
SuperSTAR is the Space-Time Research suite of software products. SuperSTAR provides a unique solution to the challenge of fast, confidentialised data tabulation, analysis, visualisation and dissemination of large amounts of organisational data. SuperSTAR
Page: Overview - SuperWEB2
SuperWEB2 The following diagram shows an overview of the SuperWEB2 architecture. SuperWEB-Architecture.png Security Configuration and Port Use If you are deploying SuperWEB2 into a network environment that has network and host level security, you will nee
Page: Overview and Architecture - SuperSERVER
SuperSERVER is the power behind the entire SuperSTAR product suite: SuperSTAR-Architecture-Overview.png For more information on the rest of the SuperSTAR family, see Overview - SuperSTAR. Components and Architecture SuperSERVER-Architecture.png For histor

P

Page: P
Page: parameter log
A description of a SuperCROSS table which is useful for documentation. Parameter logs are text files saved from SuperCROSS.
Page: PC-Axis/PC-Axis 2000
The PC-Axis software consists of a number of programs for the Microsoft Windows and Internet environment which can be used to present statistical information. SuperCROSS provides the ability to save data in PC-Axis format.
Page: PDF Downloads
The Space-Time Research online documentation portal will always have the latest documentation on our products. However, if you prefer to read the documentation in other formats, such as a PDF that you can download and print, then there are a number of opt
Page: Permissions Model - Inheritance and Conflicts
The following is an overview of the SuperSTAR permissions model, explaining how inheritance of permissions works, and what happens if there are conflicts between permissions: Summary Description Default permissions allow full access By default, when you g
Page: persistent recode
In SuperCROSS, you can set up recodes to automatically load by default SuperSTAR database is opened.
Page: perturbation
Perturbation is a disclosure control technique that protects against the disclosure of confidential information. When you apply perturbation to a database the cell values are adjusted by small amounts to avoid revealing confidential information. Learn Mor
Page: Perturbation - Data Control
Small values in cross tabulation results have the potential to reveal confidential information. Perturbation can be used to reduce that risk by adjusting cell values by small amounts. A key (referred to as the cell key) is generated for each cell in the t
Page: plain field
A field in a database which is not used as a measure, date, key or classification field. For example a customer's identity number, or an address. Such a field cannot be used in a tabulation, but its contents are available through Record View.
Page: plain table
In SuperCHANNEL this is a database table of an unknown type.
Page: Port Usage - SuperSERVER
SuperADMIN and SuperSERVER present a very small TCP/IP "surface area" that also makes effective layer three firewalling simple to achieve. SuperADMIN by default listens on TCP/IP ports: 9230 (CORBA IIOP) 9231 (Java RMI-JRMP protocol - services) 9234 (Java
Page: Prevent Guest Users from Creating Large Tables - SuperWEB2
If you decide to allow guest user access on your system, you may wish to restrict guest users from creating large tables, and thus prevent guest users from accessing large table mode. To prevent guest users from creating large tables, you need to edit <to
Page: primary key
In SuperCHANNEL this is a field (or multiple fields) that is used to uniquely identify a row in a table. See also key field and foreign key.
Page: Print Tables - SuperWEB2
Click the Print Table icon to print the current table: SW2-Print-Table.png The print functionality is best suited to smaller tables. If you have a larger table, you may wish to download the table in Excel format and then print your table from within Excel
Page: Printing - SuperCROSS
You can use the options on the File > Print menu to print your table from SuperCROSS. If you have selected part of the table then only the currently selected cells will print. If either all table cells are selected or no table cells are selected then the
Page: product.ini
Summary This file is used during the installation process. You can edit it prior to installing SuperCROSS to create a custom installation package for distribution. For example, you might use this to preconfigure the database catalogue. Default Location pr
Page: production system
The Production System is SuperSTAR software used to perform large scale batch processing of tables. These tables are specified using a .TXD file and the results are saved in a .CSV and .SCS file format. The Production System is a command line utility, usi
Page: production utility
The Production Utility is a product that merges SuperCROSS tables with SuperCROSS recodes to produce new tables. The resultant tables are created in SuperCROSS format and can then be individually loaded or cross-tabulated. It is a GUI-based utility select
Page: project file
The XML file which can be saved from SuperCHANNEL, describing the connection to the source data, and the content and format of the target sxv4 database.
Page: Project File Format - SuperCHANNEL
When you save your project in the SuperCHANNEL GUI, the settings are stored in an XML project file. This file contains all the information about your project, including: The source and target database details. Details of fact tables, classification tables

Q

Page: Q
Page: Queue Processing Frequency - Job Queue Manager
By default, Job Queue Manager checks for new jobs to process every 10 seconds. You can change this setting. Change the Queue Processing Frequency To change the queue processing frequency: Go to the Tomcat instance that is running Job Queue Manager and ope
Page: Quick Start - SuperSTAR Suite
Based on direct customer feedback, Space-Time Research has now made it much easier to install all of the main components of our SuperSTAR 8.0 family. We have also provided you with sample data, so you can easily verify that everything has been installed c
Page: quit
This command closes the SuperADMIN console. Usage Description quit Exits SuperADMIN.

R

Page: R
Page: random rounding
This is a confidentiality method used to disguise sensitive or confidential data. Random rounding output is determined only by the input data so the same randomly rounded results are produced every time. Variations in results may occur when fields are add
Page: ranges
This command configures the limits for the custom range and quantile user defined fields available in SuperWEB2. Usage Description ranges <database_id> Display the custom range limits currently defined for the specified database. For example: > ranges ban
Page: Ranges and Quantiles - SuperWEB2
Click the Range button next to one of the Summation Options to create a range or quantile based on that summation option: SW2-Summation-Options-Add-Range.png The Range dialog displays: SW2-Summation-Options-Range-Dlg.png You can choose either to create a
Page: Rearrange and Merge Fields - SuperCROSS
SuperCROSS makes it easy to rearrange the fields in your tables. Rearrange the Rows/Columns/Wafers Simply drag and drop the field labels to rearrange them: Drag-Fields-To-Rearrange.png Drag-Fields-To-Rearrange-Done.png Remove a Field Simply drag the field
Page: Rebuild an Existing SXV4 - SuperCHANNEL
Menu Options - SuperCHANNEL The following is an example of SuperCHANNEL in update mode. The previously mapped columns are greyed out in the Target View: SuperCHANNEL-Update-Mode-1.png If you want to change the design of the SXV4 and rebuild the database f
Page: recode
A recode is a user defined redefinition of field item values. For example, the Age field in a database may contain all individual ages from 0 to 99. Recoding these values allows definition of 5-year age groups, or teenagers, for example.
Page: Recode Reference - SuperCROSS
This section describes the options available in the Define Recode window. It is intended as a reference. If you are new to recodes, see the introduction to recodes in SuperCROSS, which contains a full guide to creating recodes with worked examples. Define
Page: recode total
In SuperCROSS, the total of a recoded set of values for a field.
Page: RecodeEntry
SuperCROSS Production System SuperWEB1 SuperWEB2 Element Format Description Save Load Load Save Load Save Load RecodeEntry RecodeEntryDefine RecodeBody RecodeEnd RecodeEntryDefine 'RECODE' IdentifierString 'FROM' IdentifierString {FactTa
Page: Recodes - SuperCROSS
Recodes allow you to redefine ("re-code") fields. For example: You have a field called Occupation, but are only interested in values for certain specific occupations. Overview-Occupation.png Recodes allow you to redefine the field so that only the occupat
Page: record
A single row of structured data. See also row.
Page: Record View
One of the key strengths of a SuperSTAR database is the inclusion of unit record data. The Record View feature lets you access the individual unit records that make up the values in the table. For example, if you have a cell with a count of five, you can
Page: Record View - SuperCROSS
One of the key strengths of a SuperSTAR database is the inclusion of unit record data. The Record View feature lets you access the individual unit records that make up the values in the table. For example, if you have a cell with a count of five, you can
Page: Record View - SuperWEB2
One of the key strengths of a SuperSTAR database is the inclusion of unit record data. The Record View feature lets you view and download the individual unit records that make up the values in the table. You might want to use this feature for auditing and
Page: reference
A column identifying a row in a different table. See also axis reference item and field reference item.
Page: Reference - SuperCHANNEL
This section contains a reference guide to various aspects of SuperCHANNEL.
Page: Reference - SuperCROSS
This section contains a reference guide to the SuperCROSS user interface.
Page: Registry Tables
Registry tables are an optional feature of SuperCHANNEL that you can use to simplify the process of designing target SuperSTAR databases. By creating registry tables in your source database, you can give SuperCHANNEL additional information about your sour
Page: registry tables (SuperCHANNEL)
Registry Tables
Page: Registry Tables in a TDD - SuperCHANNEL
Registry tables can be used to give SuperCHANNEL information about the design of the target database, such as which tables are fact tables, and which are classifications. When dealing with a TDD source, you can use all the same registry tables that you wo
Page: Related Record View - SuperCROSS
Like Record View, Related Record View lets you retrieve records. However, with Related Record View you retrieve records of only one record type at any one time. You can then view records, of another record type that are related to the records you have ret
Page: Relative Standard Error - Data Control
The Relative Standard Error (RSE) plugin allows you to show RSE figures in SuperWEB2 for weighted databases. Relative Standard Error Module SuperSERVER is supplied with a Data Control plugin called rsecalculationmodule.dll. This plugin calculates RSE valu
Page: Relative Standard Error - SuperWEB2
The Relative Standard Error (RSE) function lets you view the relative standard error figures for weighted databases. This information is only available if the SuperSERVER has been configured to support the RSE feature, and a Data Control API plugin has be
Page: Remove a Service - SuperSERVICE Manager
To remove a service using SuperSERVICE Manager: Go to the Windows Services console and stop the service if it is running. Services-Stop.png Start SuperSERVICE Manager (go to the Windows start menu and select All Programs > SuperSTAR > SuperSERVICE Manager
Page: Remove the Quantile Tab from the Range Dialog - SuperWEB2
By default, when you select Range for one of the summation options, SuperWEB2 displays the following dialog, which includes the Quantile tab: SuperWEB2(tm)-Quantile-Tab.png If you wish, you can configure SuperWEB2 so that it does not display the Quantile
Page: Rename a Group - SuperWEB2
To rename a custom group you have created: Select the My Custom Data tab. SW2-Edit-CustomData-1.png In the My Custom Data and Geography section, select the check box next to the group you want to rename. SW2-Edit-CustomData-2.png In the Rename field, ente
Page: replicate weight
Replicate weights are a series of variables that contain the information necessary for correctly computing (via the replicate weight method) the standard errors of point estimates when analyzing survey data. SuperSTAR supports replicate weighting function
Page: Resource Considerations - SuperCHANNEL
When updating large databases you need to consider the following issues: Consideration Details Memory You need to make sure there is enough memory available to avoid running out of memory. When using the 32 bit Java Virtual Machine, the maximum memory siz
Page: Reverse Channel from SXV4 Data Sources - SuperCHANNEL
You can use SuperCHANNEL to extract information from an SXV4 file and import the data back into a relational database system. Simply connect to the SXV4 as your source and the relational database as your target. This process is referred to as "reverse cha
Page: Revise an SXV4 - SuperCHANNEL
The Revise function allows you to update selected fact table records in your existing SXV4 database. For example, if your SXV4 contains details of your customers throughout Australia, but you have some updated customer data for all of your customers in th
Page: Right-Click Menu Options - SuperCHANNEL
The options on the right-click menu allow you to interact with the currently-selected item or items. The available options will change depending on what you clicked on. Source View Option Keyboard Shortcut Select To... Add Table Ctrl+A Add the currently s
Page: Right-Click Menu Options - SuperCROSS
This section describes the options available in the right-click menu when working with tables. The menu options are slightly different depending on whether you right-click on the table header, the row/column/wafer axes, the table data area, or the footnot
Page: RKey
A record key used as part of the perturbation confidentialisation process. Cubes created by the server for databases that have the perturbation confidentiality process enabled use the RKeys to generate a cell key for each cell in the cube. See also pertur
Page: Root (__SUPER_CHANNEL__ table) - Registry Table
The __SUPER_CHANNEL__ table is the root registry table. It tells SuperCHANNEL which tables are registry tables. This table is required in order to use registry tables in your source data. You must have a row in the root table for every registry table you
Page: row
In a database: a single row of structured data. In a table: a horizontal list of values displayed in a table. See also record.
Page: Row and Column Totals and Percentages - SuperCROSS
Totals There are a number of ways you can include row and column totals in a table: Feature Details Activate row/column totals Use the options on the Calculations menu to add automatic totals to your tables: Select Calculations > Grand Total to show a tot
Page: RowEntry
SuperCROSS Production System SuperWEB1 SuperWEB2 Element Format Description Save Load Load Save Load Save Load RowEntry RowEntryDefine RowBody RowEnd RowEntryDefine 'ROW' Yes Yes Yes Yes Yes Yes Yes RowBody (DimensionEntry)+ (DeriveEnt
Page: RSE file
Due to sampling errors, survey estimates produced do not reflect the overall population with 100% accuracy. The accuracy of any particular results can be determined by calculating the Relative Standard Error (RSE). SuperCROSS annotates estimates that fall
Page: RulesEngine.xml
Location <tomcat_home>\webapps\webapi\WEB-INF\data\.repository\RulesEngine.xml This file defines rules that control table creation. For example, you can use the rules to restrict the maximum number of cells in a table, or to specify mandatory fields that

S

Page: S
Page: sa2ps
The executable file for the Production System utility of SuperSERVER (including SuperADMIN). This utility is used in scripts for batch production of tables.
Page: Sample Code - Data Control API
The Data Control API is installed with SuperSERVER. The location will depend on where you chose to install SuperSERVER, but with the default installation location, the Data Control API files are located in C:\ProgramData\STR\SuperSERVER SA\etc The etc\dca
Page: Sample Downloads - Registry Tables
You can use the following files to create the registry tables in your source database. Source Type Description Download Link SQL Server Source The attached SQL file contains SQL DDL statements that will create the registry table structure in SQL Server, a
Page: SAR file
SuperSTAR Archive file. SXV4 databases can be packaged and compressed with metadata and TXDs etc into a SuperSTAR archive file (.SAR).
Page: Save and Load Recodes - SuperCROSS
Recodes allow you to redefine ("re-code") fields. Once you have created some recodes, you can save them to a file. This allows you to re-use them in future and use the same recodes with a different database. Although you can use the same recodes across mo
Page: Save and Reload Groups - SuperWEB2
You can save your custom groups to a file, and reload groups from a file. This allows you to share your custom group definitions with other SuperWEB2 users (users will only be able to upload your saved file if they have access to the same database as the
Page: Save and Reload Tables - SuperWEB2
You can save your tables inside SuperWEB2. Once saved, the table definitions will be available again the next time you log in to SuperWEB2. If you are logged in as a guest user, you will not be able to save tables. Save Tables Click the Save icon to save
Page: Save Dual Language Excel Files - SuperCROSS
If SuperCROSS is set up to support multiple languages, you can save a table to Excel with table and field titles in two languages. The first language selected in SuperCROSS will appear on the left side of the Excel output, with the second language appeari
Page: Saving - SuperCROSS
This section contains everything you need to know about saving data from SuperCROSS, including: Details of all the available output formats for saving tables. How to create a SuperSTAR archive file. This format packages the SXV4 database with its metadata
Page: Scaling Factor and Precision - Data Control
You can use the supplied scaling plugin, outputscaling.dll to set a scale value to be applied to each cell in the table. The scale factor will be applied to the cell values displayed in the client, as well as any downloaded data (including Excel, CSV and
Page: SCAM
Small Cell Adjustment Method
Page: SCS file
A SuperCROSS table saved in SuperCROSS format.
Page: scs.dat
The binary catalogue file used in SuperSERVER (Non SuperADMIN) to hold details of registered databases and users.
Page: SDMX - SuperCROSS
The SDMX (Statistical Data and Metadata eXchange) Technical Standards Version 2.0 format is a standard format for exchanging statistical information. SuperCROSS supports loading and saving in SDMX format. Limitations of Saving and Loading SDMX Files Only
Page: sdmx.config.xml
Summary Configures values that are included in SDMX downloads. You can save a SuperCROSS database to the SDMX (Statistical Data and Metadata eXchange) Technical Standards Version 2.0 generic format. There are two versions of SDMX downloads from SuperCROSS
Page: Section 508/Section 508 compliance
Section 508 refers to a US Federal agencies requirement that electronic and information technology is accessible to people with disabilities. For more information, see http://www.section508.gov/ http://www.section508.gov/ SuperWEB2 has a mode which is Sec
Page: segmentation
The process of identifying a subset of records using the underlying database cross-tabulation fields.
Page: Segmentation - SuperCROSS
Use the segmentation features to identify a subset of a population. You can then perform further analysis by focussing solely on this subset of records. There are two options for creating segments: Segmentation and Analyse Segment. Segmentation Use this f
Page: server
This command maintains the registered and available SuperSERVERs. Usage Description server Displays a list of available servers. server <id> Displays the properties and settings for the specified server. server servers Displays the settings for all config
Page: Set Data Cleansing Actions - SuperCHANNEL
Cleansing actions allow you to automatically clean up some of your source data when building your SXV4 database. Cleansing actions apply to columns that can only be one of a set of possible values. This includes: Classified columns - columns in fact table
Page: Set Precision for Summation Options - SuperWEB2
By default, SuperWEB2 displays values in tables as whole numbers (0 decimal places). The display precision is determined by the value of the dataprecision parameter in the CubeCatalog.xml configuration file. By default that parameter is set to 0, although
Page: Set Up Batch Processing - SuperCROSS
You can use SuperCROSS to carry out batch processing. When SuperCROSS is configured to use this mode, it acts like a server. It will regularly poll a specific directory (referred to as the "interchange directory") to check for any new TXD or SCS format fi
Page: Settings - Charts - SuperCROSS
Select View > Chart Settings to edit chart settings. The Chart Settings window displays. Chart-Settings.png The following settings are available: General Tab Setting Description Automatic Dialogs Select these options to automatically open the Chart Wizard
Page: Setup a Metadata Database - SuperWEB2
You can add metadata about databases, tables, and fields within tables to SuperWEB2. Once the metadata is set up, end users can click the links in the SuperWEB2 interface to read the additional information about the data they are working with. Metadata li
Page: Setup Static Metadata Pages - SuperWEB2
You can add metadata about databases, tables, and fields within tables to SuperWEB2. Once the metadata is set up, end users can click the links in the SuperWEB2 interface to read the additional information about the data they are working with. Metadata li
Page: Show or Hide the Customise Table Area - SuperWEB2
The Customise Table area is where you select the field values and summation options you want to use in your table: SW2-CustomiseTable.png Hide the Customise Table Area If you want to maximise the amount of available screen space for viewing your table, yo
Page: Silent Install and Uninstall - SuperCROSS
The installation package for SuperCROSS is built with Installshield, which supports "silent" installations. This feature makes it easy to deploy SuperCROSS throughout your installation: you simply run the install once, selecting all your preferred install
Page: Single Sign On with Kerberos
When an Active Directory authentication service has been configured, it is possible to enable single sign on for Windows users of SuperCROSS and the SuperADMIN console. This works by using Kerberos to automatically log in to SuperSTAR using credentials re
Page: SNU
SuperCHANNEL Command Line Utility See SuperCHANNEL Command Line Utility for more information.
Page: Sort Classification Tables - SuperCHANNEL
You can use a sort column, in conjunction with a SQL ORDER BY clause, to sort classification tables. If you do not configure any sorting, then by default classification tables will sort according to the index of the rows in the source database. For exampl
Page: Sort Tables - SuperCROSS
You can sort a table. For example: Unsorted Table (default): Table-Unsorted.png After sorting: Table-Sorted.png The following are some of the ways to sort a table: To... Do This... Sort based on the values in a column or row Right-click the column or row
Page: SortEntry
SuperCROSS Production System SuperWEB1 SuperWEB2 Element Format Description Save Load Load Save Load Save Load SortEntry SortEntryDefine SortBody SortEnd SortEntryDefine ('FIELD_SORT' | 'AXIS_SORT') Yes Yes Load fails. No Load fails. N
Page: Source View
The Source View in SuperCHANNEL shows the tables and columns in your source database. See User Interface - SuperCHANNEL for more information.
Page: spanner label
A label which spans multiple fields. For example, Sex may be a spanner label for Male and Female field items.
Page: Sparsity - Data Control
The SparsityCheck module prevents the release of tables that contain a high proportion of cells with very low values (0,1, or 2). It applies to interior cells only (totals are not included). If SparsityCheck is enabled, each cross-tabulation result is che
Page: Speed Up Loading of TXDs Containing Large Number of Recodes - SuperCROSS
If you make extensive use of TXD files and recodes, then you may wish to make a change to the SuperCROSS configuration that will improve performance when loading a TXD file containing a large number of recodes. By default, SuperCROSS uses a MAP statement
Page: SPS File Format - SuperCHANNEL
The following is an example of an SPS format file for a 6 question survey: DATA LIST FILE="C:\Data\SampleData.dat"/ V1 1 V2 2 V3 3 V4 4 V5 5 V6 6 . VARIABLE LABELS V1 'Q1 How often do you enjoy Coffee' V2 'Q2 How often do you enjoy Water' V3 'Q3 How often
Page: SRD file
SuperCUBE file format
Page: ss2mdtool
SuperSTAR command line utility for importing, exporting, or removing metadata in a metadata repository.
Page: ss2ps
The executable file for the Production System utility of SuperSERVER (non SuperADMIN). This utility is used in scripts for batch production of tables.
Page: ssii.ini
Summary Stores the SuperSTAR II catalogue settings for SXV4 databases. Default Location C:\ProgramData\STR\SuperCROSS\Catalogue [DBPath] This section stores the list of databases and tables in the Local Access section of the Catalogue, in the form: <datab
Page: Staging Databases
SuperCHANNEL can connect to a wide range of data storage facilities and Relational Database Management Systems (RDBMS). However, the original data source may not be ideal as direct input to SuperCHANNEL for a number of reasons: The data in the original da
Page: star schema
When designing a Data Warehouse to support OLAP and Decision Support Systems the preferred database table layout is referred to as a 'Star Schema'. This usually organises the database tables into one or more 'Fact' tables and a number of related 'Classifi
Page: Start SuperADMIN and SuperSERVER
Typically, you will want to start SuperADMIN and SuperSERVER using a Windows Service. This will ensure that both components start automatically when the machine starts. If you choose the Complete installation option, then the installation process will cre
Page: Statistical and Mathematical Functions for Derivations - SuperCROSS
The following is a list of all the statistical and mathematical functions available for derivations in SuperCROSS. The statistical functions compute various descriptive statistics for tabulation fields representing ranged (e.g. age) or bracketed (e.g. inc
Page: Statistical Disclosure Control (SDC)
Statistical agencies hold information about people and business. Statistical Disclosure Control protects the confidentiality of that information. See also confidentiality.
Page: SubjectEntry
SuperCROSS Production System SuperWEB1 SuperWEB2 Element Format Description Save Load Save to SCS Load Save Load Save Load SubjectEntry SubjectEntryDefine SubjectBody SubjectEnd SubjectEntryDefine 'SUBJECT' Yes Yes Yes Yes Yes Yes
Page: summary data
Aggregated data often referred to as a cube. Each cell in a cube contains counts of records and sometimes sums of measures. Also known as Aggregated Data or Macrodata.
Page: summation option
In SuperCROSS, a field containing a continuous set of numerical values, or a count. For example income, age, number of people. In SuperWEB2 a summation option is called a count. See also measure.
Page: Summation Options - SuperCROSS
The Summations Options control the numbers that are displayed in the table data area. Modifying the Summation Options will modify the numbers represented in the table. There are two types of summation options: Measures - columns in a database table that c
Page: Summation Options - SuperWEB2
In order to create a meaningful table, you need to measure something. For example, using the sample Retail Banking database, you can choose to measure a simple count of customers, or you can generate a table that calculates something more complex, such as
Page: super.ini
Summary Contains table manipulation and general program settings for SuperCROSS. Default Location C:\ProgramData\STR\SuperCROSS If you choose to edit any of the settings in this configuration file, then you must make sure you close SuperCROSS first. When
Page: SuperADMIN Console
The SuperADMIN console is the command-line application used to administer SuperSERVER. You can use the SuperADMIN console to: Create and manage user accounts. Configure the database catalogue (using the cat command). Control user and group access to datab
Page: SuperCatalogue.ini
Summary Stores the name of the default database set by the user in the SuperCROSS Catalogue. Users can specify a default database in the Catalogue by selecting the Select as Default check box. This database will be highlighted by default the next time the
Page: SuperCHANNEL
SuperCHANNEL.png SuperCHANNEL is the database import tool you will use for converting your data from the source database to the star-schema, column-oriented format used by SuperSTAR to provide its cross-tabulation speed (sxv4). SuperCHANNEL can import sou
Page: SuperCHANNEL Command Line Utility
SNU is the SuperCHANNEL command line utility. It allows you to build a SuperSTAR database from a command prompt or via a script. You cannot use SNU to design the SuperSTAR database. You need to do one of the following before you can run a build with SNU:
Page: SuperCROSS
SX-Overview.png SuperCROSS is the desktop client for the SuperSTAR platform. It has a powerful and intuitive drag-and-drop graphical interface that facilitates fast, flexible tabulation and analytics for information producers. SuperCROSS is an easy-to-use
Page: SuperCUBE
Table data can be saved in SuperCUBE .SRD file format and installed as SuperCUBE in SuperCROSS and SuperTABLE.
Page: SuperCUBE - SuperCROSS
Overview The SuperCUBE file format is a 'Summary Record Database' for distributing to other users of SuperCROSS and SuperTABLE. The other users do not need to access the original database in order to use your cube files. The cube will contain the subset o
Page: SuperModule.ini
Summary Stores details of the locations of various dynamic linked libraries (DLLs) used by SuperCROSS. Most of these settings should not be changed. Default Location C:\ProgramData\STR\SuperCROSS Some of the sections in the file include: [General] Defines
Page: SuperSERVER
SuperSTAR Database Server is the core of the system. It enables high-performance tabulation, and consists of several components collectively known as one product: SuperSERVER SuperSERVER is the SuperSTAR tabulation engine, and is the power behind the enti
Page: SuperSERVICE Manager
A Windows service is a process that runs in the background without requiring a user to be logged on. Since they run as background processes, services usually require no direct user interaction and can be set up so that they start automatically when the ma
Page: SuperSTAR
Overview - SuperSTAR Where To Next? Learn more about the SuperSTAR components and architecture. Read about what's new in SuperSTAR 8. Find out how to get started quickly and try out the software. Read the System Requirements.
Page: SuperSTAR Archive File Format - SuperCROSS
The SuperSTAR Archive File Format (.sar) packages the SXV4 database with its metadata and TXDs into a single archive format. This can then be provided to another user to open in SuperCROSS through the Local Access section of the database catalogue, or loa
Page: SuperSTAR I format
Previous versions of SuperSTAR database formats (sxv2 and sxv3), produced by SuperMART Builder and earlier utilities.
Page: SuperSTAR II format
The current SuperSTAR database format (sxv4), produced by SuperCHANNEL.
Page: SuperSTAR Server Outages - Job Queue Manager
Because the Job Queue Manager is a long running process and is reliant on the SuperSTAR platform, any downtime for those systems or the networks connecting them will interrupt the Job Queue Manager’s processing. Space-Time Research recommends stopping the
Page: SuperTABLE
SuperTABLE is a basic, unsupported, table reader component of the SuperSTAR suite. It is provided for public end-users of our customers (Australian Bureau of Statistics and NCVER) under license arrangements with these customers. SuperTABLE is provided for
Page: SuperWEB2
SuperWEB2-Overview.png SuperWEB2 is a browser based data analysis client that allows end users to create tabulations in their web browser. SuperWEB2 runs within a Java based web application container (Tomcat), and can use a RDBMS to store user saved tabl
Page: Supported Platforms - SuperCROSS
This section describes the Space-Time Research recommended system requirements for operating SuperCROSS, however you may use additional hardware. Generally greater hard disk capacity and random access memory (RAM) give better performance. Operating System
Page: Suppress Ability to Add Sum to a Table - SuperWEB2
In circumstances where perturbation is applied to a table, it may be possible to impute unperturbed values if an unperturbed measure such as mean is available in conjunction with the sum measure. To prevent this from happening, there is a configuration se
Page: swc, swconf, swconfiguration
This command manages the configuration properties for SuperWEB1. These configuration properties do not apply to SuperWEB2. swc, swconf and swconfiguration are the same command and can be used interchangeably. Overview The definitions are a set of configur
Page: SXV2 database
First generation SuperSTAR database format.
Page: SXV3 database
Second generation SuperSTAR database format created by the SuperMART Builder.
Page: SXV4 cube
SuperSTAR database format designed for aggregated data.
Page: SXV4 database
Third generation SuperSTAR database created by SuperCHANNEL.
Page: sxv4drv.conf
This configuration file contains setting for the SXV4 driver. It allows configuration of various cache settings and buffers used by the driver when inserting records into SXV4 target databases, as well as the type of index used, and the level of warnings

T

Page: T
Page: table
A SuperCROSS table can consist of three axes: rows columns wafers (or layers) An axis consists of one or more fields. Fields can be sub-nested or concatenated together.
Page: table annex
The Table Annex is a Microsoft Word rich text format (.RTF) document that embeds the table in SuperCROSS (.SCS) format. The document can then be printed with the table. The Table Annex option enables extra notes containing descriptions, qualifications and
Page: Table Series Generator (TSG)
A GUI-based utility to allow batch runs of multiple TXDs against multiple databases to produce tabular output in scs, csv, or Excel format.
Page: TABLE_LABEL - Registry Table
Use the TABLE_LABEL registry table to specify a display name (label) for a table. You can define labels for fact, plain and classification tables: Fact table labels will be displayed in the SuperSTAR clients. Although it is good practice to define meaning
Page: TableData.ini
Summary Stores database-specific table settings. This file must be named <database_id>_TableData.ini (where <database_id> is the ID of the database it relates to). Default Location The same directory as the database it relates to. For example: C:\ProgramD
Page: TableEntry
SuperCROSS Production System SuperWEB1 SuperWEB2 Element Format Save Load Load Save Load Save Load TableEntry TableEntryDefine TableBody TableEnd Yes Yes Yes Yes TableEntryDefine 'TABLE' Yes Yes Yes Yes Yes Yes TableBody {RowEntry} {ColEntry} {W
Page: tabulation
A process for aggregating data. See also cross-tabulation.
Page: Target Attributes - SuperCHANNEL
The Target Attributes pane allows you to change attributes for the columns and tables in the SuperSTAR database. To display the Target Attributes pane, click the icon on the toolbar: Attributes.png The attributes shown will depend on what is currently sel
Page: Target View
The Target View in SuperCHANNEL shows the current structure of your target SuperSTAR database. See User Interface - SuperCHANNEL for more information.
Page: Tau-ARGUS
Tau-ARGUS is a software program designed to protect statistical tables. It is one of the main results of the CASC-project. SuperCROSS integrates with Tau-ARGUS to provide disclosure control with automatic consequential suppression.
Page: TDD Control Files - SuperCHANNEL
The Space-Time Research Textual Data Definition (TDD) standard requires a set of seven control text files, which define the layout of information in the data files. All seven control files must be present for a valid TDD file, although some of the files m
Page: Test the Design with a Partial Build - SuperCHANNEL
If you have a very large database (in terms of the number of records in the fact tables), then you are recommended to test your database design before building the full target database. SuperCHANNEL allows you to run a partial build of your target databas
Page: Textual Data Definition Format - SuperCHANNEL
The Space-Time Research Textual Data Definition (TDD) standard allows you to create an SXV4 database based on data stored in text files, as opposed to connecting to a relational database. This can be useful in situations where data is not available in a d
Page: Textual Database Definition (TDD)
A set of files that together provide the information needed for SuperCHANNEL to relate data files in text format as a star schema.
Page: thematic map
A thematic map displays spatial pattern of a theme or series of attributes. For more information, see: http://en.wikipedia.org/wiki/Thematic_map http://en.wikipedia.org/wiki/Thematic_map
Page: Too Many Axis Items Warning - SuperCROSS
Sometimes when creating a table in SuperCROSS you may see an error message advising that there are too many axis items and that the number of cells has exceeded the maximum allowed in the table: Too-Many-Axis-Items.jpg Techniques for Avoiding this Warning
Page: TotalEntry
SuperCROSS Production System SuperWEB1 SuperWEB2 Element Format Description Save Load Load Save Load Save Load TotalEntry TotalEntryDefine TotalBody TotalEnd Yes Saving totals will result in all total items being added to the recode map, thus caus
Page: Trendlines - Charts - SuperCROSS
Trendlines allows simple linear and growth trend series to be created and displayed based on existing data. They are commonly used to study predictions (regression analysis) and can be used to indicate moving averages, where data fluctuations are smoothed
Page: Troubleshooting - Job Queue Manager
This section contains some troubleshooting information. If you see any of the following error messages in the ErrorDetails table in your database, follow the recommended steps to resolve the issue. Error Message Suggested Resolution Packets larger than ma
Page: Tutorial - SuperCHANNEL
If you are new to SuperCHANNEL, we recommend you start by following this tutorial. This will introduce some of the key concepts by taking you through the end-to-end process of converting data from a source format into SXV4. We have provided some sample so
Page: TXD
A .TXD file is a textual description of a SuperCROSS table. It is one of the SuperCROSS save options. Saved TXDs can be loaded into SuperCROSS and retabulated, and can be used for batch production of large numbers of tables.
Page: TXD Reference
A Textual Table Definition (TXD) file is a textual description of a SuperCROSS table; it is one of the SuperCROSS save options. Saved TXDs can be loaded into SuperWEB1, SuperWEB2 and SuperCROSS and retabulated, and can be used for batch production of larg
Page: type map
In SuperCHANNEL this is a list of logical connections between two data types. When the data is channelled, the type map is used to cast the source data type to the mapped target data type

U

Page: U
Page: UDFEntry
SuperCROSS Production System SuperWEB1 SuperWEB2 Element Format Description Save Load Load Save Load Save Load UDFEntry 'UDF' IdentifierString (MultiUDF | SingleUDF | RangeUDF | WeightUDF | MathUDF | ComparisonUDF | TimeUDF | QuantileUDF) UDFEnd Identif
Page: Uninstall - SuperCHANNEL
Uninstall SuperCHANNEL using the standard Windows Remove Programs functionality available from the Control Panel. Uninstalling SuperCHANNEL does not completely remove everything that was originally installed: Any project files or SuperCHANNEL configuratio
Page: Uninstall - SuperCROSS
Uninstall SuperCROSS using the standard Windows Remove Programs functionality available from the Control Panel. Uninstalling SuperCROSS does not completely remove everything that was originally installed: Any user-configurable SuperCROSS files that you ma
Page: Uninstall - SuperSERVER
Use the standard Windows Remove Programs functionality available from the Control Panel to uninstall SuperSERVER. If you have created a Windows Service for SuperSERVER that is not called SuperSTAR, then you must remove this through SuperSERVICE Manager be
Page: unit record data
Individual "fact" records. Sometimes referred to as micro data. Typical examples include data sourced from a transactional database or a survey such as a census. See also microdata.
Page: Unlock a User Account
To help protect your user accounts from unauthorised access, you can configure SuperADMIN to lock the account if the wrong password is entered more than a certain number of times. Configure Account Lock Settings Use the account command to configure the se
Page: Update an SXV4 - SuperCHANNEL
You can use the Update All and Update options to update an existing target SXV4 database that has been previously built and saved. For example, new monthly sales data or survey data can be added to existing databases without rebuilding the entire database
Page: Upgrade - SuperCROSS
This section describes how to upgrade SuperCROSS from a previous version of the software. To do this you need to remove the current installation first. If you require assistance with an upgrade contact support to find out about Space-Time Research's Upgra
Page: Upgrade - SuperSERVER
This section explains how to upgrade an existing installation of SuperSERVER to Release 8. SuperSERVER 8 requires a 64-bit operating system. These instructions apply to upgrades of the SuperADMIN (SA) versions of SuperSTAR (release 6.5 onwards) only. If y
Page: Upgrade - SuperWEB2
This section describes how to upgrade to the latest version of SuperWEB2 from an earlier installation. You must upgrade both SuperSERVER and SuperADMIN to 8.0 before performing the upgrade to SuperWEB2. Learn more about upgrading SuperSERVER. Step 1 - Bac
Page: Use Direct URLs to Open a Specific Database or Table - SuperWEB2
The standard way for a user to access SuperWEB2 is to start by loading the login screen, and then select the database or table they want to work with from the Data Catalogue. As an alternative, you can provide users with special URLs that take them direct
Page: Use the Sample Code to Test the Data Access API
Use the supplied sample code to test the API and verify that you have the JDK and Apache Ant set up correctly. Make sure SuperSTAR is running, and that the sample Retail Banking database is available on your system. Open a command prompt and navigate to t
Page: user
This command displays the name of the currently logged in user. Usage Description user Displays the currently logged in user.
Page: User Data Repository - SuperWEB2
The User Data Repository (UDR) is designed to allow SuperWEB2 users to save their own table design definitions so they can use them again the next time they login. The default installation of SuperWEB2 uses an embedded HyperSQL database to store the UDR,
Page: User Defined Fields (UDF)
Derived or synthetic fields created from existing fields within the database.
Page: User Defined Fields - SuperCROSS
User Defined Fields (UDFs) are new (synthetic) fields that you can create directly in SuperCROSS based on existing fields and measures. You can use UDFs to do things like: Compare two numeric fields. Perform calculations across several numeric fields. Ran
Page: User Guide - SuperCROSS
SuperCROSS is the desktop client for the SuperSTAR platform. This user guide explains everything you need to know to get the most out of the SuperCROSS client. What Can I Do With SuperCROSS? With SuperCROSS you can: Process large and complex micro (unit r
Page: User Guide - SuperWEB2
SuperWEB2 is a browser based client for the SuperSTAR platform. Once you have logged in, simply select the fields you are interested in and click the buttons to build your first table. Then you can run the query to get the data from the SuperSTAR database
Page: User Interface - SuperCHANNEL
When you first open SuperCHANNEL, it automatically opens a new blank project: SC-UI-Overview.png The two main areas of the SuperCHANNEL interface initially show the Source View and the Target View: The Source View is where your source database displays. T
Page: Users, Groups and Permissions
User access to the SuperSTAR software suite is managed by the SuperADMIN service. The SuperSTAR clients (Such as SuperCROSS and SuperWEB2) connect to SuperADMIN to authenticate users. SuperADMIN uses the typical system of Users and Groups of users to mana

V

Page: V
Page: Validate with Your Own Data - SuperSTAR
If you wish to use your own data to validate the installation, you can follow the steps in this section. These instructions describe how you can import data from an Excel spreadsheet or an Access database. Each set of instructions has a corresponding vide
Page: Validate Your Installation - SuperSTAR
This section describes how to use the SuperWEB2 client and the supplied sample data to validate a new installation of SuperSTAR Suite. We have provided a tutorial video to guide you through these steps. You may wish to watch the video first before trying
Page: value set
A finite set of discrete values, categories or classification items. For example a value set could be the possible values of a field such as Sex - Male or Female. A value set can be hierarchical.
Page: Verify - User Data Repository
When you have completed configuring your UDR database, the final step is to start Tomcat/SuperWEB2. This will create the empty tables in your UDR database. You can then test the connection by logging in and attempting to save a table. Login to SuperWEB2.
Page: vertical slice
A subset of data that includes only the fields of interest.
Page: View Records - SuperCROSS
To access Record View: Click a cell to highlight it. For performance reasons, you are recommended not to select a cell that contains a large number of values. Right-click the cell and select Records > View Records. AccessRecordVIEW.png If the options are

W

Page: W
Page: wafer
The third dimension in a table often referred to as a page or layer. Similar to a sheet in a spreadsheet. A useful area to store time periods or geographies.
Page: WaferEntry
SuperCROSS Production System SuperWEB1 SuperWEB2 Element Format Description Save Load Load Save Load Save Load WaferEntry WaferEntryDefine WaferBody WaferEnd WaferEntryDefine 'WAFER' Yes Yes Yes Yes Yes No No WaferBody (DimensionEntry)
Page: web.xml
Location <tomcat_home>\webapps\webapi\WEB-INF\web.xml The following are some of the parameters in this configuration file that you can change: Parameter Example Description More Information SessionUserAgentFilter SessionIPFilter <filter-mapping> <filter-n
Page: weighting
In order to reduce costs, statistical surveys typically assess a sample of the population rather than complete enumeration. Weighting is a technique used with sample surveys to provide estimated results for the total population from which the sample is dr
Page: Weighting - SuperCROSS
SuperCROSS can be used to tabulate against sample surveys where each record in the sample sur­vey has one or more associated weights. Population estimates are calculated by summing these weights, and estimates of means are also computed with these weights
Page: Weightings - Data Control
To configure the weighting of survey data results in SuperSERVER, you need to create the following two configuration files: The weighting configuration file, which defines the weighting parameters. The formula file, which defines the available functions.
Page: Weightings - SuperCROSS
SuperCROSS can be used to tabulate against sample surveys where each record in the sample survey has one or more associated weights. Population estimates are calculated by summing these weights, and estimates of means are also computed with these weights.
Page: Worked Examples - Reference Items - SuperCROSS
This section contains some worked examples of reference items in use. Please see the introduction to field/axis reference items before following the examples. Example Scenario The examples use the following base table, which shows Gender and Occupation by
Page: Working With Hierarchies - SuperWEB2
You may have fields in your database that have hierarchies. For example, in the sample Retail Banking database, the Area field contains a hierarchy of several levels, with states at the top level, down to post codes at the lowest level: SW2-Hierarchy.png
Page: Working With Tables - Totals, Percentages, Sorting and Codes - SuperWEB2
This section describes some of the options available when working with tables. It is assumed that you have already read guide to getting started and you know how to login to SuperWEB2 and create a basic table. Totals SuperWEB2 can automatically add totals

X

Page: X

Y

Page: Y

Z

Page: Z

!@#$

  • No labels