I am using Helical Insight Application Enterprise Edition Version 2.0, I have installed postgres_fdw (foreign-data wrapper) in my postgres database. I need to create adhoc report using it, Is it possible to do so?
Yes, This is possible, create adhoc report if you have installed postgres_fdw in your postgres database. You need to create “view” inside metadata. In that view you can define the relavant query which can also contains joining conditions, filtering conditions etc. Use this metadata view to create Adhoc reports.