Can some help me on this pls.
using UDA we can not use drill through in FDMEE, below is oracle response.
Call - Outbound ------------------------------ Using UDA to load custom data from EBS Database, they have created view in database and using it load in to HFM application. They have defined the EBS URL in Drill URL and expecting it to drill back to EBS. Explained that drill through will not work for EBS custom tables when using UDA. Even though we define the Drill URL, it will not be capable of passing the parameters in to EBS, UDA will not aware that the Data is from EBS, just consider it as Database object.
I am not sure I agree with the statement as it is a URL and you can pass parameters, that is the concept of a drill url.
I have an example with a drill url added to UDA source adaptor, I did have an issue if I tried to put the full url as it seems to generate multiple http://serverrname when opening the new browser window.
Drill Through to Source
A new window is opened and the parameters passed in.
I am not going to get into the debate you are having with Oracle, I have just shown a working example and I am going to leave it there as this post is going on and on.
Could pls send me the URL that you are using....!
Why you can get an idea of it from the screenshot and unless you are using ORDs it will be no use to you.
This is for just ref I was asking and the screen shot which is partially visible, nope, I will browse and try my best.