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
  • Wifi-Calling
AP External IP External IP address of the access point.
  • Applications
  • Network
  • Airtime Utilization
  • Clients
  • Sessions
  • Events
  • AP Inventory
  • AP Alarms
  • Rogue AP
  • Wifi-Calling
AP Group AP Groups configured in the controller.
  • Applications
  • Network
  • Airtime Utilization
  • Clients
  • Sessions
  • Events
  • AP Inventory
  • AP Alarms
  • Rogue AP
  • Wifi-Calling
AP Internal IP Internal IP address of the access point.
  • Applications
  • Network
  • Airtime Utilization
  • Clients
  • Sessions
  • Events
  • AP Inventory
  • AP Alarms
  • Rogue AP
  • Wifi-Calling
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
  • Wifi-Calling
AP MAC Base MAC address of the access point.
  • Applications
  • Network
  • Airtime Utilization
  • Clients
  • Sessions
  • Events
  • AP Inventory
  • AP Alarms
  • Rogue AP
  • Wifi-Calling
AP Model Description of the access point model type.
  • Applications
  • Network
  • Airtime Utilization
  • Clients
  • Sessions
  • Events
  • AP Inventory
  • AP Alarms
  • Rogue AP
  • Wifi-Calling
AP Name Name of the access point configured in the controller.
  • Applications
  • Network
  • Airtime Utilization
  • Clients
  • Sessions
  • Events
  • AP Inventory
  • AP Alarms
  • Rogue AP
  • Wifi-Calling
AP Serial Serial number of the access point.
  • Applications
  • Network
  • Airtime Utilization
  • Clients
  • Sessions
  • Events
  • AP Inventory
  • AP Alarms
  • Rogue AP
  • Wifi-Calling
AP Version Firmware version number of the access point.
  • Applications
  • Network
  • Airtime Utilization
  • Clients
  • Sessions
  • Events
  • AP Inventory
  • AP Alarms
  • Rogue AP
  • Wifi-Calling
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

Event Category

Alarm 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
  • Wifi-Calling
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
  • Switch Inventory
  • Switch Network
  • Wifi-Calling
Controller Model Description of the model of the controller.
  • Applications
  • Network
  • Airtime Utilization
  • Clients
  • Sessions
  • Events
  • AP Inventory
  • AP Alarms
  • Controller Inventory
  • Rogue AP
  • Switch Inventory
  • Switch Network
  • Wifi-Calling
Controller Name Name of the configured controller.
  • Applications
  • Network
  • Airtime Utilization
  • Clients
  • Sessions
  • Events
  • AP Inventory
  • AP Alarms
  • Controller Inventory
  • Rogue AP
  • Switch Inventory
  • Switch Network
  • Wifi-Calling
Controller Serial Serial number of the controller.
  • Applications
  • Network
  • Airtime Utilization
  • Clients
  • Sessions
  • Events
  • AP Inventory
  • AP Alarms
  • Controller Inventory
  • Rogue AP
  • Switch Inventory
  • Switch Network
  • Wifi-Calling
Controller Version Firmware version number of the controller.
  • Applications
  • Network
  • Airtime Utilization
  • Clients
  • Sessions
  • Events
  • AP Inventory
  • AP Alarms
  • Controller Inventory
  • Rogue AP
  • Switch Inventory
  • Switch Network
  • Wifi-Calling
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
  • Switch Inventory
  • Switch Network
  • Wifi-Calling
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
FQDN of ePDG Fully qualified domain name of Evolved Packet Data Gateway. Wifi-Calling
Hostname Hostname configured in the WiFi client.
  • Clients
  • Sessions
Peer is Ruckus AP Indicates if the connected device on this port is a Ruckus AP. Switch Network
LAG Name Link aggregation name of the port. Switch Network
Last Status Change Date and time of the last change in Connection Status of the access point. AP Inventory
OS Manufacturer Manufacturer information for the WiFi client.
  • Clients
  • Sessions
Number of Ports The number of ports on the switch.
  • Switch Inventory
  • Switch Network
Operators WiFi operators. Wifi-Calling
Number of Switch Units The number of individual hardware switches (which may or may not be stacked).
  • Switch Inventory
  • Switch Network
Optics The optics, by Gbits per second, being used in the switch network. Switch Network
OS Type OS information for the WiFi client.
  • Clients
  • Sessions
Port Port of the application accessed by the WiFi client. Applications
Port MAC The MAC addresses of individual ports on a switch. Switch Network
Port Name All the port names being used in the switch network. Switch Network
Port Number All the port numbers being used in the switch network. Switch Network
Port Status The up/down operating status of the port. Switch Network
Port Link Status The up/down status of all port links in the switch network. Switch Network
Port Admin Status The admin-configured port status (up/down). Switch Network
Port Speed All the port speeds in use in the switch network. Switch Network
Port VLANs All the port VLans in use in the switch network. Switch Network
Radio Indicates the radio frequency band: 2.4GHz or 5GHz.
  • Applications
  • Network
  • Airtime Utilization
  • Clients
  • Sessions
  • Wifi-Calling

Event Reason

Alarm Reason

