Import Data
Explanation
This activity is used to import external data to a BA report. Only values of
measure items and light items entered in the BA report design which are writeback
enabled cells can be replaced with external data.
Once the external data is imported, the data values can be written back using
the Writeback functionality of IFS Business Analytics.
Prerequisites
In order to perform this activity:
- A previously exported Excel file without BA that has been updated with
external data must exist.
- The Excel file mentioned above must have been saved with the BA
functionality in the BA export archive or the local disk when it was
previously exported.
System Effects
As a result of this activity, the target BA report (i.e. the BA report open
when the import is carried out or the BA report retrieved from the BA export
archive) will have the values of its writeback enabled cells replaced with the
external data from the Excel report imported.
Related Process Model
Analyze Report
Related Activity
Procedure
- Open BA
client and log in. (Note: if you want to import data to a BA report that is
saved in the local disk, then open the BA report from the local disk.)
- Click Import in the IFS Business Analytics Ribbon to open the Import from Excel Report dialog box
- Click Browse in the Source File tab to select the
Excel report that is updated with the external data to be imported.
- Select the Sheet Selection check box to view all the sheets of
the Excel report. The Selected check box will be selected for all the
sheets by default.
- Clear the Selected check box for the sheets you do not want to
import.
- Click on the Target BA Report tab.
- Select Report from BA Export Archive. Then select Re-execute
Before Import only if required. (Note: Layout changes that could
result in values being imported to incorrect locations may occur if the BA
report is re-executed before import.). Select Current BA Report if you initially opened the BA report to which external data should be
imported (refer step 1).
- Click Import to close the dialog box and import the external
data.