Yes Thomas , I also noticed that error. But my doubt is whether this permission error related to DB or BI publisher side ?? Because I am able to run the query in same DB and see the data in DB (Using Sql developer). Why this error coming in BI publisher ? Could you please explain me .

Hi Thomas , Have checked with other user (who is having sysdba previleges) , still I am unable to view data and getting failed to load xml error. Please help me to resolve this issue. Below is the view engine log information: <?xml version="1.0" encoding="UTF-8"?> <!--Generated by Oracle BI Publisher 12.2.1.2.0…

Below is the output of View Engine Log: <?xml version="1.0" encoding="UTF-8"?> <!--Generated by Oracle BI Publisher 12.2.1.2.0 -Dataengine, datamodel:_PCLS_BI_BI_Publisher_Test__BI_Data_Model___OBIEE_Report_as_Source_xdm --> -<DIAGNOSTIC_OUT> -<DATA_PROCESSOR_LOG> -<![CDATA[ Data Processor debug log…

Hi Thomas , Thanks for your reply. I am able to see data in query builder but no in view data. Please find below view Engine log information and let me know if you find any error information (Actually , I am unable to find anything) <?xml version="1.0" encoding="UTF-8"?> <!--Generated by Oracle BI Publisher 12.2.1.2.0…

Thanks for your reply. Issue got fixed. Issue is related permissions in server side.

Thanks for your reply.

Thanks for your reply. I haven't tried yet. This request has been dropped from my client.

Hi Joel , Thanks for your reply. Please find below details. OBIEE : 12.2.1.2.0 OS : linux I didn't fine any error in log files. Have created ODBC for SQL server and able to import tables in RPD. when I am trying to see view data I could n't see the data and observed that column names are coming as values Have not uploaded…

Hi Berg, My apologies for that. Next time I will make sure to close the tickets once I have the answer. Thanks

You mean it is possible in OBIEE Analytics or it is possible in VA (Visual Analyzer) ??

I am Sorry for double posting. I will close the thread. Thanks Bharath

Thanks again for quick reply. One last question , If I am not wrong in logical we can't define join based on column ..we only give logical join with outer or inner join. What if I want to join two tables ( one from oracle DB and another from SQL server DB) based on one column .In this case ,we need to physical join right…

Thanks for prompt reply. Do you mean we can give join between the tables of multiple data sources (if common column is there in both data sources ) in physical layer ?

Thanks Robert for your prompt reply. Actually , we are checking cognos features whether possible in OBIEE or not. Thanks , Bharath

Thanks for prompt reply. Can you please tell me how to connect to Composite software from OBIEE 12c RPD?

I mean RPD loaded by the server.

Sorry Gianni. I didn't read your full comments that is the reason I asked you in my previous comments as explain me why is not possible. Once again thank you so much

Thank you Gianni for prompt response. We heard it is possible in OBIEE 12C . Could you please explain me why is not possible in OBIEE 12C. Thanks