Hi everyone
I got a problem to turn this simple sql into Join relations in OBIEE (Physical - BM - Presentation)
select c.*,b.*
from circ_path_inst a, path_chan_inst b,circ_path_inst c
where a.circ_path_inst_id = b.parent_path_inst_id
and b.member_path_inst_id=c.circ_path_inst_id
and a.circ_path_hum_id = 'ROMAITDG/ROMAITDG/S2T/000009'
As you can see, i have to show all datas from "c" table that is filtered with the same field (showed) from "a" table.
I'll call tables in this way to let you understand more easly (i hope)
-PIPPO (a)
-PLUTO (b)
-PIPPO2 (c)
I created an alias in Physical layer of PIPPO and i called it PIPPO2.
i joined those 3 tables in this way:
(Physical)
PIPPO (a.id) inner join PLUTO (b.parent_id)
PLUTO (b.member_id) inner join PIPPO2 (c.id)
PIPPO -> PLUTO -> PIPPO2
(Business Model)
PIPPO (a.id) inner join PLUTO (b.parent_id)
PIPPO2 (c.id) inner join PLUTO (b.member_id)
PIPPO -> PLUTO <- PIPPO2
when i try to launch report, error message appear: No fact table exist.
Can you tell me please how you could create relation between those tables? arrows (physical and bm) in wich direction?
I thought also to create a table with sql, but it is a Self Area and customer can make their own report changing fields.
Can you help me please?
Any idea?
Many many many thanks
