ODI Load Monitering Dashboard

Question

Hi,

Currently I am working ODI Load Monitoring Summary Dashboards.

I have done the 1st Report of Load Plan from SNP_Load_Plan and SNP_LPI_Run.

Below are the Requirement.

1. i want to drill to next level from Load Plan to Load Plan Folder Level ? Eg: SIL,SDE,PLP Folder

2.Next Requirement is  From Load Plan Folder  to next level? i.e, SIL,SIL_Custom,SDE,SDE_Custom,PLP,PLP_Custom

Thanks,

Kiran

John_K · Answer

The load plan structure is held hierarchically in snp_lp_step, which joins to snp_loan_plan.

I started something similar a long time ago in APEX but never got around to finishing it unfortunately. Monitoring Oracle Data Integrator (ODI) Load Plan Executions with BI Apps - Beyond Blog . It was always my intention to release it for free use once completed. maybe I'll get back around to finishing it one day!

Gianni Ceresa · Answer

Hi,

Enjoy that dashboard, sounds like fun ...

Because of the lack of question marks I assume you aren't asking people on here to make it for you, right?

https://www.youtube.com/watch?v=5CgBmj7Jz6Y&t=19s