I am looking to load the active users from OBIEE to a Learning Management System and trying to fit the required criteria. I want to set up a scheduled job that fits the LMS requirements.

Thanks for following up. Yes, i do want to feed OBIEE data into another app. Can you advise there is a tool that can connect to OBIEE , export it, and deliver to SFTP? I would also like to connect to the OBIEE database from the backend and write queries instead of creating reports through the web broswer(frontend).

Thanks for the followup, is there other options to add a second level header for CSV format?