Additional description for access point and controller alarms or events, if available.
  • Events
  • AP Alarms
Remote Device Name The name of the device connected to the switch/port, as learned from LLDP. Switch Network
Remote Port Mac The MAC address of the device connected to the switch/port. Switch Network
Remote Port Type The functionality of the device connected to the switch/port, as learned from LLDP. Switch Network
Remote Port Description The description of the device connected to the switch/port, as learned from LLDP. Switch Network
Remote Port The port used by the remote device to connect to this switch/port, as learned from LLDP. Switch Network
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
Router ID The router IDs being used in the network.
  • Switch Inventory
  • Switch Network
Session ID ID string assigned to a session.
  • Clients
  • Sessions
Session Type Indicates whether the session is authorized or unauthorized.
  • Clients
  • Sessions

Event Severity

Alarm 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
  • Wifi-Calling
Switch Firmware Firmware versions being used by the switches in the network.
  • Switch Inventory
  • Switch Network
Switch Group Name Names of all the switch groups in the network.
  • Switch Inventory
  • Switch Network
Switch MAC MAC addresses of the switches in the network.
  • Switch Inventory
  • Switch Network
Switch Model Model numbers of the switches in the network.
  • Switch Inventory
  • Switch Network
Switch Name Names of the switches in the network.
  • Switch Inventory
  • Switch Network
Switch Serial Serial numbers of the switches in the network.
  • Switch Inventory
  • Switch Network
Switch Status Online/offline/flagged status of the switches in the network.
  • Switch Inventory
  • Switch Network
Switch Subgroup Name Names of the switch subgroups in the network.
  • Switch Inventory
  • Switch Network
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
  • Switch Inventory
  • Switch Network
  • Wifi-Calling
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
  • Switch Inventory
  • Switch Network
  • Wifi-Calling
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
  • Wifi-Calling

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
Call Duration Length of call to the nearest second. WiFi Calling
Client Hostname
  • Clients
  • Sessions
Client MAC Count Unique number of WiFi clients.
  • Applications
  • Clients
  • Sessions
Client Username
  • Clients
  • Sessions
Count
  • Events
  • AP Alarms
CPU (%) Percentage of CPU currently in use. Switch Inventory
Downlink Wifi-Calling Bytes Number of bytes being used only in the downlink communications of the wifi calling. WiFi-Calling
Failed Associations Number of failed associations. Network
Failed Authentications Number of failed open authentications Network
Mgmt Traffic (Total) 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
Memory (%) Percentage of memory currently in use. Switch Inventory
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
Offline Duration Duration given in milliseconds. Switch Inventory
PoE Utilization (%) Percentage of available power over Ethernet wattage being utilized. Switch Inventory
PoE Usage (mW) Power over Ethernet usage. Switch Inventory
PoE Free (mW) Available power over Ethernet not currently being used. Switch Inventory
PoE Total (mW) PoE usage plus PoE free. Switch Inventory
Port Count Number of ports for a given switch that are part of the corresponding dimension. Switch Network
Port PoE Utilization (%) Percentage of PoE used by a specific port out of the total of PoE being used by the switch at the specified time. Switch Network
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
AP Rx Failures Receive packets which failed to be processed due to insufficient buffer in AP. Network
Mgmt Traffic (Uplink) 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 Traffic Traffic received for each dimension measure. Switch Network
Traffic (Uplink) Sum of the User Traffic (Uplink) and management traffic.
  • Network
  • Airtime Utilization
User Traffic (Uplink) 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
Switch Count Number of switches for each corresponding dimension. Switch Inventory
Switch Unit Count Number of switch units for each corresponding dimension. Switch Network
Data Frame Ratio (Total) Percentage of all Tx and Rx packets that are data. Network
Mgmt Frame Ratio (Total) Percentage of all Tx and Rx packets that are management. Network
Traffic (Total) Sum of the user and management traffic.
  • Network
  • Airtime Utilization
  • Switch Network
Total Wifi-Calling Bytes Total number of downlink WiFi calling bytes plus uplink WiFi calling bytes. WiFi-Calling
Broadcast Frames (Downlink) Number of broadcast packets transmitted by the network. Network
Tx Client MCS Rate Client transmission data rate. Clients
AP Tx Dropped Data Frames Tx data frames that are dropped by the message queue. Network
AP Tx Failures Transmit packets which failed to be processed due to insufficient buffer in AP. Network
Mgmt Traffic (Downlink) 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
Multicast Frames (Downlink) Number of multicast packets transmitted by the network. Network
Traffic (Downlink) Sum of the User Traffic (Downlink) and management traffic.
  • Network
  • Airtime Utilization
Tx Traffic Traffic transmitted for each corresponding dimension. Switch Network
Unicast Frames (Downlink) The number of data packets transmitted by the network that are not broadcast or multicast packets.  Network
User Traffic (Downlink) 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
Uplink Wifi-Calling Bytes Number of bytes being used only in the uplink communications of the wifi calling. WiFi-Calling
User Traffic (Total) 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 (Total) = User Traffic (Uplink) + User Traffic (Downlink)
  • 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, or you can have the end date automatically adjusted to exactly one day later, 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