Create first ESS job on BI Report | ERP Cloud

Usecase: We will create our first ESS job on BIP report and shedule the ESS job from scheduled processes and track the details from ess_request_history and ess_request_property tables.

Steps with detailed screenshots:

ERP - Secure BI Report

We can provide permissions to specific user to use the report to make it more secure.

Report >> More >> permissions >> add user >> no access to BI admin, BI author and cosumer if needed

Detailed steps with screenshots:

ERP - BI Report Export | Send to UCM | Send as Email Attachment

Usecase: Here, we will see the following -

• How to schdule BI report and send using email attachment and also send to UCM.
• How to check schedule report history
• How to check BI ess job run from scheduled process
• How to see export file to UCM
• See other delivery options in administration settings.

Detailed steps with Screenshots:

ERP - BI report Migration

BI report migration is very simple. We need to archive the data model and report from one instance and unarchive to higher or another instance.

Steps:

ERP - How to stop auto run of a parameterized BI report

When we use parameters in BI report and go all data case, we observe it starts auto running while we just open the report. To avoid this, we simply need to stop the auto run option from properties.

Detailed Steps are below: