Much appreciated Ashish. Looking forward to your article. I did try that option today and it seems to work. Personally it just feels like a work around solution and not a proper solution. Was just wondering how do I stream line this as an overall solution. Would you be passing parameters also from your HCM extract to the…

In addition to my last comment, I don't see any option to configure a new file based data source in BI Administration. Do we need any specific role?

Thanks Tim. I did try this previously and it does work when I try to load from my local folders. But I want this file to be constantly updated in each run with different sets of employee ids. Can we configure any File server as a data source or should we use only the Sample dat files and Demo files location that comes by…