I am new to the TRIRIGA Real Estate Environmental Sustainability (TREES) module. We are planning to bring the data from another database to our metric table. Can anyone share the document which can help me to load the data from an Oracle Database to the fact BO? Thanks in advance.
TREES is expecting the sustainability data to be organized in the energy logs (carbon, emission, water, etc.) per building per month. You will probably want to use DataConnect (DC) to set up staging tables and via DC job insert and associate the data in the appropriate logs. Once the data is in the logs, the TREES ETL would build your fact tables. Calendar Period is a classification and has its own unique format that you need to map (that you can do via workflow). Energy Type is also a classification that will need to be mapped accordingly…
TRIRIGAFEEDIA 