Export Modifications

By Sisense

Overview
Technical Details
Pricing
Release Notes

The Export Modifications add-on enables you to change the style of exported Excel files and add additional information to export CSV and Excel files, such as the dashboard information.

Note: Export modifications are set from the Configuration Manager and apply to all users for all exports. A user cannot modify a specific Excel or CSV export.

Excel Modifications

Apply the following changes to Excel files:

Include dashboard information, such as dashboard date and last data update date
Cell content alignment
Include dashboard and widget filters
Insert an image - can be used to brand the Excel
Modify 'rows' columns to contain unmerged cells
Move the 'grand total' row to the top of the table
Make the 'grand total' row, 'grand total' columns
Make measures headers bold

CSV Modifications

Apply the following changes to CSV files:

Add filters below the widget data to CSV files

Screenshots

Dashboard Widget:

Export Modifications Off:

Export Modifications On (Report Tab):

Export Modifications On (Filters Tab):

CSV File:

Installation

The Export Modification add-on contains two components:

Windows service Sisense.ExportModifications
Client-Side plugin: exportModifications

To install the Export Modifications add-on:

Download the Export Modifications add-on.
Extract the .zip file.
Save the /Plugin/exportModifications folder in the plugins folder: C:\Program Files\Sisense\app\plugins.If the folder does not exist, create it.
Run the /Service/PSE.Sisense.ExportModifications.msi file.
Restart Sisense services:
1. Open the Configuration Manager from your browser at http://localhost:3030.
2. Click the Sisense logo five times to display the full list of service configurations on the left.
3. Click Restart Services.
Configure the Export Modifications add-on, as described below.
Refresh your dashboard.

Configure the Export Modifications

Open the Configuration Manager from your browser at http://localhost:3030.
Click the Sisense logo five times to display the full list of service configurations on the left.
Click the Export Modification tab.

Configuration options:

Alignment – Excel cell alignment.
1. alignmentNumber left/right/center. Alignment of number values.
2. alignmentText left/right/center. Alignment of text values.
General
1. configuredFilterTitle text. Specify the title of a dashboard filter to be presented on the first Excel tab.
2. enabledFilterSheet on/off. Includes an additional tab with the widget and dashboard filters.
3. enabledReportName on/off. When toggled on, an additional row with the widget name and the configuredFilterTitle is added to the first tab above the table.
4. grandTotalTop on/off. When toggled on, the grand total row is presented at the top of the table.
5. make font bold on/off. When toggled on, the column headers are bold.
6. minExcelColumnWidth number. Set the minimum width of Excel columns.
7. showFiltersOnCSV on/off. When toggled on, the dashboard and widget filters are included in the CSV file.
InsertImage – Can be used to brand the Excel and add a logo.
1. enabled on/off. When toggled on, the configured image is added to Excel.
2. imageHeight number
3. imagePath text
4. imageWidth number
NewTextLines – Additional information
1. dateFormat text. The format of the data date and the export date in the filters tab.
2. explanatoryText text. The text is added to all Excel files on the Filters tab.
3. newRowCharacter text. Character to split the explanatory text by.

This is a premium Sisense add-on. For pricing details please get in touch with your CSM: Get the Add-On

1.0.0.35 – 08 December 2020

First plugin release.

1.1.4 – 07 April 2021

Added support for 8.2.5, 2021.2, L8.2.6, L2021.1.3, L2021.3.1