File Upload

The File Upload widget enables you to create or append a WhatIf scenario by uploading CSV files into the cube.

Configuring the widget

To turn on the File Upload widget, provide this code in the settings you register:

"accelerator_file-upload.server.whitelist": ["FRTB"],

To configure the widget, use the following settings:

"accelerator_file-upload.server.params": {
    FRTB: {
      groupSelectorEnabled: true,
      getFilePathsRestEndpoint:
        "/services/rest/whatif/fileUpload/retrieveStagedFile",
      sendFilePathsRestEndpoint: "/services/rest/whatif/fileUpload/upload/",
      successMessage: "What-if successfully triggered",
      initialPrompt:
        "Please select the topic you wish to contribute to your What-if",
      fileSelectorPlaceholder: "Select a File",
      uploadNamePlaceholder: "What-if Branch Name",
      stagingDirectoryName: "stage",
      filePathSpliterator: "\\",
      selectableDirectories: true,
    },
  },

Using the widget

To use File Upload:

  1. Add your files into the relevant directory in the stage folder. It is located in frtb-starter/src/test/resources/data/. The files you add here are then displayed in the File Upload widget.

  2. To launch the File Upload widget, from the top left menu, click Insert > Widgets. This opens the list of available widgets.

  3. From the list, drag and drop the File Upload widget to your dashboard.

Adding the File Upload Widget

  1. Click the dropdown to select from a list of topics which are configured and have available data. For details on how to configure the topics, see Configuring the widget.

File Upload topic Selector

  1. Next, select a file. Below the topic selector you can expand a directory structure containing the files available for the upload associated with the selected topic.

File Upload File Selector

  1. Once you’ve selected the required files, enter a name for your branch in the What-if Branch Name field, then click Click to Upload.

File Upload Branch Name

note

You can only create or modify a branch if you have the required permissions. By default, only the creator of the branch can modify it. For more information on What-If Branch Permissions, see WhatIf Changes.

This creates a branch with the given name or updates the existing branch with data from the uploaded files.

You can check and delete your branch in the What-If Manager:

File Upload Branch Name

For more information on using the WhatIf Manager, see WhatIf Manager.