We’re thinking about implementing a data warehouse with Ellucian Banner. ODS is an option but wondering what others have done?
Also wondering what are options for Dashboards and WEBI without a data warehouse. Is it possible? We have BOE XI 3.1 SP3 and our primary datasource is Ellucian Banner on Oracle 11g.
sanmac (BOB member since 2011-07-19)
I would build the data warehouse, performance will be poor if you just map a universe over an ODS. It will also deteriorate over time as you have more data within the ODS structure.
Warehouses / star schemas on the other hand can be partitioned over time and are structures designed for query optimisation.
Dashboards require highly aggregated data sets, so you would ideally require aggregates for these. Webi reports also perform better with aggregates also.
Mak 1 
(BOB member since 2005-01-06)