Skip to Content
0
Former Member
Dec 05, 2008 at 06:31 PM

Recursion in a WebI query

133 Views

Hi everyone,

I would like to know how to reproduce that kind of SQL in a WebI report:

SELECT

pp.project_id,

pp.name as project_name,

pp2.project_id as project_id_of_model,

pp2.name as model_name

FROM

PA.PA_PROJECTS_ALL PP,

PA.PA_PROJECTS_ALL PP2

WHERE pp.created_from_project_id = pp2.project_id

It's kind of a recursion where I want to know what is the name of the model of project from which are created projects. As these models are projects themselves, I have to read the same table twice.

I have tried 2 queries, sub-queries, merging dimensions etc. and I can't get the results in one block. I would like to merge pp.created_from_project_id with pp2.project_id but WebI doesn't allow me to do so.

Does anyone has a clue to help me?

Thanks and have a good day.