Useful links - Abacus - Oracle BI Tools

Useful links

Abacus - Source to Access

https://abacus.is.ed.ac.uk/Browser/?p=Content%2FDiagrams%2F604322.html

Abacus logical data model for HR data

https://abacus.is.ed.ac.uk/Browser/?p=Content%2FCatalogues%2F540104.html

(updated by BI team with status for each data field / row) 

People & Money HR - useful links - knowledge base

Oracle BI tools packaged with the new People & Money system

OTBI (Oracle Transactional Business Intelligence) tool - will be widely used by many users

BI Publisher - limited to a small number of users for creation of standard letters and data extracts from People & Money to downstream systems incl the EDW datamarts - limited number of licences for P&M programme developers

Background information provided by Geraldine Rowe - People & Money reporting programme

The easiest way to see the data is in OTBI, but this doesn’t show you the oracle database table & field names. 

There’s no particularly easy way that I know of to marry the OTBI subject area fields to the database fields unfortunately. 

There is, however, Oracle documentation https://docs.oracle.com/en/cloud/saas/human-resources/20b/oedmh/index.html which may help?

--

There are also two recorded training sessions by Inoapps BI consultant which guide a user through the basics of the OTBI reporting tool:

There are 2 MS teams knowledge transfer sessions if you need any more info