MARKETPLACE
Expand Pivot on PDF
By Sisense
- Pivot
The Expand Pivot on PDF plugin exports all the pivot rows to PDF when you export the dashboard to PDF.
In the example below, the pivot widget is configured to present only the first 10 rows:
When the dashboard is exported to PDF, all the pivot rows are exported.
PDF without the Expand Pivot plugin:
PDF with the Expand Pivot plugin:
Installation
Windows
- Copy the installation package zip to a destination server.
- Extract the
Sisense.{addon-name}.zip
. - Go to folder
Sisense.{addon-name}.{version}scripts
. - Run script with one of the keys described below in the
Script Flags Description Windows
chapter.- For first time installation use
-i
flag. - For update installed add-on use
-u
flag. - For Multi-Node deployment one of key parameter
a<app> | q<query> | b<build>
] should be specified based on node type.
- For first time installation use
Script Flags Description Windows
- The script could be executed in two ways:
- To run the script command:
- right click on
w-addon-script.bat
andRun as Administrator
and follow the commands in the console. - run
cmd
asAdministrator
go to folder with script and runw-addon-script.bat <command>
<command>
– replace<command>
with one of the keys listed
from-h
command.
- right click on
- Show available commands:
-h
– shows a list of available command keys and their
description.
- Common commands:
-
-i
– install – [] – install add-on.- -r – remove – [] – remove add-on from the system.
Configuration in Mongodb and Configuration page will persist.
-
-u
– update – [] – update installed add-on by removing it and then installing a new version. Protected filesfolders will persist.- Protected files: “config.js” “config.6.js” “config.json”.
- Protected folders: “resources” Configuration in Mongo and Configuration page will persist.
-c
– check – [] – check if add-on components located in relevant places.- Parameter description:
s<single>
– single node installation, all components will be
installed. Default parameter if not specified.a<app>, q<query>, b<build>
– high availability installation, add-on components will be installed based on node type.
Linux
- If the server has the
unzip
tools installed, you can upload the archive and unzip it on the server, otherwise extract files on an external machine. - Connect to the server via SSH (
ssh username@serverip
). - Create the
addons
folder:mkdir ~/addons
- Upload files: 4.1. Using File Manager UI (go to
Admin/System Management/File Management
).- Create addons folder in the root using
File Manager
UI. - Upload add-on delivery package(zip or extracted) to the server using
File Management
in toaddons
folder. - Connect to the server via SSH (
ssh username@serverip
). - Copy files to home directory(need for HA installation). Script will copy all content of
File Management/addons
folder: kubectl cp sisense/$(kubectl get pods -n sisense -l 'app=management' | awk '/'management'/ {print $1;}'):"/opt/sisense/storage/addons" "./".
4.2. Using
scp command- For extracted folder:
scp -r /path/local/files {user}@0.0.0.0:~/addons
. - For archive:
scp /path/local/files {user}@0.0.0.0:~/addons
.
- Create addons folder in the root using
- Connect to the server via SSH (
ssh username@serverip
). - Navigate to the destination folder:
cd ~/addons
- If the delivery package is archived, extract it.
- Navigate to the
Sisense.{addon-name}.x.x.x/scripts
. - Run a script with one of the keys described below in the
Script Flags Description
chapter.- For the first-time installation use -i flag.
- To update the previously installed add-on use -u flag.
- All the needed pods will be restarted automatically. This may take a few minutes.
- Refresh your dashboard.
Script Flags Description
- To run script command use:
bash ./l-addon-script.sh {command-key}
– replace
{command-key}
with one of keys listed from-h
command.
- Show available commands:
bash ./l-addon-script.sh -h
– shows a list of available command keys and their description.
- Common commands:
bash ./l-addon-script.sh -i
– install add-on or rewrite existing add-on files.bash ./l-addon-script.sh -r
– remove add-on from the system. Configuration in Mongo and Configuration page will persist.bash ./l-addon-script.sh -u
– update the currently installed add-on by removing it and then installing a new version.
All needed pods will be restarted automatically. This may take a few minutes.
Notes
- Starts from Linux 2021.3 preferable to use new Export Engine V2.
Admin > System Management > Configuration > 5 clicks on Logo >
Base Configuration > enableexporting.engineV2.enabled
property
> clickSave Base
button - In order for the Pivot pages on the PDF to use the entire page height, pivot widgets should always be a single widget taking full page height on the pdf preview page. Use ‘Edit mode’ in the PDF-preview for resizing.
- The exported pivot will be scaled to the maximum page width if some
columns are not visible on the screen due to the wide widget. - The
Auto Height
option for Pivot2 widgets should be enabled. - For scheduled reports save the dashboard layout first.
- For the wide Pivots, preferable to use landscape format or bigger page size.
- The text will be moved to the next line in case the text string is too
wide.
Limitations
- The add-on is not affecting PDF preview.
- There should not be adjacent widgets in the same row with a pivot widget.
- The new export to PDF engine currently is not supported for Linux
version below L2021.3 and Windows.
This is a premium Sisense add-on. For pricing details please get in touch with your CSM
Version 1.1.11 – March 28, 2024
- Bug fix: unable to download dashboard to image
Version 1.1.10 – Sept. 18, 2023
- Added compatibility with the latest version of Sisense
Version 1.1.9 – July 19, 2023
- Bugfix: Fix expanded pivot scale on develop after product changes
Version 1.1.5 – Mar. 10, 2022
- Added support for L2022.3
Version 1.1.5 – Feb. 10, 2022
- Added support for L2022.2
- Installation steps have been changed to support installation with scripts
Version 1.1.5 – Jan. 20, 2022
- Added support for L2022.1
Version 1.1.5 – Dec. 09, 2021
- Added support for L2021.12.0
Version 1.1.5 – Nov. 01, 2021
- Added support for L2021.11.0
Version 1.1.5 – Oct. 15, 2021
- Added support for W2021.9
- Added fix for the issue with large paper sizes
Version 1.1.4 – Sept. 27, 2021
- Added support for L2021.10.0
Version 1.1.4 – Sept. 07, 2021
- Fixed issue with incorrect table size on second Pivot
Version 1.1.3 – Sept. 1, 2021
- Added support for L2021.9.0
- Fixed issue with incorrect table size on PDF
Version 1.1.2 – July 29, 2021
- Added support for L2021.7.0
Version 1.1.1 – July 13, 2021
- Fixed the issue when some data was placed in the wrong columns
- Added support for L2021.5.0 and W2021.6
Version 1.1.0 – July 09, 2021
- Support added for L2021.3.1, L2021.3.2
Version 1.0.9 – May 24, 2021
- Windows 2021.2, 2021.4 support was added
Version 1.0.9 – May 19 2021
- Removed … from the scaled text (Windows)
- Removed an empty column (Windows)
Version 1.0.8 – April 27, 2021
- Linux 2021.1.4 support was added
Version 1.0.6 – Dec. 22021
- Windows 8.2.5 support was added
- A border to the pivot was added on export to PDF
Version 1.0.4 – July 20 2020
- First release