Export CMS (XLSX) Feature

Updated for N4V 2026.3.6

• Export the Need4Viz component dataset into an XLSX file loaded directly in the SAPBI CMS (set by your N4V administrator in the configuration of the N4V engine)
• If you need to export the dataset in an XLSX file (refreshed periodically) sourced by other Webi report, this feature will give you some great possibilities.

Ask your Need4Viz Administrator to set the configuration through the N4V Web Administration Console to activate the export CMS (XLSX).

• To enable the Export CMS settings in the chart, you need to set export_CMS to “true”
• Define the host CMS (DNS, protocol, port) in the configuration
• Set the SAPBI user used to export the XLSX in the CMS. The user must have enough rights to read/write into the destination folders (enterprise and/or personal folders)
• Set the password of the user through the N4V Web Admin Console, the password will be securely encrypted (it cannot be set manually in the config.js file without encryption)

• General
  • Automatically export the chart : Check the box to export automatically in the CMS the dataset in XLSX format each time it is refreshed
  • Name of the generated target XLSX file : Name of the destination file in the CMS. Do not use .xls/.xslx extension (it will be added by the engine)
  • Sheet name : Name of the sheet containing the dataset
  • Destination path : Fill here the complete path of the destination folder. Use “/” separator to indicate folders and sub folders.
  • Kind of folder : You can export the XLSX file in a Public (Enterprise) folder or in Personal folder. The user defined in the configuration of N4V engine must have permission to read/write in this folder
  • USer name of the personnal folder : If a personal folder has been selected, you must enter here the name of the SAPBI user (the XLSX file will be saved in its personal folder)