" /> Example queries ICON - Genesys CTI User Forum
« previous next »
Pages: [1]   Go Down

Author Topic: Example queries ICON  (Read 2460 times)

Offline xember

  • Newbie
  • *
  • Posts: 19
  • Karma: 0
Example queries ICON
« on: January 16, 2011, 04:01:29 PM »
Advertisement
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

Logged

Offline René

  • Administrator
  • Hero Member
  • *****
  • Posts: 1832
  • Karma: 62
Re: Example queries ICON
« Reply #1 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.
Logged

Offline xember

  • Newbie
  • *
  • Posts: 19
  • Karma: 0
Re: Example queries ICON
« Reply #2 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
Logged

tony

  • Guest
Re: Example queries ICON
« Reply #3 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
Logged
Pages: [1]   Go Up
« previous next »