Data Explorer and Data Cubes

The Data Explorer and its individual cubes allows you to view, filter, and manipulate data in many different ways.

Data Exploration

Data exploration is the act of exploring the minute details of an OnLine Analytical Processing (OLAP) cube.

Consider your data to be a three-dimensional cube which you would like to explore, both inside out and outside in, so that you could glean more insights from your data. Of course, most real world data sets will have more than three dimensions, but the concepts from a 3D cube can be directly extended to a multi-dimensional hyper-cube.

With an OLAP cube, there are five operations that you can perform:
  1. Slice: Think of slicing a piece of cheese – you make a single cut to the cheese to expose the insides. A typical slice operation is the time slice. Instead of looking at all the data from Day 1, you slice the data to just the last 30 days.
  2. Dice: Think of dicing a piece of cheese – you make multiple cuts and mash the cheese into much smaller pieces. A typical dice operation is after slicing the cube to just the last 30 days, you “cut” it further by filtering by the controller name and AP group. After the above slice and dice is a smaller piece of the original OLAP cube.
  3. Drill Up/Down: In order to delve into the details, you drill down into a specific AP in the above AP Group, and further drilling down to a specific client hostname. Conversely, you could also search for client MAC in the beginning and drill up to see which AP and controller it belongs to.
  4. Roll Up: This operation typically involves certain numbers, also known as measures which will be explained in detail below. In short, after doing your slice, dice and drill down, you would like to “roll up” the numbers to find out the total transmit traffic for the selected APs.
  5. Pivot: Pivot is simply an operation that allows you to view the data from a different perspective. For example, you have a table showing a list of controllers and the APs belonging to each controller. You may pivot the table to show a list of APs and the controllers they belong to. Think of pivoting as changing the hierarchy between the dimensions.
Thus, as you use the custom reporting, refer to these five operations.
Figure 1. Data Explorer and Data Cubes

The Data Explorer allows you to explore the data under various categories, using your own permutations and combinations, unlike the other canned reports available.

Note: The Schedule tab is for use only with dashboards you create, not with data cubes themselves.
For information on how to use data cube filters, which are common to all the data cubes, refer to Data Cube Filters. You can also create and save dashboards, which allow you to customize reports by using data from any or all of the data cubes. Refer to Creating a Data Explorer Dashboard and Actions You Can Perform on an Existing Dashboard for more information.

Following are the available data cubes:

Applications

The Applications cube allows you to explore the application data your system uses.

Figure 2. Data Explorer - Applications

Network

The Network cube allows you to explore network traffic data and its usage.

Figure 3. Data Explorer - Network

Airtime Utilization

The Airtime Utilization cube allows you to explore the airtime utilization data in your system.

Figure 4. Data Explorer - Airtime Utilization

Clients

The Clients cube allows you to explore client data for your system.

Figure 5. Data Explorer - Clients

Sessions

The Sessions cube allows you to explore data about the various sessions in your system.

Figure 6. Data Explorer - Sessions

Events

The Events cube allows you to view data about events that have occurred in your system.

Figure 7. Data Explorer - Events

AP Inventory

The AP Inventory cube allows you to view information about the various AP models your system uses.

Figure 8. AP Inventory

AP Alarms

The AP Alarms cube allows you to view information about alarms in your system.

Figure 9. AP Alarms

Controller Inventory

The Controller Inventory cube allows you to view CPU, memory, and disk utilization for the controllers in the system.

Figure 10. Controller Inventory

Rogue APs

The Rogue APs cube allows you to view information about APs that have been flagged as "Rogue" because they cannot be identified by existing APs in your system.

Figure 11. Rogue APs