Data Cube Filters

Data cubes contain groups of data sets, some of which exist in multiple cubes. The data cube filters are common to all the data cubes and are explained in detail in the sections below.

Figure 1. Data Cube Filters

The data cube filters are explained in detail in the sections below.

Dimensions

Figure 2. Dimensions

Number 1 in Data Cube Filters. Lists industry standard details for Radio such as Time, AP name, System, and Zone name. You can use one or more dimensions to:

  • Filter - on one or more dimensions. The default dimension is Time.
  • Explore - on one or more dimensions. Every dimension used in Explore can be sorted by one or more selected measures, and the number to be listed in the table can be selected (5, 10, 25, 50, 100, 500 or 1000). You can also change the sorting order of the dimensions to be explored and pivot or change the hierarchy.
  • Pin - one or more dimensions on the Pinboard for easy reference.

You can use the scroll bar on the screen for each data cube to view the supported dimensions for that cube. The following table lists and describes all the dimensions that are supported on one or more data cubes in SCI:

Table 1. Dimensions
Dimension name Description Supported Data Cubes
Alarm Code Unique string assigned by the controller to an alarm. AP Alarms
Alarm State Indicates if the alarm is outstanding. AP Alarms
Alarm Type Description for access point and controller alarms. AP Alarms
Alarm UUID Unique string assigned by the controller to an alarm. AP Alarms
AP Description Description string of the access point that is configured in the controller.
  • Applications
  • Network
  • Airtime Utilization
  • Clients
  • Sessions
  • Events
  • AP Inventory
  • AP Alarms
  • Rogue AP
AP External IP External IP address of the access point.
  • Applications
  • Network
  • Airtime Utilization
  • Clients
  • Sessions
  • Events
  • AP Inventory
  • AP Alarms
  • Rogue AP
AP Group AP Groups configured in the controller.
  • Applications
  • Network
  • Airtime Utilization
  • Clients
  • Sessions
  • Events
  • AP Inventory
  • AP Alarms
  • Rogue AP
AP Internal IP Internal IP address of the access point.
  • Applications
  • Network
  • Airtime Utilization
  • Clients
  • Sessions
  • Events
  • AP Inventory
  • AP Alarms
  • Rogue AP
AP Latitude Latitude of GPS coordinates AP Inventory
AP Longitude Longitude of GPS coordinates AP Inventory
AP Location Location string of the access point that is configured in the controller.
  • Applications
  • Network
  • Airtime Utilization
  • Clients
  • Sessions
  • Events
  • AP Inventory
  • AP Alarms
  • Rogue AP
AP MAC Base MAC address of the access point.
  • Applications
  • Network
  • Airtime Utilization
  • Clients
  • Sessions
  • Events
  • AP Inventory
  • AP Alarms
  • Rogue AP
AP Model Description of the access point model type.
  • Applications
  • Network
  • Airtime Utilization
  • Clients
  • Sessions
  • Events
  • AP Inventory
  • AP Alarms
  • Rogue AP
AP Name Name of the access point configured in the controller.
  • Applications
  • Network
  • Airtime Utilization
  • Clients
  • Sessions
  • Events
  • AP Inventory
  • AP Alarms
  • Rogue AP
AP Serial Serial number of the access point.
  • Applications
  • Network
  • Airtime Utilization
  • Clients
  • Sessions
  • Events
  • AP Inventory
  • AP Alarms
  • Rogue AP
AP Version Firmware version number of the access point.
  • Applications
  • Network
  • Airtime Utilization
  • Clients
  • Sessions
  • Events
  • AP Inventory
  • AP Alarms
  • Rogue AP
Application Category Amount of user traffic by category Applications
Application Name Name of the application accessed by the WiFi client. Applications
Authentication Method The WiFi encryption and authentication method adopted.
  • Clients
  • Sessions
BSSID Basic service set identifier Network
Cable modem firmware Firmware version of the cable modem. AP Inventory
Cable modem IP IP address of the cable modem. AP Inventory
Cable modem MAC MAC address of the cable modem. AP Inventory
Category Category for access point and controller alarms or events.
  • Events
  • AP Alarms
Channel The WiFi channel number used.
  • Network
  • Clients
  • Sessions
Client IP Internal IP address of the WiFi client.
  • Clients
  • Sessions
Client MAC MAC address of the WiFi client.
  • Applications
  • Clients
  • Sessions
Client Radio Mode Possible values are: ac, n, a, g, b, or "unknown" (if SmartZone version is prior to 3.6).
  • Clients
  • Sessions
Connection Status Connection status of the access point: Online, Offline, Discovery, Provisioned.
  • AP Inventory
Controller MAC MAC address of the controller.
  • Applications
  • Network
  • Airtime Utilization
  • Clients
  • Sessions
  • Events
  • AP Inventory
  • AP Alarms
  • Controller Inventory
  • Rogue AP
