Republishing imported data

Once you have published an Intelligent Cube using imported data, you can republish the Intelligent Cube using data from the same type of data source. This allows you to update a published Intelligent Cube with your most recent data.

You can republish an Intelligent Cube by clicking the name of the Intelligent Cube in Web. If the original data source of the Intelligent Cube was a Freeform script, a file from a URL or UNC path, or a Salesforce.com report, Web attempts to automatically republish the Intelligent Cube with new data from the same data source. If the original data source was a file uploaded from your computer, you must reupload the file. However, you can avoid having to reupload files stored on your computer by specifying the locations of files as a UNC path instead. For details, see Importing data from a file.

You can specify whether your imported data is replaced or updated when the Intelligent Cube is republished by selecting incremental refresh options. For steps, see Specifying incremental refresh options for an Intelligent Cube.

Prerequisite

To republish imported data

  1. Click the name of the Intelligent Cube you want to republish. If the Intelligent Cube was originally published using data from a file from a URL or UNC path, a Freeform script, or a Salesforce.com report, Web attempts to automatically republish the Intelligent Cube using data from the same data source.

  2. If the original data source was a file that was uploaded from your computer or network, you must reupload the file. Perform the following steps:

    1. Click Browse. The Select a File to Upload dialog box is displayed.

    2. Navigate to and select the file you want to upload, then click Open. Click Publish.

    3. If the file is an Excel workbook with more than one sheet of data, from the Sheet Name drop-down list, select the name of the sheet from which you want to import data, then click OK.

  3. If the original data source cannot be not found, the Freeform script cannot be executed successfully, or Web is otherwise unable to import data from the original data source, you must re-specify the data source using the same steps required to publish a new Intelligent Cube. You can hover the cursor over the information icon Example of the information icon to display a detailed description of the problems Web encountered during the upload process. If the names or data types of the data columns originally used to publish the Intelligent Cube have changed, or if data columns are now missing, you must define new data columns as attributes and metrics. Select the appropriate options to define attributes and metrics, map data columns to existing attributes, and so on. For steps, see the appropriate topic below:

Related topic