Work with Pivot Grids in BeyondInsight

Using pivot grids, you can interact with multidimensional data from the BeyondInsight cube and can create custom views of the data. Pivot grids use standard analytical cube features:

  • Measures: Provide the calculated data values that you want to view.
  • Dimensions: Provide the filters, groups, and labels for the view.

Create a Pivot Grid

Using the measures and dimensions provided, you can build comprehensive pivot grid views to analyze your data.

  1. From the left menu in the BeyondInsight console, click Menu.
  2. Under Analytics & Reporting, click Pivot Grid.

Pivot Grid

  1. In the Configure panel under Filters, select a View, a Cube, and a Measure Group. You can perform a keyword search to find measures and attributes that contain specific words.
  2. Drag and drop measures and dimensions on indicated drop zones: Measure Fields, Column Fields, and Row Fields.
  3. Drag and drop multiple dimensions to enable more options that you can drill down through.

 

 

expand visible button
Collapse All button

  1. The available information populates the grid once the fields are selected. Use the Expand Visible and Collapse All buttons in the toolbar to show or hide all available data.

 

Clear pivot grid

  1. To completely clear the pivot grid and start over, click Clear Pivot Grid in the toolbar.

 

Pivot

  1. To pivot your data in the grid, click Pivot in the toolbar. This converts the rows to columns and the columns to rows.

 

Save Pivot Grid Views

Once you have created a pivot grid, you can save the selected filters, measures, and dimensions as a view for later use.

  1. In the pivot grid toolbar, click Save, and then select Save as View.

Screenshot of Save Pivot Grid As a View

  1. Enter a Name and Description.
  2. Select the appropriate group for Allowed Access.
  3. Choose whether other BeyondInsight users can see the saved pivot grid.
  4. Click Save As View.

 

Display pivot grid saved view

  1. Your saved view is now listed under Saved Views in the left panel. You can also search to find views that contain the keyword.
  2. Select the saved view, and then click Display Saved View to see the most current information for that pivot grid. The data is retrieved from the cube each time you select the saved view.
  3. To delete the saved view, click the Delete button.

 

Pivot grid filters closed

You can collapse and expand the Filters section of the Configure panel using the arrow. Each time you open a saved view, the Filters section is either closed or open, depending on its state when it was saved.

Save Data to a File

You can save the pivot grid data in JSON format and reload the data at a later time.

Pivot grid save as JSON

  1. In the toolbar, click Save, and then select Save as JSON.
  2. The file automatically saves to the default download location.

 

Import the JSON File

Pivot grid import icon

  1. In the toolbar, click Import.

 

Pivot grid upload

  1. Locate the JSON file from the download location and drag the file into the drop box. Alternatively, click within the drop box to open a file browser to navigate to the JSON file to upload it.
  2. Click Apply to Pivot Grid.

 

Display Data as a Chart

Once you have created a pivot grid, you can display the data as a chart.

Pivot grid display charts icon

  1. To display the data as a chart, click Display Charts in the toolbar, and then select a chart type from the menu. The following chart types are available:
    • Area
    • Category
    • Line
    • Spline
    • Spline Area
    • Step Area
    • Step Line
    • Waterfall
  2. The chart displays above the grid, showing data that is currently expanded in the pivot grid.

Chart legend

  1. Chart series data can be enabled or disabled by clicking the corresponding data in the legend.

If you save a pivot grid as a view while a chart is displayed, the chart is displayed each time the saved view is loaded.

 

  1. In the toolbar, click Save, and then select either Save Chart as PDF, Save Chart as PNG, or Save Chart as SVG.
  2. The file automatically saves to the default download location.

Create a Custom Report

Once you have created a pivot grid, you can create a report based on the fields selected in the grid.

  1. In the pivot grid toolbar, click Save, and then select Save as Report.

Pivot grid save report

  1. Enter a Name and Description.
  2. Select the appropriate group for Allowed Access.
  3. Optionally, select a Category.
  4. Click Publish as Report.

 

  1. The report is saved in the Custom folder on the All Reports page.

Example Measures in the Asset Cube

You can use the following table as a guide for commonly used measures in the Asset cube.

To filter on… Select this measure…
Inventory (rolling count) of discovered assets Measures > Asset Discovery - Snapshot
Inventory (rolling count) of open ports on assets. Can be used to find which ports are open on which machines Measures > Asset Port - Snapshot
Inventory (rolling count) of services on assets Measures > Asset Service - Snapshot
Inventory (rolling count) or shares on assets Measures > Asset Share - Snapshot
Inventory (rolling count) of software on assets Measures > Asset Software - Snapshot
Inventory (rolling count) of local user accounts on assets Measures > Asset User Account - Snapshot

Sample Usage Scenarios

Pivot grid filter fields

To see the count of assets:

  • In Measure Fields, place Measures > Asset Discovery - Snapshot.
  • In Row Fields, place Dimensions > Asset > Asset.Asset.

To see the count of user accounts on an asset:

  • In Measure Fields, place Measures > Asset User Account - Snapshot.
  • In Row Fields, place Dimensions > Asset User Account.
  • In Column Fields, place Dimensions > Asset.Asset.