There is a set of scheduled tasks associated with IFS Business Intelligence Services. The most important tasks are the refresh tasks that offers scheduled refresh of Information Sources, dimensions and Materialized Views.
This task is used to clean up outdated trace data from the BI Client runtime Log.
Trace information that is older than 10 days is removed. The task is defined and performed during installation/upgrade as a scheduled task that runs once every week.
This task cleans up Business Analytics (BA) specific system templates, i.e. BA report templates created by the system during execution.
It removes system templates older than 30 days are removed. The task is defined and performed during installation/upgrade as a scheduled task that runs once every week.
This task cleans up Business Analytics (BA) related Write Back information, i.e. information posted in the database as a result of using the write back functionality in IFS BI Services.
Write back data older than 10 days is removed. The task is defined and performed during installation/upgrade defined as a scheduled task that runs once every week.
Use this to schedule a refresh task for one or many dimensions used by IFS BI Services, this will refresh the Materialized Views that serve as dimension sources.
Note: Materialized Views by default are defined not to be refreshed on COMMIT, in order for the dimensions to show the latest state of the associated basic data, all referenced Materialized Views have to be refreshed. Refresh is either performed manually or as a scheduled job.
Scheduling is ordered either as a one-time job or as re-occurring job. However in most cases it's enough to schedule refresh of Information Sources.
Two parameters should be supplied:
To refresh one specific dimension, specify <dimension_name> e.g. DIM_ACCOUT
To refresh more than one dimension, supply a list according to <dimension1_name>;<dimension2_name>;...;<dimensionN_name>
e.g. DIM_ACCOUNT;DIM_CODE_B
Specify DIRECT to refresh only directly referenced Materialized Views.
Specify ALL to refresh all referenced Materialized Views. It is recommended to use RELATION=ALL.
This task can be used to schedule refresh one or many Information Sources used by IFS BI Services, which means that the Materialized Views that serve as the Information Source will be refreshed. Note that Materialized Views by default are defined not to be refreshed on COMMIT, so in order for the Information Source to show the latest state of the associated transaction data, all referenced Materialized Views have to be refreshed. Refresh is either performed manually or as a scheduled job.
It is recommended to define update of Information Sources as re-occurring scheduled tasks to make sure that the data accessed by IFS Business Intelligence Services is up-to-date at least once a day. Refresh can e.g. be scheduled to take place early in the morning every day or twice a day; early in the morning and during lunch.
Two parameters can be supplied:
To refresh one specific Information Source, specify <information_source_name> e.g. FACT_GL_BALANCE
To refresh more than one Information Source, supply a list according to <information_source_name>;<information_source_name>;...;<information_sourceN_name>
e.g. FACT_GL_BALANCE;FACT_GL_TRANSACTION
Specify DIRECT to refresh only directly referenced Materialized Views.
Specify ALL to refresh all referenced Materialized Views. It's recommended to use RELATION=ALL.
For a Information Source this means that all referenced Materialized Views, also those used by connected dimensions, will be refreshed.
This task can be used to refresh Materialized Views associated with IFS Business Intelligence Services, either as a one time job or as a re-occurring task.
The following parameter can be supplied:
Specify ALL to refresh all available Materialized Views.
To refresh one or more Materialized Views, supply a list according to <MV1>,<MV2>,...,<MVn>
When a new dimension or Information Source is defined in IFS Business Intelligence Services Meta Data, a cache with information about used and referenced Materialized Views is required to be updated. This task is used to refresh the Materialized Views cache and it should only be ordered as a single (one time) job.
The cache is normally refreshed during installation/upgrade but if for some reason a Materialized View is missing when managing Materialized Views, e.g. when developing new Dimensions/Information Sources, please order an instant execution of this task.
This task can be used to refresh Materialized View Categories associated with IFS Business Intelligence Services, either as a one time job or as re-occurring task.
The following parameter can be supplied:
Specify ALL to refresh all available Materialized View categories.
To refresh one or more Materialized Views, supply a list according to <MV_category_name>,<MVcategory_name>,...,<MVcategory_name_n>