meta data for this page

SharePoint Export Feature

Updated for N4V 2025.2.10

Description

  • Export the N4V FOR WEBI widget into HTML, PNG, and/or CSV format dynamically in Microsoft SharePoint
  • If you need to export the N4V FOR WEBI widget outside of Web Intelligence to give access the information to users that don't have an SAP BusinessObjects account, this feature will give you some great possibilities.

Prerequisites

The SharePoint Export feature is included in N4V FOR WEBI Platinum Edition and requires an additional license for Professional and Premium Editions. Contact your Need4Viz account executive to obtain a license key.

Once the key is enabled, your organization's SAP BusinessObjects/Need4Viz Administrator must perform configuration the N4V FOR WEBI server to configure the connection to your SharePoint instance (on-premise or online). Read the documentation provided with your key to configure the connection.

Server Configuration

Your Need4Viz Administrator must update the config.js file to activate the SharePoint export.

  • To enable the settings Export SharePoint in the chart, you need to set export_MSSP to “true”
  • If you need to use an external web server for the Need4Viz static files, you need to set the use_external_webapp_MSSP to “true” and define your external URL in the URL_PORT_WebApp_ext_MSSP variable

Parameters

HTML export

  • General
    • Automatically export the chart : Tick the box to export automatically the chart in HTML format each time it is refreshed
    • Root of the MS SharePoint site : Enter the root URL of your SharePoint instance. For example, enter “mydomain” if your SharePoint is accessible to 
      https://mydomain/site/my_sharepointsite
    • MS SharePoint export library : Enter the URL library (without the root path) to upload the exported html component. For example, enter “site/my_sharepointsite/my_lib” if your SharePoint is accessible to 
      https://mydomain/site/my_sharepointsite/my_lib/
    • Name of the generated target HTML file : Filename (specify the .html extension for onPremise SharePoint, .aspx for online SharePoint) that will be used to save the file.
    • Warning : the files uploaded to an onLine SharePoint instance need to be named with a .aspx extension (and not a .html extension).
    • Warning : for safety reasons, path and filename will be put in lowercase and accented characters will be replaced by unaccented and special characters will be replaced by '_'. These options can however be modified in the general configuration of N4V (ask your N4V administrator for the modification).
  • Navigation JS function in exported file
    • Use a custom JS function to navigate : Tick the box to enable navigation workflow in exported charts and define a custom JS function
    • Navigation function name : Name of the function that will be called during navigation. By default, the function name is “parent.click_link_ext”. You need to implement this function in the main html page that contains your iframed chart. This function will receive an array containing the selected item(s) in the N4V component.
    • Use a custom JS function to reset : Tick the box to enable reset workflow in exported charts (unselection of slice…) and define a custom JS function
    • Reset function name : Name of the function that will be called when unselection/reset. By default, the function name is “parent.click_linkres_ext”. You need to implement this function in the main html page that contains your iframed chart. This function will receive an array containing the unselected item(s) in the N4V component.
  • Change webapp URL
    • Replace N4VCustomElements webapp URL in the exported file : Check the box if you want the default exported URL calling N4VCustomElements webapp to be changed for your export
    • URL path of the webapp : If you have checked the previous box, fill here the replacement URL to do in the exported file.

PNG export

  • General
    • Automatically export the chart : Tick the box to export automatically the chart in PNG format each time it is refreshed
    • Root of the MS SharePoint site : Enter the root URL of your SharePoint instance. For example, enter “mydomain” if your SharePoint is accessible to 
      https://mydomain/site/my_sharepointsite
    • MS SharePoint export library : Enter the URL library (without the root path) to upload the exported html component. For example, enter “site/my_sharepointsite/my_lib” if your SharePoint is accessible to 
      https://mydomain/site/my_sharepointsite/my_lib/
    • Name of the generated target PNG file : Filename (specify the PNG extension) that will be used to save the file.
    • Warning : for safety reasons, path and filename will be put in lowercase and accented characters will be replaced by unaccented and special characters will be replaced by '_'. These options can however be modified in the general configuration of N4V (ask your N4V administrator for the modification).

CSV export

  • General
    • Automatically export the chart : Check the box to export automatically the chart in CSV format each time it is refreshed
    • Root of the MS SharePoint site : Enter the root URL of your SharePoint instance. For example, enter “mydomain” if your SharePoint is accessible to 
      https://mydomain/site/my_sharepointsite
    • MS SharePoint export library : Enter the URL library (without the root path) to upload the exported html component. For example, enter “site/my_sharepointsite/my_lib” if your SharePoint is accessible to 
      https://mydomain/site/my_sharepointsite/my_lib/
    • Name of the generated target CSV file : Filename (specify the .csv extension) that will be used to save the file.
    • Warning : for safety reasons, path and filename will be put in lowercase and accented characters will be replaced by unaccented and special characters will be replaced by '_'. These options can however be modified in the general configuration of N4V (ask your N4V administrator for the modification).
  • Format
    • Do not export header : Check the box to not export the header of data in the CSV file
    • Columns separator : The default columns separator is the comma, you can change it here
    • Text qualifier : You can enclose the text fields with a text qualifier defined here (for example : “)
    • Format: Choose the digital export format here (1234.56 or 1234.56)

Animations

  • The component will be exported in HTML with the same features (animation, hide series, etc…) it has in Web Intelligence.

KB articles to get more information :

  • Automate the Need4Viz HTML export / Use N4V Variables to generate dynamics path and filename : Here