Controller Model Description of the model of the controller.
  • Applications
  • Network
  • Airtime Utilization
  • Clients
  • Sessions
  • Events
  • AP Inventory
  • AP Alarms
  • Controller Inventory
  • Rogue AP
Controller Name Name of the configured controller.
  • Applications
  • Network
  • Airtime Utilization
  • Clients
  • Sessions
  • Events
  • AP Inventory
  • AP Alarms
  • Controller Inventory
  • Rogue AP
Controller Serial Serial number of the controller.
  • Applications
  • Network
  • Airtime Utilization
  • Clients
  • Sessions
  • Events
  • AP Inventory
  • AP Alarms
  • Controller Inventory
  • Rogue AP
Controller Version Firmware version number of the controller.
  • Applications
  • Network
  • Airtime Utilization
  • Clients
  • Sessions
  • Events
  • AP Inventory
  • AP Alarms
  • Controller Inventory
  • Rogue AP
Disconnect Time Disconnect time of a session. Sessions
Domain Domains configured in the controller.
  • Applications
  • Network
  • Airtime Utilization
  • Clients
  • Sessions
  • Events
  • AP Inventory
  • AP Alarms
  • Rogue AP
Event Code Code number for access point and controller events. Events
Event Type Description for access point and controller events. Events
First Connection First connection time of a session. Sessions
Hostname Hostname configured in the WiFi client.
  • Clients
  • Sessions
Last Status Change Date and time of the last change in Connection Status of the access point. AP Inventory
Manufacturer Manufacturer information for the WiFi client.
  • Clients
  • Sessions
OS Type OS information for the WiFi client.
  • Clients
  • Sessions
Port Port of the application accessed by the WiFi client. Applications
Radio Indicates the radio frequency band: 2.4GHz or 5GHz.
  • Applications
  • Network
  • Airtime Utilization
  • Clients
  • Sessions
Reason Additional description for access point and controller alarms or events, if available.
  • Events
  • AP Alarms
Roaming Session ID A unique session ID that is created when a client roams to multiple APs within a short-enough time span that the client is connected to these APs simultaneously.
  • Clients
  • Sessions
Rogue AP MAC MAC Address of the detected Rogue AP. Rogue AP
Rogue Channel The WiFi channel that the rogue AP was operating on. Rogue AP
Rogue Encryption The WiFi encryption and authentication method adopted by the rogue AP. Rogue AP
Rogue Radio The radio band (2.4GHz or 5GHz) that the rogue AP was operating on. Rogue AP
Rogue SSID SSID of the detected Rogue AP. Rogue AP
Rogue Type Possible types are: ignore, known, rogue, and malicious Rogue AP
Session ID ID string assigned to a session.
  • Clients
  • Sessions
Session Type Indicates whether the session is authorized or unauthorized.
  • Clients
  • Sessions
Severity Severity level for access point and controller alarms or events.
  • Events
  • AP Alarms
SSID Service set identifier (SSID) configured in the controller.
  • Applications
  • Network
  • Clients
  • Sessions
System System ID of the controller or the SmartZone Cluster.
  • Applications
  • Network
  • Airtime Utilization
  • Clients
  • Sessions
  • Events
  • AP Inventory
  • AP Alarms
  • Controller Inventory
  • Rogue AP
Time Allows the data to be viewed in terms of data points with timestamps. Time granularity of 1 minute, 15 minutes, 1 hour, 1 day and 1 week can be chosen.
  • Applications
  • Network
  • Airtime Utilization
  • Clients
  • Sessions
  • Events
  • AP Inventory
  • AP Alarms
  • Controller Inventory
  • Rogue AP
Username Username of the user account associated with the WiFi client.
  • Clients
  • Sessions
Zone Zones configured in the controller.
  • Applications
  • Network
  • Airtime Utilization
  • Clients
  • Sessions
  • Events
  • AP Inventory
  • AP Alarms
  • Rogue AP

Measures

Figure 3. Measures

Number 2 in Data Cube Filters with the drop-down list shown. Select one or more measures by which you want to sort the selected dimension.

Based on the selected cube, measures can vary.

You can use the drop-down lists on the screen for each data cube to view the supported measures for that cube. The following table lists and describes all the measures that are supported on one or more data cubes in SCI:

Note: For more information about traffic-related terms, refer to the Definition of Terms section.
Table 2. Measures
Measure name Description Supported Data Cubes
AP Count Unique number of access points.
  • Applications
  • Network
  • Airtime Utilization
  • Clients
  • Sessions
  • Events
  • AP Inventory
  • AP Alarms
