• Print

The ROACA report is an annual report on the operation of the Aged Care Act 1997. To supplement the information in the report, the AIHW has developed a set of data cubes that provide additional and more detailed information. Three data cubes are currently available: The first contains information on the number of operational home care packages that were being provided as at 30 June 2015; the second information on operational residential care places as at 30 June 2015; and the third describes the number of people in permanent or respite care, and selected characteristics, at 30 June 2015.

These cubes draw data from the AIHW National Aged Care Data Clearinghouse, and additional to these basic counts, users can tabulate these data by particular state or territory or Aged Care Planning Regions (ACPR), by age, sex, Indigenous status, country of birth, provider type and program type.

Note that minor differences may exist between the data contained in the data cubes and that published in the ROACA report. While both sources derive from an administrative dataset used to manage aged care services in Australia, these data are subject to updates and minor corrections, which may result in differences between the two data sources over time.

Note: Cubes will open in new window.

How to use the ROACA data cubes

What is a cube?

A data cube is a multidimensional representation of data which provides fast retrieval and drill down facilities.

Using the cubes

When a data cube is opened default dimensions are shown. To view other dimensions right-click on the dimension you want to replace 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.

To add row totals and column totals or subtotals to the cube, right-click anywhere on the cube and select 'Total'. In the 'Insert' section of the dialogue box select the type of total to add and click 'Ok'. Please be aware that some data item measures will not add to a total. For example, the individual service group measures (accommodation support, community support, community access, employment and respite) may not add to the total number of service users (all service users) as a service user may use services from more than one service group during the year.

To hide dimensions right-click on the dimension name and select the 'Hide' menu item.

Extracting data from the cubes

The data can be exported to either Excel or Word. Right click the table area and select 'Export table' from the menu. Choose how many rows you want to export, and whether to export to Excel or Word or save as a tab or comma separated file. Give the file a name and save it in the directory of your choosing.