Thank you so much. Let me try it.

Are you familiar with Oracle BI Publisher?

Please bear with me. I am still very new to OBIEE. IT is oracle BI Publisher. I am sorry I did not clarify it. Let me know if I am able to implement that in Oracle BI publisher.

Let me make sure I understand it. You want me to have a join between the two data models. I am ok with that. Just one thing if both were data sources, that would not be a problem One has a data source and the other does not . one is pulling data from tables One is pulling the csv file If I have logic that does an inner…

Let me elaborate it again. There is a csv file. When you create a data model, you can create an csv file. The columns are all there and you can run them as a view. In this there is no sql involved. Now I create a data model. This is looking at a source and it needs to pull multiple account numbers. The account numbers are…

I agree with your part of using the csv file as a data source. However, in my case I do not have the access to create external tables. I know in OBIEE you can create a new csv file and display it in grid view. Is there a way to combine data from multiple data models. Let me elaborate I have one data model which has my sql…

Gianni Thanks for your reply. Can this only be accomplished in Visual Analyzer?

Could you please elaborate

Are you aware of any such feature where a text file could be used as a parameter

Yes it is analyses.