AP Uptime Uptime percentage for an access point. AP Inventory
AP-to-SZ Ping Latency Average time, in milliseconds, for the AP to transmit a packet to the SZ controller, and receive the packet back. Network
Avg Airtime Busy Average of the airtime busy metric. Airtime Utilization
Avg Airtime Idle Average of the airtime idle metric. Airtime Utilization
Avg Airtime Rx Average of the airtime receive metric. Airtime Utilization
Avg Airtime Tx Average of the airtime transmit metric. Airtime Utilization
Avg Airtime Utilization Average of the total airtime utilization. Airtime Utilization
Avg CPU Utilization Average CPU utilization for the controller. Controller Inventory
Avg Disk Free Average free disk space for the controller. Controller Inventory
Avg Disk Utilization Average disk utilization for the controller. Controller Inventory
Avg Memory Utilization Average memory utilization for the controller. Controller Inventory
Avg Noise Floor Average noise floor power in dBm. Clients
Avg RSS Average received signal strength of the access point in dBm. Clients
Avg Session Duration Average time duration for a session. Sessions
Avg SNR Average signal to noise ratio at the access point in dB. Clients
Avg Throughput Estimate Average throughput estimate for the WiFi client.
  • Clients
Client Hostname
  • Clients
  • Sessions
Client MAC Count Unique number of WiFi clients.
  • Applications
  • Clients
  • Sessions
Client Username
  • Clients
  • Sessions
Count
  • Events
  • AP Alarms
Failed Associations Number of failed associations. Network
Failed Authentications Number of failed open authentications Network
Mgmt Traffic Traffic volume, which is transmitted and received in IEEE 802.11 control and management frames. This includes all unicast, multicast and broadcast traffic.
  • Network
  • Airtime Utilization
Max Offline Duration The maximum offline duration within the selected time range. AP Inventory
Max Rogue SNR The maximum detected SNR of the rogue AP. Rogue AP
Max RSS Maximum received signal strength of the access point in dBm. Clients
Max SNR Maximum signal to noise ratio at the access point in dB. Clients
Min RSS Minimum received signal strength of the access point in dBm. Clients
Min SNR Minimum signal to noise ratio at the access point in dB. Clients
Reboot Count Events
Roaming Session Count The number of roaming sessions for a specific client. A roaming session occurs when a client roams quickly enough to remain connected to multiple APs simultaneously. If you find a client that has a large number of roaming sessions, you can use various dimensions in Data Explorer to obtain details about the APs.
  • Clients
  • Sessions
Rogue AP Count The number of Rogue APs detected by all the APs in your network. Rogue AP
Rx Failures Receive packets which failed to be processed due to insufficient buffer in AP. Network
Rx Management Traffic volume, which is received by AP (Access Point) in IEEE 802.11 control and management frames. This includes all unicast, multicast and broadcast traffic.
  • Network
  • Airtime Utilization
Rx Total Sum of the Rx user and management traffic.
  • Network
  • Airtime Utilization
Rx User Traffic volume, which is received by AP (Access Point) in IEEE 802.11 MAC Service Data Unit (MSDU) data frames. This includes all unicast, multicast and broadcast traffic.
  • Applications
  • Network
  • Airtime Utilization
  • Clients
  • Sessions
Session Count Number of unique sessions.
  • Clients
  • Sessions
Successful Associations Number of successful associations. Network
Successful Authentications Number of successful open authentications Network
Successful Authentication Ratio Ratio of number of successful open authentications over total number of open authentications. Network
Total Data Frames Ratio Percentage of all Tx and Rx packets that are data. Network
Total Management Frames Ratio Percentage of all Tx and Rx packets that are management. Network
Total Traffic Sum of the user and management traffic.
  • Network
  • Airtime Utilization
TxBroadcastFrames Number of broadcast packets transmitted by the network. Network
TxDropDataFrames Tx data frames that are dropped by the message queue. Network
Tx Failures Transmit packets which failed to be processed due to insufficient buffer in AP. Network
Tx Management Traffic volume, which is transmitted by AP (Access Point) in IEEE 802.11 control and management frames. This includes all unicast, multicast and broadcast traffic.
  • Network
  • Airtime Utilization
TxMulticastFrames Number of multicast packets transmitted by the network. Network
Tx Total Sum of the Tx user and management traffic.
  • Network
  • Airtime Utilization
TxUnicastFrames The number of data packets transmitted by the network that are not broadcast or multicast packets.  Network
Tx User Traffic volume, which is transmitted by AP (Access Point) in IEEE 802.11 MAC Service Data Unit (MSDU) data frames. This includes all unicast, multicast and broadcast traffic.
  • Applications
  • Network
  • Airtime Utilization
  • Clients
  • Sessions
User Traffic Traffic volume, which is transmitted and received in IEEE 802.11 MAC Service Data Unit (MSDU) data frames. This includes all unicast, multicast and broadcast traffic. User Traffic = Rx User + Tx User
  • Applications
  • Network
  • Airtime Utilization
  • Clients
  • Sessions

