Australian Bureau of Statistics
Help: How do I manipulate data cubes with a SRD file extension?
Using the free SuperTABLE software, you can query and manipulate the large collections of ABS data and extract tables containing relevant information which are more suited to your requirements.
In a Quarterly Interstate Migration by State table, you can manipulate the fields in the rows, columns or wafer sections of the table screen area using drag and drop functionality.
You can also analyse the data using functions like the Recode to re-group a field or you can add a field derivation to calculate averages and sub-totals using derivation expressions.
The summary or report that you have created can now be saved in other useful file formats like XLS, WKS, TXT or CSV.
USE HIERARCHICAL DATA CUBES TO CREATE TABLES CONTAINING RELEVANT FIELDS
A hierarchical field contains multiple levels of aggregation.
NOTE: You have to include hierarchical fields in the table, atleast as a recode total to avoid double counting. For example, in the Sample 2 data cube, both the Division and Subdivision levels of the Industry field define the whole population. If you do not include the Industry field in the table, then the Division and Subdivision records of the data cube would be added together and the population would be counted twice.
The field 'Geographic Classification' is hierarchical because it contains the states and territories, statistical divisions, statistical sub-divisions and statistical local areas.
SUB-NEST A FIELD IN ANY OF THE THREE AXES OF THE TABLE
The table row, column or wafer can contain the 'Age Group' field as a sub-group within the 'Sex' field or alternately, the 'Sex' field can be a sub-group within the 'Age Group' field.
CREATE CONCATENATED FIELDS
You can place multiple fields side by side in one dimension field - grouping them as one.
Recode totals, recodes, summation options and fields from different hierarchy levels can be concatenated. Concatenated fields can be placed in the rows, columns or wafer sections of the table screen area.
RECODE OR RE-GROUP THE FIELD TO USER DEFINED VALUES
You can Recode the 'Age' field which contains the complete list of the different age groups and then analyse the data for a particular 'Age Group' category, say 'Age under 35'.
CHOOSE THE SUMMATION OPTIONS FOR A TABLE
The Summation Option field always includes 'Cells'. This is the number of records in the data cube for the combination of classifications that you are using.
In a Labour Force table, you can view an Employment Type field against a Time period. The default Summation Option is included automatically. You can view totals of this Summation Option cross-classified by these fields or you can Recode the Summation Option to view totals against selected options that you prefer.
You can perform calculations of totals, sub-totals, percentages and differences on table data. A derivation is a calculation created from a row, column or wafer dimension within a table.
Derivations are User defined and can be typed in from the keyboard or built using the buttons from the Values listbox.
A derivation expression could be: sum(V1:V2). Creating this expression and adding it to the table would result in a 'Total' field being added to the table for the values that V1 and V2 represent.
FORMAT AND EXPORT DATA IN FORMATS OTHER THAN SRD
ONLINE RESOURCES FOR USING SuperTABLE
For more detailed information on SuperTABLE, including an online tutorial and a user guide (requires Adobe Reader), you can visit Space-Time Research (link opens in a new window).
This page last updated 28 February 2013