f The 'cube' - Wiki

The 'cube'

From Wiki

(Difference between revisions)
Jump to: navigation, search
Line 28: Line 28:
As all the casualties in this cube are pedestrian casualties we don’t need to filter be casualty class here. By default, the dimension ‘Crash Year’ is added to the rows box. To filter the crash year we can either right-click on the dimension in the rows box or click on the small icon to the right of the dimension and click on ‘Edit’. Deselect all years using the icon that is second from left at the top and select only the years 2009, 2010, 2011, 2012 and 2013. Click 'OK'.
As all the casualties in this cube are pedestrian casualties we don’t need to filter be casualty class here. By default, the dimension ‘Crash Year’ is added to the rows box. To filter the crash year we can either right-click on the dimension in the rows box or click on the small icon to the right of the dimension and click on ‘Edit’. Deselect all years using the icon that is second from left at the top and select only the years 2009, 2010, 2011, 2012 and 2013. Click 'OK'.
-
We then drag the ‘Casualty Severity’ dimension to the columns box and ‘Crash Location’ to the slicer box. Right-click on the ‘Crash Location’ dimension, click edit, de-select all locations, select ‘U_Aberdeen’ by drilling down in to Scotland, R_Scotland, P_Grampian, G_ScotAber and checking the box next to ‘U_Aberdeen’. Click 'OK'. This produces the following table. Totals can be toggled on and off using the ‘Totals’ icon to the top left.
+
We then drag the ‘Casualty Severity’ dimension to the columns box and ‘Crash Location’ to the slicer box. Right-click on the ‘Crash Location’ dimension, click edit, de-select all locations, select ‘U_Aberdeen’ by drilling down in to Scotland, R_Scotland, P_Grampian, G_ScotAber and checking the box next to ‘U_Aberdeen’. Click 'OK'. Currently, the visualisation is a clustered bar chart but we want to show the casualty numbers in a stacked bar chart. To do this right-click on the chart and select 'Report Customization'. In the 'Show on' dropdown, select 'Stacked Bar Series' and click 'OK'. This produces the following chart.
-
Clicking on the 'Grid' tab above the rows box shows the same data but in grid format.
+
Clicking on the 'Grid' tab above the rows box shows the same data but in grid format. Totals can be toggled on and off using the ‘Totals’ icon to the top left.

Revision as of 14:18, 30 June 2015

Unfortunately, cube data isn’t currently available in the HTML version and is only accessible in Silverlight.

The four pages detailing the 'who', 'when', 'where' and 'how' dashboards show some of the most common analysis relating to casualties/drivers. However, if you require more detailed analysis using a range of dimensions, the cube contains cubed data similar to MAST. For those familiar with MAST the cube will be fairly self-explanatory although there are some differences. On navigating to the cube a report is produced, like the one shown in the image below. Each cube will only contain the data relevant to its dashboard, for example the child casualties cube will only contain child casualty numbers.

There are a series of dimensions on the left hand side of the page. These dimensions can be dragged on to the report. When dragging dimensions drag them on to the title of the box i.e. ‘Categorical (Dimension Rows)’.

Dimensions can be placed in the rows box on the bottom of the page (‘Categorical (Dimension Rows)’), the columns box to the lower right of the page (‘Grouping (Dimension Columns)’), or in the slicer box to the top of the page (‘Slicer’).

There are 2 tabs just above the rows box, where either the data grid view or the chart view can be selected.

To the top left of the page, just below the tabs, are seven icons:

The Totals icon allows the totals in the grid to be toggled on and off. By clicking on the down arrow on the right of the icon you can chose whether the totals are shown for the rows and/or columns axis.

By default only hierarchy members that have at least one value are shown in the grid. Clicking on the Empty icon shows all of the hierarchy members regardless of whether there are any related casualties.

The Paging icon changes the number of rows and/or columns that will be shown on each page. If there are more records than the number(s) entered a control will be visible to the bottom of the screen to move to the next page(s).

Transpose swaps over the row and column axes.

The Freeze icon freezes the grid/chart and will not change until the icon is unselected.

The Undo icon undoes any action in the cube and the Redo action redoes the action.

Example:

Below is an example of how to use the pedestrian casualties cube. We are going to use the dimensions in the list on the left to show child pedestrian KSI casualties in Aberdeen, by year, over the past 5 year period. As all the casualties in this cube are pedestrian casualties we don’t need to filter be casualty class here. By default, the dimension ‘Crash Year’ is added to the rows box. To filter the crash year we can either right-click on the dimension in the rows box or click on the small icon to the right of the dimension and click on ‘Edit’. Deselect all years using the icon that is second from left at the top and select only the years 2009, 2010, 2011, 2012 and 2013. Click 'OK'.

We then drag the ‘Casualty Severity’ dimension to the columns box and ‘Crash Location’ to the slicer box. Right-click on the ‘Crash Location’ dimension, click edit, de-select all locations, select ‘U_Aberdeen’ by drilling down in to Scotland, R_Scotland, P_Grampian, G_ScotAber and checking the box next to ‘U_Aberdeen’. Click 'OK'. Currently, the visualisation is a clustered bar chart but we want to show the casualty numbers in a stacked bar chart. To do this right-click on the chart and select 'Report Customization'. In the 'Show on' dropdown, select 'Stacked Bar Series' and click 'OK'. This produces the following chart.

Clicking on the 'Grid' tab above the rows box shows the same data but in grid format. Totals can be toggled on and off using the ‘Totals’ icon to the top left.

Personal tools