Rob, We too are running Noetix and OBI 11.1.1.9 for Oracle EBS 12.1.3. What version are you on? Thanks.

Sorry @Jerry Casey - silly mistake by me When I created the logical column, I right clicked the source column -> selected "Duplicate" -> then modified the newly created column with the function in "Derived from existing column using an expression" on the "Column Source" tab. Today I decided to recreate this column from…

Jerry, Thanks for your reply. SUBSTR function cannot be used in the RPD. Here is the error message I get. LEFT and SUBSTRING are part of the string functions that I have to use. https://docs.oracle.com/cd/E14571_01/bi.1111/e10544/appasql.htm#BIEUG487 Thanks.

Can I please get some help with this issue? I am going crazy :-(

Thanks again @Christian Berg

Thanks @Christian Berg I guess we will have to keep our Windows 7 boxes. Any idea about Windows 2016 server?

Yes I had created that table for this POC. So I don't have to use that table if there is a better way.

So do you suggest maintaining in a table is a better solution?

@Joel Acha thanks for the suggestion. I have never done this but will give it a try. Stay tuned for more questions :-) I was just thinking if this can be achieved by creating Groups in Weblogic Console and Application Roles in EM and then assigning the group to the user? Then I won't need a table to maintain.

@Joel Acha Thanks for the solution and the link to the new features. That was very helpful.

@Gianni Ceresa & @Thomas Dodds - Thank you both for confirming that it is supported & should work bringing data from 2 different data sources. I just started all over again and was able to bring the data I wanted. Not sure what is messed up with the RPD I was working in. Appreciate the service you folks provide to OBIEE…

@Thomas Dodds thanks for your reply. Like you suggested, first I was thinking about creating a MVIEW in the O&M database but wanted to give this a try as we have couple more disparate sources and thought it would be helpful. Looks like from your & Gianni's reply, even if it works, wouldn't be a very efficient way to do it.

@Gianni Ceresa thanks for your reply. I don't even get to select the columns and see what the query is. When I click on the Employee view, the circle next to the folder icon keeps spinning and never opens for selecting the columns (screen shot below). So right now I am not much concerned about the performance - I just want…

Thanks @Robert Angel for confirming.

Do not hesitate to ask any questions you might have. Definitely :-) Thanks for offering your help. So I was able to create an alias (so now 2 aliases for 1 table). I also had to add a filter for proj_ind = 0, which I was able to add it in the BMM layer, under the Logical Table -> Sources -> Properties -> Content tab ->…

No offense taken. I understand when you all are helping the newbies (and sometimes even the experts) by answering their questions, there is nothing wrong in expecting a small thank you or an appreciation or an acknowledgement. Like I said, I truly appreciate everyone's contribution to the online community, while…

My apologizes @Robert Angel if I might have missed any of your earlier replies :-( Nothing personal or disrespect to you or any of the folks in this community. I truly appreciate everyone's contribution in OBI world.

OBI Gurus - Thank you for your prompt answers and guidance _/\_ @Martin van Donselaar Thanks for the link. That will be a great start for a newbie. And thanks for sticking up for me :-) @Robert Angel Agreed. I will implement it without views. Thanks again for the insight. And we all are in different timezone, hence the…

Thank you Gurus I think this question has produced enough knowledge for Newbees like me to get start with Oracle BI tools. If I've understood the above discussion correctly, the pathway for Oracle based BI development is: * Create Data Warehouse based data model in Oracle Database * Do the ETL (if needed, and practically…

Hi Thomas Thanks for the reply You are correct...I started BI n DW work with Microsoft (SSIS, SSAS, SSRS/Power BI) and as most of these tools are accessible from a single IDE: SQL Server Data Tools (SSDT), that's why I was looking alternates tool by tool to prepare my BI toolkit eventually. And I was getting confused after…