Australian Bureau of Statistics

Rate the ABS website
ABS Home
Help: How do I manipulate data cubes with a SRD file extension?
 

SuperTABLE ENVIRONMENT
    For more information on downloading an ABS data cube with a SRD file extension see the Help on Download and Install SuperTABLE.

    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.

    Example:
    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.
    Image shows the Wafer, Row and Column sections of the table screen area
    Figure 1: Shows the Wafer, Row and Column sections of the table screen area and the drag and drop functionality from the 'Fields' dialogue box.
Back to top

USE HIERARCHICAL DATA CUBES TO CREATE TABLES CONTAINING RELEVANT FIELDS
    You can view the results of the table that you have created (SuperTABLE cross-tabulates or retrieves the data from the data cube to populate the table).
    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.

    Example:
    The field 'Geographic Classification' is hierarchical because it contains the states and territories, statistical divisions, statistical sub-divisions and statistical local areas.

    This image shows the Hierarchical Classification
    Figure 2: This image shows a Hierarchical Classification with multiple levels of aggregation.

Back to top


SUB-NEST A FIELD IN ANY OF THE THREE AXES OF THE TABLE
    You can place a field within another field under the rows or the columns or the wafer segment of the table screen area.

    Example:
    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.
    Image shows the 'Age Group' field sub-nested within the 'Sex' field.Image shows the 'Sex' field sub-nested within the 'Age Group' field.
    Figure 3: Image shows the 'Age Group' field sub-nested within the 'Sex' field.Figure 4: Image shows the 'Sex' field sub-nested within the 'Age Group' field.
Back to top

CREATE CONCATENATED FIELDS

    You can place multiple fields side by side in one dimension field - grouping them as one.

    Example:
    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.

    Image shows the 'Age' field concatenated withe the 'Sex' field.Image shows the sub-nesting of the 'Sex' field within the 'Age' field.
    Figure 5: Image shows the 'Age' field concatenated withe the 'Sex' field.Figure 6: Image shows the sub-nesting of the 'Sex' field within the 'Age' field.

Back to top

RECODE OR RE-GROUP THE FIELD TO USER DEFINED VALUES
    You can also analyse the data using the Recode function to re-group a field. It helps you to focus on the information that you need.

    Example:
    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'.
    Image shows the 'Age' field with a complete listing of age groups.Image shows the 'Age' field selected before Recoding.
    Figure 7: Image shows the 'Age' field with a complete listing of age groups.Figure 8: Image shows the 'Age' field selected before Recoding.
    Image shows the Define Recode dialogue box in which the age groups over 35 are removedImage shows the Recode Name and Recoded values before clicking on 'OK'.
    Figure 9: Image shows the Define Recode dialogue box in which the age groups over 35 are removed.Figure 10: Image shows the Recode Name and Recoded values before clicking on 'OK'.

    Image shows the Recoded 'Age under 35' Age field.
    Figure 11: Image shows the Recoded 'Age under 35' Age field.


Back to top

CHOOSE THE SUMMATION OPTIONS FOR A TABLE
    You can choose any of the Summation Options that are available for the data cube that you have downloaded or you may choose to retain the default Summation Options for that data cube. Double-click the Summation Option field to see what is available for that data cube. Summation Options are the 'counting items' in a data cube, the Summation Option field controls what is counted in 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.

    Example:
    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.

    Image shows the Labour force dataset without Summation Options
    Figure 12: Image shows the Labour force data cube with the default Summation Option Families ('000).



    Image shows the Labour force data cube with Summation Option field below the Time Period
    Figure 13: Image shows the Labour force data cube with Summation Option field below the Time Period.
Back to top


PERFORM DERIVATIONS

    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.

    Example:
    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.

    Image shows the context menu when you mouse right click on a table field
    Figure 14: Image shows the context menu when you right click on a table field to select a derivation function.

    Image shows the operators that you can use in a formula to calculate a derivation.
    Figure 15: Image shows the operators that you can use to create a derivation expression for a calculation.
Back to top


FORMAT AND EXPORT DATA IN FORMATS OTHER THAN SRD
    You can save the table in other file formats like: XLS, WKS, TXT, HTML etc. so that the data can be opened and viewed using other applications.
    Image shows a few of the file formats in which you can save a dataset
    Figure 10: Image shows a few of the file formats in which you can save a data cube table.
Back to top


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).

Back to top



      Bookmark and Share. Opens in a new window
© Commonwealth of Australia 2013

Unless otherwise noted, content on this website is licensed under a Creative Commons Attribution 2.5 Australia Licence together with any terms, conditions and exclusions as set out in the website Copyright notice. For permission to do anything beyond the scope of this licence and copyright terms contact us.