Hyperion question - unique values

[mark]

Probably an easy one for you all

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

Mark

[René]

Hi Mark,

Here it is 

[font=Courier New][color=navy]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
[/color][/font]

René

[Adam G.]

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

Please rename the .txt to .bqy

Pavel

[mark]

Thanks both :]

Pavel, 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

[mark]

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

[Adam G.]

[quote author=mark link=topic=2125.msg7345#msg7345 date=1173879359]
Thanks both :]

Pavel, 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
[/quote]

Mark,

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

Pavel

[René]

Just a note - don't use ".txt" extension when uploading a binary file because it becomes corrupted.

to Pavel: even I was faster, you won 

René