@JohnW-Oracle , Thanks John, we were able to resolve this issue with SR.

@PRATHEEK, thanks for the follow-up. The issue was on my side. The connection was getting created in my folder by default. Never paid attention to this. Once I created the connection in the shared folder, the access option shows up.

Responded to your post. Please DM if you need additional information.

In FDR 2.0 there is an option to pick user table to refresh. Is your FDI environment integrated deployment or standalone?

For FDI there is a new connector being developed and its a roadmap item. One other option if you run into performance issue with existing FDI connector is to create groovy export of EPM and load the data into FDI

@Sushanta Chakraborty-Oracle, one work around I can think of is to check the status of Warehouse refresh date and time and trigger the back end jobs. The status is available in Common-Warehouse Refresh Statistics subject area.