Hyperion question - unique values

Voice & Telephony
1

Probably an easy one for you all :smiley:

I have created a hyperion query against the cfg db for agent name, skill, skill level.

When I process the query, I get the results that I want, however it does have multiple results. For example, Agent1 with Skill1/Level1 will show 200+ times.

Query:
Cfg.Person - Firstname, lastname
Cfg.Skill - name
Cfg.Skill Level - level

Any help would be appreciated :smiley:

Mark

2

Hi Mark,

Here it is :slight_smile:

SELECT person.first_name,person.last_name,skill.name,skl.level_
FROM cfg_person person,cfg_skill_level skl,cfg_skill skill
WHERE person.is_agent=2 AND skl.person_dbid = person.dbid AND skill.dbid = skl.skill_dbid
ORDER BY person.last_name,skill.name

René

3

Rene beat me to it but here is a Hyperion report that I just rustled up.

Please rename the .txt to .bqy

Wyn

4

Thanks both :]

Wyn, the file tells me ‘Incorrect fields encountered. Document may be corrupt’.

Are you free this afternoon? Was looking at giving you a call regarding Munich later on :]

Mark

2 Likes
5

Ahh in the query my joins were a bit wrong!

Have now got it right,

cfg.person: dbid connected to cfg.skill level: person dbid
cfg.skill level: skill dbid connected to cfg.skill: dbid

i had skill and skill level the wrong way around (and a few un needed links!)

Mark

6

Mark,

Have emailled you the bqy just in case. It has been written against a v7.2 config Server DB.

Wyn

7

Just a note - don’t use “.txt” extension when uploading a binary file because it becomes corrupted.

to Wyn: even I was faster, you won :wink:

René