|
|
o2olap |
Value Benefit |
Ease of Integration
|
|
Microsoft Excel |
- Spreadsheet client & modelling
- No macro development environment
|
- Reduced interface and training costs
- Reduced staff dependency
- Improved productivity
- Leverage existing knowledge
- Faster adoption
|
|
Microsoft Analysis Services & SQL Server |
- Market leading OLAP technology
- Most widely used relational database
- Automatic updating
|
- Huge expanding market
- Leverage platform investments
- Faster development
- Tested integration
- Improving functionality
- Scaleable applications
- Reduced data cost
- Reduced maintenance
|
|
Microsoft Office |
- Data links to Word and PowerPoint
|
- Same as for Excel above
- More complete systems
- Better data knowledge management
|
|
Macromedia’s RoboHelp or with Visual Studio help files |
Integrates help files |
Improved deployment times |
|
Development Languages |
API integration possible |
System developers can integrate functionality |
Ease of Use
|
|
Microsoft Excel |
- Flexible complete browser
- No specialist knowledge required (MDX or VBA programmer knowledge)
- Rapid application development (RAD)
- Template approach
- View management
- Improved general ledger integration
|
- Early adoption by users
- Leverage users existing Excel modeling knowledge
- Improved data access & querying
- Improved data presentation
- Reduced cost per transaction
- Reduced system maintenance
- Reduced solution times
- Improved organization knowledge
- Reduced spreadsheet proliferation
- Automated updating for changing structural changes
|
|
Analysis Services |
- Extended functionality
- Simplified Excel interface
- Excel interface to object model
- Excel based dimensions
- Blank cube creation
|
- Early adoption by users
- Reduced solution times
- Easier development
- Easier deployment
|
Finance and Analyst Capabilities
|
|
Microsoft Excel |
- Accounting and management reporting formats and input in one view
- Improved ad-hoc analysis and querying
- Writeback
- Dynamic modelling
- Improved general ledger integration
- Journaling
- Audit Trail
- Data mining and interrogation
- Ordering, ranking, sorting, exception reporting and querying
- Allocations
- Actions
- Excel graphic integration
- Drill-through to source data
- Structure drilling options
- Data cell commenting
- Data cell hyperlinking
- Multi-lingual
- Report
|
- Simpler and faster integration to general ledger and ERP applications
- Improved reporting output
- Improved data understanding
- Improved data analysis
- Improved data capture
- Improved data accuracy
- Improved data presentation
- Improve timeliness of data
- Improved performance
- Improved data mining functionality
- Exception reporting
- Improved budgeting and forecasting for ERP
- Data more available and accessible
- Flexible reporting that changes as organization structures change
- Improved decision making
- Simplified and lower risk OLAP modelling
- Better information
- Proactive and integrated systems
- Improved communication of data
|