Transcript BIC305 MOLAP Enterprise Priorities Prototyping Flexibility Metadata ROLAP Data Stewardship Software Contracts Data Dictionary Diverse Client Base POC Performance Governance ETL/BI Standards Capacity Cache Strategies HOLAP Microsoft BI POC Environment Telus-SRV2: SharePoint Server 2007 2 Quad Core Processors, 16GB RAM Telus-SRV3: SQL Sever.

BIC305
MOLAP
Enterprise Priorities
Prototyping
Flexibility
Metadata
ROLAP
Data Stewardship
Software Contracts
Data Dictionary
Diverse Client Base
POC
Performance
Governance
ETL/BI
Standards
Capacity
Cache Strategies
HOLAP
Microsoft BI POC Environment
Telus-SRV2:
SharePoint Server 2007
2 Quad Core Processors,
16GB RAM
Telus-SRV3:
SQL Sever 2008, SSAS
4 Quad Core Processors,
32GB RAM
Telus-SRV1:
Oracle 10g Database Server
4 Quad Core Processors,
32GB RAM
Development Activity
Area of Focus
Adjusted
Value
Estimated Cost
Benefit (%)
Cost of Development Life Cycle Management
Development
Creating A Business Semantic Layer
Incremental Growth Strategy for Cubes
Single vs. Multiple Models
Shared/Conformed dimensions
Formulas & Calculations
Impact Analysis
Performance
MDX scripting
Federated Query Support - Report Level
0.00
10.00
10.00
20.00
-10.00
0.00
20.00
0.00
-10.00
4.44 0% to 25%
Testing
Multiple Front End Services
10.00
10.00
10.00 0% to 25%
Version Control
Deployment Workflow
10.00
0.00
5.00 0% to 25%
Hardware Infrastructure Acquisition (Windows/Intel))
10.00
Development Average
SIT/QA/UAT Testing
SIT/QA/UAT Testing Average
Deployment/Change Management
Deployment/Change Management Average
Sustainment/Support
Hardware Infrastructure Support/Maintenance
Sustainment/Support Average
0.00
5.00 0% to 25%
Area of Focus
Adjusted Estimated Cost
Value
Benefit (%)
Cost to the Business
Service Levels
Availability
0.00
Maintainability/Operability
0.00
Scalability
30.00
Performance
60.00
Extensibility
60.00
Service Levels Average
Usability
30.00 25% to 50%
Excel Reporting
Multi-Lingual Support
Usability Average
20.00
0.00
10.00 0% to 25%
Area of Focus
Adjusted Estimated Cost
Value
Benefit (%)
Cost to SBI
Training
Publically available resources
Formal training
Training Average
Complexity of Tool(s)
Number of Components
Customization and Flexibility
Architecture Scale Up, Out or Down
Platform Support
Complexity of Tool(s) Average
10.00
0.00
10.00
0.00
-20.00
0.00 0% to 25%
Customer support
Consulting services
Support/Knowledge Base Average
0.00
5.00 0% to 25%
Ease of Installation
Support/Knowledge Base
10.00
10.00
0.00
5.00 0% to 25%
TELUS Project
Details
HR Scorecard
• pilot project.
• evaluating trending/forecasting functionality
• modeling/predicting team member behaviour
• utilizing Reporting Services and SharePoint and Dashboard functionality.
Infrastructure Support Services
Migration: Current BI Cube Technology to Microsoft
IT Scorecard
Financial Data Mart
18
Sources
Back end
ETL Informatica
Front end
BI Server
(Analysis & Reporting
Services)
Database Server
(SQL Server)
Reports
Dimensions
& Facts
SAP
Server Repository
(Cache Static reports)
Summary
Scheduler
Rendering Reports
(Excel, HTML, Power
Point)
SharePoint
Security
Cubes
OLAP
Excel
Flat Files
Portal Navigation
SPEED
Places measures into tables based on dimensions in
database design for every hierarchy level
Hyperion Planning
Summary
3 yrs
Web Server
(Internet Information Server)
Excel 2007 Pivot
table
Hyperion Repository
XML or Flat Files
Power Users
• Staging area
• Integration Layer
• Data Quality & Integrity
19
20