Follow up question: if greenplum prod environment does not provide a data analytics schema or separate environment for DA purpose, is there any other ways to implement the reports logic (customized views and tables directly feed to the reports only) else where?. (Purpose here is to central library shared by all reports.)
greenplum will work out of the box with any BI tool, most often I see tableau, MicroStrategy, cognos, power bi, etc. anything that your end users are comfortable with and that you have today will work (via straight jdbc/odbc) and many tools have greenplum specific drivers.
Head of Data for Pivotal