Author Topic: Query on GIM and interactive Insight (Read 2807 times)

sunbabu15 · « **on:** February 04, 2011, 06:16:45 PM »

Hi ALL,

Can any one please summarize in brief what exactly the FACT ,Dimension and Aggregate tables refers n used in Infomart DB.
I have gone through the Genesys docs but couldn't get the clear picture on this .

Thanks,

fnunezsa · « **Reply #1 on:** February 04, 2011, 06:30:29 PM »

Do you understand what a Star Schema is?

In a star schema you have some fact tables that store some "facts" or data that refers to some "dimension".

The aggregates tables are optional tables that store some "aggregated facts". For example total number of interactions handled by agents or group of agents in a specified period of time. In the previous example, "total number of interactions" is an aggregated fact and "agents" or "group of agents" are dimensions.

HTH,

Kind regards,
Franklin.

sunbabu15 · « **Reply #2 on:** February 04, 2011, 06:34:39 PM »

Hi Franklin,
Sorry. I still didn't get you.
Can you please explain in brief wht fact and dimension and Star Schema refers ?

Thnks,

fnunezsa · « **Reply #3 on:** February 04, 2011, 07:27:34 PM »

ummm...

Please refer to http://en.wikipedia.org/wiki/Star_schema

sunbabu15 · « **Reply #4 on:** February 05, 2011, 06:01:41 AM »

Thanks Franklin.
Got the picture now.

fnunezsa · « **Reply #5 on:** February 08, 2011, 01:12:28 AM »

Genesys CTI User Forum

News:

Author Topic: Query on GIM and interactive Insight (Read 2807 times)

sunbabu15

Query on GIM and interactive Insight

fnunezsa

Re: Query on GIM and interactive Insight

sunbabu15

Re: Query on GIM and interactive Insight

fnunezsa

Re: Query on GIM and interactive Insight

sunbabu15

Re: Query on GIM and interactive Insight

fnunezsa

Re: Query on GIM and interactive Insight