Hi,
Thanks in advance for helping me in resolving following issue:
I tried to run a report from OBIEE whose data model is sourced from ADF layer,
In my application module i have 5 View Objects:
For Ex: VO1, VO2, VO3,VO4,VO5
And i have view links between: VO1 and VO2 (lets say: VO1_VO2_VIewLink) ,
VO2 to VO3 ((lets say: VO2_VO3_VIewLink)) , VO4 is linked to VO3 ((lets say: VO4_VO3_VIewLink)) & VO5 is linked to VO3 as well (lets say: VO5_VO3_VIewLink)
When i deploy this application on OBIEE and run a report with objects from:
1) VO1 and VO2 --Report works fine
2) VO2 and VO3 -Report works fine
3) VO4 and VO3 -Report works fine
4)VO5 and VO3 -Report works fine
5) VO1,VO2,VO3 -Report works fine
Issue is when i run report with objects from
VO1,VO2,VO3 and VO4 it throws a error message:
"Error occurs while calling remote service ADFService11G. Details: ADFException-3007: The ViewObject "AppModule.VO3" is used as the destination of more than one ViewLink. (HY000)"
OBIEE Version is : 11.1.1.7.0 (with No patches) Database:11gR2, Jdev:11.1.1.7.0
Regards,
Ram.