Filter

Figure 4. Filter


Number 3 in Data Cube Filters. Segregates the data by dimensions such as Time Range, and other dimensions. You can filter on one or more dimensions, and change the sorting hierarchy as required. You can also define the dimensions based on specific properties of the dimension, for example, Time has relative and specific settings. The default dimension is Time, as the databases are very large and can crash the system without this filter.

Figure 5. Time - Relative Settings


You can specify the following:

  • Latest time of 1 hour, 6 hours, 1 day, 7 days, or 30 days.
  • Current time of day, week, month, quarter, or year.
  • Previous time of day, week, month, quarter, or year.
Figure 6. Time - Specific Settings

You can specify the start and end dates and times and click OK to save the details.

Figure 7. Dimension Options


You can search the list of the dimension and choose specific entries. By default all the data that matches the dimension is listed.

Explore

Figure 8. Explore


Number 4 in Data Cube Filters. Enables visualization based on dimensions and time (data granularity).

Figure 9. Explore Time


Use this filter to:

  • Set the data granularity to 1 minute, 5 minutes, 1 hour, 1 day, or 1 week.
  • Sort by any of the measures related to the dimension.
  • Limit the number of rows displayed for the dimension to 5, 10, 25, 50, 100, 500 or 1000.
Figure 10. Sort Dimension by Measure


Use this filter to:

  • Sort by any of the measures related to the dimension.
  • Limit the number of rows displayed for the dimension to 5, 10, 25, 50, 100, 500 or 1000.

You can explore on one or more dimensions using a methodology similar to pivot tables, and change the sorting hierarchy as required. You can define the number of rows to be listed on the screen.

View Outputs

Figure 11. View Outputs

Number 5 in Data Cube Filters. Create outputs from visualization in the forms shown above. The default view is Totals.

Add to Dashboard

Figure 12. Add to Dashboard

Number 6 in Data Cube Filters. Allows you to add a tile you are currently developing to an existing dashboard or to a dashboard that you want to create.

Share Link

Figure 13. Share Link

Number 7 in Data Cube Filters. You can share the URL, Export to various formats, View raw data, or download the information. The following figure shows the various formats you can choose for downloading data. You can also select the number of rows to download:

Figure 14. Selecting the Amount of Data to Download and the Desired Format

Options

Figure 15. Options

Number 8 in Data Cube Filters. Allows you to set the time zone as well as to perform the other functions shown.

Pinboard

Figure 16. Pinboard

Number 9 in Data Cube Filters. Click or drag dimensions and pin them on the pinboard. Retain the dimensions for ready reference during visualization.

Time Compares

The Time Compares feature allows you to compare the current data of specified dimensions and measures to the same dimensions and measures during previous time periods. An example is shown in the following figure, where the Controller Version dimension has been chosen along with the User Traffic measure. The Change column indicates how much user traffic has gone up or down for the corresponding controller version over the specified period of time. The method of specifying time periods is described later.

Figure 17. Time Compares
Creating a Data Comparison

The following procedure demonstrates how you can create a data comparison from scratch, using the figure above as an example:

  1. From Data Explorer, select one of the data cubes. (In the figure above, the Clients data cube is being used.)
  2. Drag one or more dimensions into the center pane. In the above example, Controller Version is the only dimension.
  3. From the Measure drop-down list, you can select one or more measure (use Multi-Selection for more than one). By default, User Traffic is already selected in this example.
  4. From the Measure drop-down list, select Compare:
    Figure 18. Selecting Compare from the Measure Drop-Down List
  5. If you have already invoked the Compare feature, the previous time period you selected is automatically used, and a display such as the one in Figure 17 appears. However, if you have not yet used Compare, or if you want to change the current time-period, invoke the Compare drop-down list:
    Figure 19. Using the Compare Drop-Down
  6. You can select one of the listed time periods or you can customize your choice.
  7. (Optional) To customize your choice, click Custom. The following pop-up appears:
    Figure 20. Custom Comparison Pop-Up Window
    • If you want to use one of the selections from the Relative tab, click the drop-down arrow to view the following possibilities:
      Figure 21. List of Choices from the Relative Drop-Down List

      You can also change the Number 1 to a different number to correspond to your choice in the drop-down list. Click OK to have this selection take effect.

    • If you want to create a custom time-period, click the Absolute Tab:
      Figure 22. Custom Comparison - Absolute Tab

      You can change the times as desired, as well as to have the end date automatically adjusted, then click OK for your choices to take effect.

Removing the Compare Feature

If you want to remove the Compare feature from the data display, go back to the Measure drop-down list, and select Remove Compare Measure, as shown in the following figure:

Figure 23. Removing the Compare Measure