Data Analyzer

This is the N4V FOR WEBI Wiki page for the Data Analyzer (formerly Extended Pivot Table).

Updated for N4V 2025.1.9

A powerful component that presents information in a pivot table, a chart, or both simultaneously. Requires 2 dimensions and 1 measure with no limits. Possibility to dynamically arrange all the fields of the table, change the render of the pivot table, and change chart type. Interaction with pivot table automatically updates chart and vice versa.

• Present information in a pivot table.
• From 2 to unlimited dimensions and from 1 to unlimited measures.
• Ability to present data as a table, chart, or both at the same time
• Ability to change objects in columns/rows, render and calculations dynamically
• Ability to filter all the fields dynamically. All filters are applied to the table even if corresponding objects are not rendered in the table
• To be correctly interpreted, input dates must be string formatted as YYYY-MM-DD

• Dimensions 2 to unlimited : Choose here the dimensions to use in the table.
• Measures 1 to unlimited : Choose here the measures to use in the table.

• Play with objects on rows/columns
• Change the render of the chart (table, heatmap, charts…)
• Use the filters in each object to filter the values.
• Double click inside a cell to display the list of distinct values.

Within the component, a toolbar is available to fine-tune/configure the chart/table. Depending on the setting, the following buttons can be shown/hidden:

Buttons on the left

• Load: Replace the component data (from Web Intelligence) with data from an external file. This replacement does not affect the initial report (the data is only used in the user's browser; it is not saved in Web Intelligence).
  • CSV local: Load data from a CSV file stored locally on the user computer
  • Remote CSV: Load data from a CSV file stored remotely (provide a URL to retrieve the file)
  • JSON local: Load data from a JSON file stored locally on the user computer
  • Remote JSON: Load data from a remotely stored JSON file (provide a URL to retrieve the file)

• Download: Save the rendering of the component locally on the user's device. For reasons of Web Intelligence constraints, the download is not available from Web Intelligence, it is operational when the component is exported in HTML and used in an extranet (for instance).
  • Print: Printing of the component
  • In HTML: Saving the component in HTML format
  • In CSV: Saving the component in CSV format
  • In EXCEL: Saving the component in XLSX format
  • In PDF: Saving the component in PDF format

• Fold / Unfold: Allows you to fold or unfold all the groupings in the table and the chart
• Grid: Display only the pivot table
• Charts: Allows you to display only a chart (choose from the list of Column, Bar, Line, Scatter, Pie, Stacked Column, or combined Column/Line)
• Combo: Allows simultaneous display of the table and the chart. The position of the chart can be modified according to the option chosen in the list
• Send: Allows to send the data to the server (writeback mode). You can also add an empty row to the grid (to send more data in the destination)

Buttons on the right

• Filters :
  • Reset filters : Allows you to reset all the filters applied to the component (on the graphic and/or table part)
  • Apply a filter : Allows you to open the filter panel of a specified object

• Format:
  • Data mapping : Allows you to change the type of an object. A text field can thus be modified to numeric or date (standard date, formatted date - Date formats available here - hierarchies)
  • Name mapping : Allows you to rename an object
  • Format cells: Format a specific measure (alignment, thousand and decimal separators, unit…)
  • Conditional formatting: Apply conditional formatting on a specific measure value

• Options:
  • Layout: Allows you to change the layout of the table (compact form pivot table, classic form pivot table, or flat form) and whether or not to display the subtotals and grand totals.
  • Export settings: Allows export all of the component settings so that you can save them in Web Intelligence (Extended settings / Config_extended) so that the component is presented as is to all subsequent users of the report.
  • Reinit settings: Allows a reset of the report settings (clearing of the cache of the user's browser when he has modified the initial display of the component). When a modification of the settings is made at the level of the “extended parameters” and the option “Do not store the component format” is unchecked, it is necessary to click on “Reset settings” to see the application of the modification.

• Fields: Allows you to modify the layout of the columns/rows/measurements of the table and the chart.

• Data: Allows component data to be displayed via the N4V data table popup.

• Fullscreen: Allows the component to be displayed in full screen.

Here you can find instructions for accessing settings for Need4viz graphics: Format Custom Element.

For the pivot table, the available parameters are :

Extended parameters

• Global → See the user guide for the “Global” section here

• Options
  • Theme of the component : This parameter lets you choose a general theme (style) for the component.
  • Toolbar : Here you can set which buttons to show or hide in the toolbar.
  • Fields button : You can hide the “fields” management icon on the table.
  • Grid options : You can disable the edition mode of the cell (users will not be able to update the values in the cells). You can also hide the numbers of rows/columns, the headers of rows/columns, the filters zone and the empty grid lines. The long text can be wrapped.
  • Storage : This parameter is used to not store the component formatting modifications performed by the user in the user's browser session. When a modification of the settings is made at the level of the “extended parameters” and the option “Do not store the component format” is unchecked, it is necessary to click on “Reset settings” to see the application of the modification.

• Charts_X_Axis
  • Title & Labels : Set here the font and the display of the title & labels of the axis
  • Axis style : Set here the style of the axis line
  • Grids : Set here thickness and color of grid lines

• Charts_Y_Axis
  • Title & Labels : Set here the font and the display of the title & labels of the axis
  • Axis style : Set here the style of the axis line
  • Grids : Set here thickness and color of grid lines

• Charts_Options
  • Display : Display or hide here the measures and filters list of values on top of the charts
  • Legend : Hide the legend and change the font of it
  • Drill mode : By default, all values are expanded when drilling in the dimensions. You can set here the fact to only display the level you drill in.
  • Labels : Display or hide the labels and set the font of labels here.

• Measures
  • General measures format : This setting allows you to define the precision and unit of measure in the table (only one unit can be applied to the all table). Finer formatting (per measure) can be done within the component. The measurement display format (standard - e.g.: 2,345.67, compact - e.g.: 2.3K or compact long - e.g.: 2.3 thousand) can also be defined.
  • Aggregation labels : Hide here the aggregation kind in the labels of measures
  • Null values : You can manage null values here (show them, hide them, on rows or columns).

• Init_config
  • Objects index to display initially on rows : By default, the first dimension is displayed as row in the table. You can set here the index of objects to initially set as rows.
  • Objects index to display initially on columns : By default, the second dimension is displayed as column in the table. You can set here the index of objects to initially set as columns.column
  • Object index to display initially in calculation : By default, the first measure is chosen as calculation in the table. You can set here the index of measure to initially choose.
  • Layout options : Configure here the default layout of the grid chart.

• Extended_Config
  • Paste here the parameters exported of the chart: Once the component has been modified (style, filters, layout…), you can retrieve the global formatting of the component in the toolbar (Options/Export parameters). Copy the content of the popup that is displayed and paste the value here. Your changes will then be saved in Web Intelligence and will benefit all users of your report.

• Send_data : Writeback mode to send data from Web Intelligence to a CSV file on the server. A JSP sample is provided with N4V web deployment. You can use this model to write your own process engine to receive data and write them in a database, Google Drive or anything else you need.
  • Toolbar : You can display here the “Send data” button and an optional “Add” button to insert a new empty row at the end of the grid. Labels of buttons can be changed.
  • Configuration of export data to server : Set here the writeback process. Enter the URL of the JSP to call to perform the receiving/writing data on the server. Set the Folder name where the csv file should be written. Then enter the object name containing the filename (without “[]”) or directly a filename.

Export Server → See the user guide for the “Export Server” section here

Export FTP → See the user guide for the “Export FTP” section here

Export SharePoint → See the user guide for the “Export Microsoft SharePoint” section here