Execute Business Analytics Report
Explanation
This activity is used to execute Asset Design reports that are designed,
saved and published in IFS/Business
Analytics. Execution of a published report can be performed on Design Objects.
However, these reports need to be registered in the respective design object
class in order to make them executable. It is possible to export an executed BA
report as a pure excel report (without BA design) and import it back to BA with
the modifications. These
modifications can also be written back (deploy data) into the
Database.
Prerequisites
- IFS Business Analytics must be installed in the client.
- Business Analytics (BA) reports need to be designed and published in Business Analytics.
- BA reports need to be registered in the respective design object classes.
System Effects
N/A
Window
N/A
Related Window Descriptions
Execute Business
Analytics Reports
Procedure
Use the appropriate procedure/s to execute a report, designed by IFS Business Analytics.
Execute the Report
- Open and Design Object window and search for a Design Object ID. Make sure
that the Class of the queried Design Object does have BA reports registered.
- Click right mouse option Execute Business Analytics Reports
to open up Execute Business Analytics Report dialog.
- Check on the selected default report . Optionally, click on the list
values and change it if required.
- Click OK to execute the report.
- Login to IFS Business Analytics application.
- Enter the parameter values if required by the report and set OK.
- Microsoft XL
is opened up with the populated Business Analytics report.
Export the Report
- Stand on the executed mode of the report. (Report Book button is
selected)
- Select Export to Excel Report button on the Report Book
Panel. It results in to open Export to Excel Report dialog.
- Change the option Export to Excel Report for Later Import. The
default option Export Excel Report can be kept, if Import is not a
concern.
- Open the Export Excel Report without BA tab and select the
appropriate save and distribution option.
- Enter the required File Path and the File Name.
- Open the Save BA Report tab and check Save BA Report to
Archive option is selected.
- Click on the Export button on the dialog.
- Go to the saved location and open the Excel report. The report is opened
without BA now.
- Do the required modification that need to be write back in to the
database and save them.
Import the Report
- Stand on the executed mode of the report. (Report Book button is
selected)
- Select Import From Excel Report button on the Report Book
Panel. It results in to open Import From Excel Report dialog.
- Open the Source File tab.
- Browse for the exported and modified report.
- Open the Target BA Report tab. Select the option Report From
BA Export Archive and Re-Execute Before Import options.
- Click on the Import button on the dialog.
- Enter the parameter values if required by the report and set OK.
The write back data should successfully be imported now.
Write Back the Report
- Stand on the executed mode of the report. (Report Book button is
selected)
- Select Writeback button on the Report Book Panel. It
results in to open the Writeback panel.
- Click on the Collect Modified Datasets button on the
Writeback panel header. All modified data are listed down in different
data sets.
- Click on the Collective Writeback button on the Writeback
panel header.
- Check the status message of each writeback cell.