Example queries ICON

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

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.

2 Likes

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

2 Likes

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