RWB Execution Summary

Description
Categories: RWB
Execution history of Polaris Reporting Workbench reports, summarized by combination of accessed views, similar to the Blitz Report import menu option LOV. This can be used when migrating from Polaris Reporting Workbench to Blitz Report, to analyze which Polaris view were previously used by the business
Run RWB Execution Summary and other Oracle EBS reports with Blitz Report™ on our demo environment
select distinct
decode(count(distinct y.report_id) over (partition by y.view_ids),1,rr.report_name,'<multiple>') report_name,
y.views,
y.db_views,
count(*) over (partition by y.view_ids) execution_count,
count(distinct y.report_id) over (partition by y.view_ids) report_count,
count(distinct rrs.user_id) over (partition by y.view_ids) user_count,
y.view_ids
from
(
select distinct
x.report_id,
listagg(rv.view_alias,', ') within group (order by rv.view_alias) over (partition by x.report_id) views,
listagg(rv.db_view_name,', ') within group (order by rv.view_alias) over (partition by x.report_id) db_views,
listagg(x.view_id,',') within group (order by x.view_id) over (partition by x.report_id) view_ids
from
(
select distinct
rrc.report_id,
rvc.view_id
from
rx_report_columns rrc,
rx_view_columns rvc
where
rrc.view_column_id=rvc.view_column_id
) x,
rx_views rv
where
2=2 and
x.view_id=rv.view_id
) y,
rx_report_stats rrs,
rx_reports rr
where
y.report_id=rrs.report_id and
y.report_id=rr.report_id and
1=1
order by
execution_count desc,
y.views
Parameter Name SQL text Validation
View Name
rv.db_view_name=:db_view_name
LOV
Submitted by User
rrs.user_id=xxen_util.user_id(:created_by)
LOV
Started within Days
rrs.start_time>sysdate-:days
Number
Start Date From
rrs.start_time>=:start_date_from
DateTime
Start Date To
rrs.start_time<=:start_date_to
DateTime
Run Type
rrs.run_type=:run_type
LOV
Blitz Report™