Data Explorer and Data Cubes

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

Data Exploration

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

Consider your data to be a three-dimensional cube that you would like to explore, both inside out and outside in, so that you can 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 multidimensional hypercube.

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 reviewing all the data of the last 30 days, you slice the data to expose only Day 1.
  2. Dice: Consider dicing a block of cheese; you make multiple cuts and separate the block into a number of smaller pieces. A typical dice operation involves taking a slice of data, such as the Day 1 data, and cutting it further to filter by the controller name and AP group. A smaller piece of the original OLAP cube results from the slice and dice operations.
  3. Dice: Consider dicing a block of cheese; you make multiple cuts and separate the block into a number of smaller pieces. A typical dice operation involves taking a slice of data, such as the Day 1 data, and cutting it further to filter by the venue name and AP group. A smaller piece of the original OLAP cube results from the slice and dice operations.
  4. Drill Up and Drill Down: In order to delve into the details, you can drill down to a specific AP in an AP group, and drill down further to a specific client host name. Conversely, you could search for a client MAC address and drill up to find the AP and controller to which it belongs.
  5. Drill Up and Drill Down: In order to delve into the details, you can drill down to a specific AP in an AP group, and drill down further to a specific client host name. Conversely, you could search for a client MAC address and drill up to find the AP and venue to which it belongs.
  6. Roll Up: The roll up operation typically involves numbers known as measures. After the slice, dice, and drill down of your data, you can roll up the numbers to gain a better understanding of the whole, for example, the total transmit traffic for the selected APs.
  7. Pivot: The pivot operation 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 the APs and the controllers to which they belong. Think of pivoting as changing the hierarchy between the dimensions.
  8. Pivot: The pivot operation allows you to view the data from a different perspective. Think of pivoting as changing the hierarchy between the dimensions.
As you use the custom reporting, you can refer to these five operations.
Data Explorer and Data Cubes

The top right corner of the Data Explorer page displays options to share and export dashboards in PDF and CSV formats. You can also share them with recipients over e-mails on-demand or periodically by configuring a schedule (daily, weekly and monthly).

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

Applications

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

Data Explorer: Applications

AP Airtime and Hardware

The AP Airtime and Hardware cube allows you to query, search and aggregate data related to the airtime utilization and CPU/memory/storage utilization of the APs.
Data Explorer: AP Airtime and Hardware

AP Wired Device

The AP Wired Device cube allows you to explore the AP wired clients in the system.

Data Explorer: AP Wired Device

AP Info and Statistics

The AP Info and Statistics cube allows you to explore network traffic data and its usage.

Data Explorer: AP Info and Statistics

Airtime Utilization

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

Data Explorer: Airtime Utilization

Client Info and Statistics

The Client Info and Statistics cube allows you to explore client data for your system.

Data Explorer: Client Info and Statistics

Client Sessions

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

Data Explorer: Client Sessions

Switch Inventory

The Switch Inventory cube allows you to view information about the switch configuration data your system uses.

Data Explorer: Switch Inventory

AP Events

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

Data Explorer: AP Events

Impacted Clients

The Impacted Clients cube allows you to view information about the clients impacted by the incidents.

Data Explorer: Impacted Clients

AP Inventory

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

Data Explorer: AP Inventory

AP Metrics

The AP Metrics cube allows you to view computed AP metrics (such as AP service downtime) in your system.
Data Explorer: AP Metrics

AP Connection Failures

The AP Connection Failures cube shows all the failures that have occurred in the AP or at any other level in the hierarchy of the AP.

Data Explorer: AP Connection Failures

Client Connection Counts

The Client Connection Counts cube shows all client connectivity events, including connectivity failures, client joins and client roams.

Data Explorer: Client Connection Counts

Client Connection Events

The Client Connection Events cube allows you to view any failure- and connection-related data for the client.

Data Explorer: Client Connection Events

Client Time to Connect

The Client Time to Connect cube gives information about the time to connect (TTC) the client to the network.

Data Explorer: Client Time to Connect

AP Alarms

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

Data Explorer: AP Alarms

Controller Inventory

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

Data Explorer: Controller Inventory

Controller Metrics

The Controller Metrics cube allows you to view the computed client metrics (such as client TTC) in your system.

Data Explorer: Controller Metrics

AP Rogues

The AP Rogues 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.

Data Explorer: AP Rogues

Switch Network

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

Data Explorer: Switch Network

AP Wi-Fi Calling

The AP Wi-Fi Calling cube allows you to view several Wi-Fi Calling KPIs such as the call duration, uplink and downlink bytes and so on.

The WiFi Calling cube allows you to view the metrics data for the Cloud controller.

Data Explorer: AP Wi-Fi Calling