Expand Pivot on PDF

Installation

Windows

1. Copy the installation package zip to a destination server.
2. Extract the Sisense.{addon-name}.zip.
3. Go to folder Sisense.{addon-name}.{version}scripts.
4. 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.

Script Flags Description Windows

1. The script could be executed in two ways:
2. To run the script command:
   • right click on w-addon-script.bat and Run as Administrator
     and follow the commands in the console.
   • run cmd as Administrator go to folder with script and run w-addon-script.bat <command>
   • <command> – replace <command> with one of the keys listed
     from -h command.
3. Show available commands:
   • -h – shows a list of available command keys and their
     description.
4. Common commands:
   • • -i – install – [] – install add-on.
     • -r – remove – [] – remove add-on from the system.

   Configuration in Mongodb and Configuration page will persist.

5. -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.
6. -c – check – [] – check if add-on components located in relevant places.
7. 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

1. 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.
2. Connect to the server via SSH (ssh username@serverip).
3. Create the addons folder:
   • mkdir ~/addons
4. 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 to addons 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.
5. Connect to the server via SSH (ssh username@serverip).
6. Navigate to the destination folder:
   • cd ~/addons
7. If the delivery package is archived, extract it.
8. Navigate to the Sisense.{addon-name}.x.x.x/scripts.
9. 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.
10. All the needed pods will be restarted automatically. This may take a few minutes.
11. Refresh your dashboard.

Script Flags Description

1. To run script command use:
   • bash ./l-addon-script.sh {command-key} – replace
     {command-key} with one of keys listed from -h command.
2. Show available commands:
   • bash ./l-addon-script.sh -h – shows a list of available command keys and their description.
3. 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 > enable exporting.engineV2.enabled property
  > click Save 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

1. The add-on is not affecting PDF preview.
2. There should not be adjacent widgets in the same row with a pivot widget.
3. 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