Data cubes

About the cubes

A data cube is a multidimensional representation of the data set. It allows you to quickly select, filter and arrange aggregated data for variables of interest using drag and drop functionality. Data generated from these cubes can be exported into Excel, if you prefer this format for data analysis and reporting.

Period covered

The cubes cover the period 2003–04 to 2018–19.

Counting unit

The counting unit is a ‘closed treatment episode’. A closed treatment episode refers to a period of contact, with defined dates of commencement and cessation, between a client and a treatment agency. As a unit of measurement, the ‘closed treatment episode’ used in the AODTS NMDS cannot provide information on the number of clients who access publicly funded alcohol and other drug treatment, nor can it provide information on the extent of concurrent, sequential or recurrent service use.

Data items included in the data cubes

For a full list of the AODTS NMDS 2018–19 data items, and metadata about those items, download AODTS cube metadata

Exclusions to the collection

  • Agencies whose sole activity is to prescribe and/or dose for opioid pharmacotherapy maintenance treatment such as methadone.
  • Halfway houses and sobering-up shelters, correctional institutions, health promotion services (for example, needle and syringe exchange programs).
  • Alcohol and drug treatment units in acute care or psychiatric hospitals that only provide treatment to admitted patients.
  • Private treatment agencies that do not receive government funding.

It should also be noted that:

  • the number of Indigenous clients may be under-estimated as most Australian Government funded Indigenous substance-use services and Aboriginal health services that provide treatment for alcohol and other drug use do not supply data under the AODTS NMDS. In addition, at the national level a large percentage of clients did not state their Indigenous status (varying from 5% to 8% over time)
  • on their own, the data do not provide measures of the incidence or prevalence of non-prescribed use of, or dependence on, alcohol or other drugs in the community. This is because not all persons who have alcohol or other drug dependence seek treatment, or they may seek treatment from non-publicly funded services.

Additional information

Values and totals are suppressed in the ‘Closed treatment episodes: All clients profile by state/territory—no drug breakdown, 2018–19’ cube to remove data that are at risk of disclosing a client’s Indigenous status. Caution is therefore required when interpreting and reporting tables built from this cube that include the Indigenous status dimension as data may differ to that reported elsewhere.

Across all years, the following data items in the cubes have been collapsed for confidentiality reasons:

  • Method of use for principal drug of concern—Injects data has been collapsed into the Other category.
  • Source of referral for treatment—corrections, police and court diversion data have been collapsed into the Other category.
  • Reason for cessation of treatment—drug court, imprisoned and died have been collapsed into the Other category.

How do I use the cubes?

Data cubes allow the user to quickly select, filter and arrange aggregated data for variables of interest using the drag and drop functionality. Data generated from these cubes can be exported into Excel, if this format is preferred for data analysis and reporting.

When a data cube is opened, default dimensions are shown. To view other dimensions right-click on the dimension to be replaced and select the ‘Change’ item. For example, to replace sex with country of birth right-click on sex and select ‘Change Sex to’. Then select ‘Country of birth’ from the list.

If you wish to collate totals and present percentages, right-click on the table icon, where the data is displayed. This provides additional options for filtering the data. To hide dimensions right-click on the dimension name and select the ‘Hide’ menu item.

How do I export data from cubes?

The data can be exported to either to Excel or Word. Right-click the table area and select ‘Export table’ from the menu. Choose the number of rows you wish to export, and select either Excel or Word as your preference, or save as a tab or comma separated file. Name the file and save it in your preferred location.