Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: xember on January 16, 2011, 04:01:29 PM

Title: Example queries ICON
Post by: xember on January 16, 2011, 04:01:29 PM

Hello All,

My customer is using ICON and SAP BW for reporting. We are waiting for the SAP BW guys to finish but this will take a couple of month.
I was wondering if one of you have a few (or more ;)) queries to get me started in providing them temporary data..

Thanks in advance,

Xember

Title: Re: Example queries ICON
Post by: René on January 17, 2011, 09:24:31 AM

Hi Xember,

Your question is quite general... Schema of ICON database is well documented so I would recommend you downloading the documentation from Genesys Technical Support website and try to get data you're after.

R.

Title: Re: Example queries ICON
Post by: xember on January 18, 2011, 10:03:18 AM

Dear Rene,

You are quite right.. but why inventing the queries allover again if they are availlable? Ok, I will post sample queries when I created them.

Kind Regards,

Xember

Title: Re: Example queries ICON
Post by: tony on January 18, 2011, 11:26:56 AM

Hi,

Rene has a point - it is well documented and *everyone* has a different need when it comes to providing output from ICON/Infomart.

As long as you understand the relationships between the base Tables - and you understand what Primary and Foreign Keys are and how they are related, you shouldn't find it too difficult to pull together.

Good luck!

TT