Post on 29-May-2018
8/8/2019 OLAP Presentation 2001
1/18
OLAP TOOLSOLAP TOOLS
Alex Barfield
Jechand Chennupati
John OToole
Shantea Stanford
Marc Tardif
8/8/2019 OLAP Presentation 2001
2/18
AgendaAgenda
OLAP Overview
OLAP Concerns & ProClarity Background
How ProClarity Works How to Use ProClarity
Hands-on Exercise
Decomposition Tree Demo
Example Query
Quiz!!!
8/8/2019 OLAP Presentation 2001
3/18
The FASMI TestThe FASMI Test
FastSystem delivers responses to users withinroughly 5 seconds
Analysis System copes with relevant business
logic and statistical analysis, yet is simple enoughfor target user
SharedSystem handles multiple updates in asecure and timely manner
Multidimensional
A conceptual view of the dataalong several dimensions
Information All data and derived informationneeded, capacity measured by how much inputdata can be handled
8/8/2019 OLAP Presentation 2001
4/18
More OLAP FeaturesMore OLAP Features Cubes - Typically, cubes of data are examined
along X, Y, and Z axes
Dicing- Data diced in a range specified for eachdimension
Drill-down/Roll-up - Data can be disaggregated(drill-down) or aggregated (roll-up) along a
dimension Slicing- Data can be rotated to produce different
views or slices of a cube for analysis
8/8/2019 OLAP Presentation 2001
5/18
OLAP ApplicationsOLAP Applications Marketing/SalesAnalysis Consumer goods,
retailers, financial services
ClickstreamAnalysis e-commerce sites inconstant redesign based on analysis
FinancialReporting/Consolidation Accounts,org. structure, time, actual/budget/forecast,business line/product line = 5 or 6 dimensions
8/8/2019 OLAP Presentation 2001
6/18
OLAP MarketOLAP Market
8/8/2019 OLAP Presentation 2001
7/18
OLAP Market NichesOLAP Market Niches
Application OLAPComplete applications or
toolkits from which complex applications can be
built, integration and high functionality,
complexity and high cost per user
MOLAPUnbundled, high performance
multidimensional or hybrid databases, multi-userupdating, applications handled are smaller than
ROLAP
8/8/2019 OLAP Presentation 2001
8/18
OLAP Market NichesOLAP Market Niches
DOLAPClient-based OLAP products, easy to
deploy and low cost per seat, limited functionality
and capacity
ROLAPData and metadata in a RDBMS, none
stored in external files, large data volumes,
complex and expensive, slow query performance,smallest OLAP niche by far
8/8/2019 OLAP Presentation 2001
9/18
PricingPricing
Hyperions Essbase - $25,000, includes 10licenses
Microsofts SQL Server - $5,000 (StandardEdition) and $20,000 (Enterprise Edition)
Cognos - ~$1,200 per seat
ProClarity - $495 per seat + 20% maintenance fee
8/8/2019 OLAP Presentation 2001
10/18
OLAP CompetitorsOLAP Competitors
2000 1999 1998
Vendor Rank Share Rank Share Rank Share
Hyperion 1 22.3% 1 23.0% 1 28.7%
Cognos 2 12.6% 3 11.1% 3 9.6%
Microsoft 3 11.7% 5 7.6% - -
Oracle 4 10.1% 2 11.4% 2 17.0%
MicroStrategy 5 9.2% 4 7.9% 4 6.5%
8/8/2019 OLAP Presentation 2001
11/18
OLAP CompetitorsOLAP Competitors
2000 1999 1998
Vendor Rank Share Rank Share Rank Share
Bus. Objects 6 6.2% 6 5.3% 6 4.4%
Applix 7 3.0% 8 3.1% 10 2.5%
IBM 8 2.6% 9 3.0% 13 1.9%
Comshare 9 2.5% 7 3.2% 5 4.8%
PwC/Cartesis 10 2.3% 11 2.5% 12 2.1%
8/8/2019 OLAP Presentation 2001
12/18
OLAP CompetitorsOLAP Competitors
2000 1999 1998
Vendor Rank Share Rank Share Rank Share
SAS Institute 11 1.6% 12 2.2% 8 3.6%
Brio Tech. 12 1.5% 14 1.5% 15 1.1%
Seagate Soft. 13 1.4% 13 1.7% 7 2.9%
Adaytum 14 1.1% 17 1.0% 17 0.8%
CA 15 0.9% 10 2.8% 9 2.9%
8/8/2019 OLAP Presentation 2001
13/18
OLAP ConcernsOLAP Concerns
CompanyPolitics - Much more troubling than
product issues
Environmental Failure to agree on (and stick
to the agreed) requirements
Quality Poor data quality and unavailable data
8/8/2019 OLAP Presentation 2001
14/18
OLAP ConcernsOLAP Concerns Slow QueryPerformance Most commonly
reported product-related problem
Reliability Relatively few sites report problems,but the more expensive products had the mostreported problems
Results Higher priced products did notnecessarily achieve better results than lower-priced options
8/8/2019 OLAP Presentation 2001
15/18
The Microsoft EffectThe Microsoft Effect BundlingMS-OLAP bundled with its low-priced
SQL Server
CostMS product is low cost yet scalable, builds
cubes quickly with good query response time
MarketingOLAP software should proliferate
due to Microsofts marketing network
8/8/2019 OLAP Presentation 2001
16/18
Increased OLAP UsageIncreased OLAP Usage CommodityPosition MS-OLAP will likely
transition OLAP software into a commodity
Choice Many will choose MS-OLAP on price,
ease of use, and availability
New users These will represent the OLAP
move from specialist boutique to a mass market
8/8/2019 OLAP Presentation 2001
17/18
ProClarityProClarity Accessible Founded in 1995 to make OLAP
accessible to broader business market
ExperiencedConsulting, traning, and market-development staff (US & Europe)
Legitimate Over250 corporate customers, 30independent software vendor partners, and closelylinked with Microsoft
8/8/2019 OLAP Presentation 2001
18/18
ProClarity/MS PartnershipProClarity/MS Partnership Familiarity ProClarity provides analysis tools in
the context of MS Office 2000, Outlook Digital
Dashboard, IE LiveReportingWith familiar MS &
ProClarity products, decision-makers can query
their data to do live reporting
Corporate Goal Give decision-makers a clear
understanding of the drivers of their organizations
performance