BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Streamline and extend SAP BusinessObjects software 
Streamline and extend SAP BusinessObjects software (Opens a new window)  

General Notice: No events within the next 45 days.

Data Warehouse for Ellucian Banner


 
Search this topic... | Search General Discussion... | Search Box
Register or Login to Post    Forum Index -> General Discussion  Previous TopicPrint TopicNext Topic
Author Message
sanmac
Forum Member
Forum Member



Joined: 19 Jul 2011

Posts: 14



PostPosted: Mon Feb 11, 2013 8:28 am 
Post subject: Data Warehouse for Ellucian Banner

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.
Back to top
Mak 1
Forum Devotee
Forum Devotee



Joined: 06 Jan 2005

Posts: 11600
Location: London


flag
PostPosted: Mon Feb 11, 2013 8:33 am 
Post subject: Re: Data Warehouse for Ellucian Banner

Quote:
ODS is an option but wondering what others have done?


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.

Quote:
Also wondering what are options for Dashboards and WEBI without a data warehouse.


Dashboards require highly aggregated data sets, so you would ideally require aggregates for these. Webi reports also perform better with aggregates also.

_________________
Business Objects Versions 4,5,6, XI R2, 3.2, 4.1 SP3
Oracle, SQL Server, Sybase, Netezza, SAP BW.

Red Adair: "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur."
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> General Discussion  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0444 seconds using 17 queries. (SQL 0.0026 Parse 0.0345 Other 0.0073)
CCBot/2.0 (http://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo