Turn this SQL in OBIEE join relations... Help please :(

Barticchia

Ciao again Gianni and thanks to spend your time i really appreciate it.

yesterday night i was thinking to do a view but is not dinamyc (filter can be changed).

As i told you is a self reporting and users make their own report.

even if i could create a view (in this way)

select c.circ_id as ID

from

pippo a, pluto b, pippo c

where

a.circ_id = b.parent_id

and b.member_id=c.circ_id  

i can't put this condition (that is essential)

and a.circ_id = 'ROMAITDG/ROMAITDG/S2T/000009'

These are steps that end users will do:

select ID field, they will drag it into analysis, and from it they will create a filter.

So i have to put myself on the other side (end users) and try to find a solution. With view i don't think to solve it

Gianni Ceresa

They must have that thing available as a subject area? Because in that case, as said, I'm sorry to be negative but there isn't a solution (as a.circ_id can't be the same column as c.circ_id).

Barticchia

Yes. they must have as SA.

Tomorrow we'll have a meeting... we'll see.

Thanks again for your support.

Gianni Ceresa

Show them the video tomorrow during the meeting! Can't be worse than how you are now with an impossible requirement

[Deleted User]

This thread is becoming popcorn cinema

Barticchia

You right Christian... Sorry for that

do you agree with Gianni there isn't solution for this request?

what do you think about it?

i really would like to know another point of view

thanks a lot

[Deleted User]

That wasn't a complaint man! I agree 100% with Gianni