You can load initial historical data into IBM® Analytics Solutions Manager on Cloud by using comma-separated values
(.csv) files.
Your Information Technology department can collect historical data by
querying your asset management data source. The data must be arranged according to comma-separated
values (.csv) template files that are available from Analytics Solutions Manager on Cloud. To download the templates
for a project, on the Load Data tab, hover over each data load tile and click
Download Template.When you load initial data, you must load master data first, followed by
event data.- On the Load Data tab, ensure that Auto-Calculate
is turned off.
Important: When you load and analyze initial data, Auto-Calculate
must be turned off.
- Drag a comma-separated values (.csv) file onto its corresponding data load tile.
A preview appears, showing the first 10 rows of the data that is being uploaded, for your
verification.
Tip: If the preview data is not correct, under Current Data,
click Clear to erase the data from the database. Open the comma-separated
values (.csv) file and verify that the information is correctly mapped to the template columns and
that the data types are correct. Upload the file again.
- To load more data, click Back to Data Inputs to return to the
Load Data tab.
When a file upload is complete, the data load tile displays a check mark and information about
the most recently uploaded file.
When a file upload is still in progress, the data load tile displays a
Processing status. You can continue uploading files to other data load tiles, but
you must wait for the upload that is in progress to finish before you upload another file to the
same tile.
Tip: Refresh your browser to check the current upload status.