EIS Usage Summary

➜ Back to Library
Description
Categories: EIS
EIS eXpress Reporting usage by calendar month of the run start, to estimate the number of Blitz Report licenses required for the EIS user base.

User Count is the number of distinct users who ran an EIS report in the month. User Count 60 Days is the number of distinct users in the 60 days before the month started, which corresponds to the rolling 60-day window that Blitz Report licensing is  ...  EIS eXpress Reporting usage by calendar month of the run start, to estimate the number of Blitz Report licenses required for the EIS user base.

User Count is the number of distinct users who ran an EIS report in the month. User Count 60 Days is the number of distinct users in the 60 days before the month started, which corresponds to the rolling 60-day window that Blitz Report licensing is based on.

Runs count executions from eXpress and XL Connect. A scheduled run counts for the user who created the schedule. Email distribution jobs are deliveries of a run and are not counted.

EIS purges its run history, so the counts of the first retained months are understated. EIS Execution History shows the earliest retained run.   more 
select
to_char(z.month,'yyyy-mm') month,
count(distinct case when z.window_flag is null then z.user_id end) user_count,
count(distinct case when z.window_flag='Y' then z.user_id end) user_count_60_days,
sum(z.runs) runs,
sum(z.scheduled_runs) scheduled_runs,
sum(z.runs)-sum(z.scheduled_runs) ad_hoc_runs,
sum(z.xl_connect_runs) "XL Connect Runs",
count(distinct case when z.window_flag is null then z.report_id end) report_count
from
(
select
add_months(trunc(y.run_date,'mm'),rowgen.column_value-1) month,
decode(rowgen.column_value,1,null,'Y') window_flag,
y.user_id,
decode(rowgen.column_value,1,y.report_id) report_id,
decode(rowgen.column_value,1,y.runs) runs,
decode(rowgen.column_value,1,y.scheduled_runs) scheduled_runs,
decode(rowgen.column_value,1,y.xl_connect_runs) xl_connect_runs
from
(
select
erp.created_by user_id,
erp.report_id,
trunc(erp.start_time) run_date,
count(*) runs,
count(case when erp.start_time-ers.logon_time>1 then 1 end) scheduled_runs,
count(case when erp.submission_source='XL Connect' then 1 end) xl_connect_runs
from
xxeis.eis_rs_processes erp,
xxeis.eis_rs_sessions ers
where
erp.submission_source in ('eXpress','XL Connect') and
erp.report_id<>-999 and
erp.session_id=ers.session_id(+)
group by
erp.created_by,
erp.report_id,
trunc(erp.start_time)
) y,
table(xxen_util.rowgen(4)) rowgen
where
(rowgen.column_value=1 or add_months(trunc(y.run_date,'mm'),rowgen.column_value-1)<=y.run_date+60) and
add_months(trunc(y.run_date,'mm'),rowgen.column_value-1)<=sysdate
) z
group by
z.month
order by
z.month desc
Download
Related Blitz Reports
EIS Reports EIS Execution Summary EIS Users EIS Execution History EIS Schedules EIS Views EIS Import Validation EIS View Dependencies EIS Report Conditions
Blitz Report™