Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: Gaia on June 16, 2017, 01:44:02 PM

Title: Infomart vs DataMart
Post by: Gaia on June 16, 2017, 01:44:02 PM

Hello,

I tried to compare total calls answred by agent for VQ
[Total_Calls_Answered]
Category=TotalNumber
Description=Total number of new calls answered
Formula=DCID
MainMask=CallAnswered
Objects=GroupQueues, Queue, RoutePoint
Subject=DNAction

with this request
select
vq.resource_name,
count(distinct m.INTERACTION_ID) as N_SERVIS
from
mediation_segment_fact m, 
resource_ vq,
interaction_resource_fact i
where
m.RESOURCE_KEY = vq.resource_key               
and vq.resource_name in ('NAME OF VQ')
i.TALK_COUNT <> 0 and                   
i.INTERACTION_ID = m.INTERACTION_ID            and
(to_date('1970-01-01','YYYY-MM-DD') + m.start_date_time_key/24/60/60) > = to_date('2017-06-12','YYYY-MM-DD') and
(to_date('1970-01-01','YYYY-MM-DD') + m.start_date_time_key/24/60/60) < to_date('2017-06-13','YYYY-MM-DD')       
group by vq.resource_name
order by 1;

But I always have gap (1 to 5 ) between datamart and infomart.

I tried to discard some calls with (Technical_result = CustomerAbandonned)  but there is always gap.

Is someone here already compared data from DataMart and InfoMart ?
in your experien what is % of gap between infomart and datamart ?

thanks for help

best regard

Title: Re: Infomart vs DataMart
Post by: mcruli on June 16, 2017, 03:45:33 PM

look in the manual of statserver. You look for adjusted calls and the query return all calls. TALK_COUNT is not the only param for search.
Other thing is the consolidation time. you template in the ETL is 5 min..15 min? in 5 minutes you could get 500 calls in a big callcenter. Synchronization time is a problem.. CCAnalizer use Statserver, Infomart not.

=====================================
Mira el manual de Statserver. Deberias estar mirando las llamadas "adjusted". Mirar solo TALK_COUNT no es sufficient y no deberia ser el unico parametro en tu Query.
Otro problema es la sincronizacion. Si tu template de ETL usa una granularidad de 5min o 15min, creara grandes diferencias. Podrias tener 500 llamadas de diferencia en grandes sistemas.
CCAnalyzer y Infomart buscan los datos de diferentes formas, Statserver y ICON, ICON es mas exacto, asi que 100% tendras diferencias.

Title: Re: Infomart vs DataMart
Post by: Gaia on June 19, 2017, 08:17:31 AM

hello,

I have 5mn Template in CCA.

br,