Flylib.com
Professional SQL Server Analysis Services 2005 with MDX (Programmer to Programmer)
Professional SQL Server Analysis Services 2005 with MDX (Programmer to Programmer)
ISBN: 0764579185
EAN: 2147483647
Year: 2004
Pages: 176
Authors:
Sivakumar Harinath
,
Stephen R. Quinn
BUY ON AMAZON
Table of Contents
Back Cover
Professional SQL Server Analysis Services 2005 with MDX
Introduction
What This Book Covers
How This Book Is Structured
What You Need to Use This Book
Conventions
Source Code
Errata
http:p2p.wrox.com
Section I: Introduction
Chapter 1: Introduction to Data Warehousing and Analysis Services 2005
Key Elements of a Data Warehouse
Inmon Versus Kimball Different Approaches
Business Intelligence Is Data Analysis
Analysis Services 2005
The Unified Dimensional Model
Summary
Chapter 2: First Look at Analysis Services 2005
Differences between Analysis Services 2000 and Analysis Services 2005
Upgrading to Analysis Services 2005
Using the Business Intelligence Development Studio
Using SQL Server Management Studio
Querying Using the MDX Query Editor
Summary
Chapter 3: Introduction to MDX
Fundamental Concepts
MDX Query
MDX Expressions
Operators
MDX Functions
Summary
Chapter 4: Working with Data Sources and Data Source Views
Data Source Views
Data Source Views in Depth
Multiple Data Sources within a DSV
Summary
Chapter 5: Dimension Design
Working with the Dimension Editor
Browsing the Dimension
Sorting Members of a Level
Optimizing Attributes
Defining Translations in Dimensions
Creating a Snowflake Dimension
Creating a Time Dimension
Creating a Parent-Child Hierarchy
Summary
Chapter 6: Cube Design
Creating a Cube using Cube Wizard
Cube Dimensions
Measures and Measure Groups
Calculated Members
Creating Perspectives
Creating Translations
Browsing Perspectives and Translations
Summary
Section II: Advanced Topics
Chapter 7: Advanced Topics in MDX
Restricting Cube SpaceSlicing Cube Data
Removing Empty Cells
Filtering Members on Axes
Ranking and Sorting
Parameterize Your Queries
New MDX Functions
Summary
Chapter 8: Advanced Dimension Design
Custom Rollups
Enhancements to Parent-Child Hierarchies
Using Properties to Customize Dimensions
Dimension Intelligence using the Business Intelligence Wizard
Server Time Dimension
Dimension Writeback
Summary
Chapter 9: Advanced Cube Design
Adding and Enhancing Dimensions
Adding Calculations to Your Cube
Key Performance Indicators (KPIs)
Drill-Through
Adding Intelligence to the Cube
Working with Partitions
Defining Security
Summary
Chapter 10: Extending MDX using External Functions
COM User Defined Functions
Built-in COM UDFs
.NET User Defined Functions (Stored Procedures)
COM UDFs vs .NET Assemblies
Summary
Section III: Administration, Performance Tuning Integration
Chapter 11: Updating Your UDM Data
Updating Your Cube Data
Summary
Chapter 12: Administering Analysis Services
Online Mode
Administration via Programming
HTTP Connectivity to Analysis Services
Legacy DSO Applications
Analysis Services and Fail-over Clustering
Summary
Chapter 13: Performance Optimization
Optimizing UDM Design
Optimize for Processing
Query Performance Improvement
Scalability Optimizations
Using Profiler to Analyze Performance
Summary
Chapter 14: Data Mining
The Data Mining Process
Real-World Applications
Data Mining Algorithms in Analysis Services 2005
Working with Mining Models
Summary
Chapter 15: Analyzing Cubes using Office Client Components
Creating Local Cubes from Excel
Office Web Component Pivot Table
Analyzing UDM Data using Microsoft Data Analyzer
Summary
Chapter 16: Integration Services
Creating an Integration Services Project
Creating Integration Services Packages for Analysis Services Operations
Automating SSIS Packages
Summary
Section IV: Scenarios
Chapter 17: Reporting Services
Report Designer
Report Server
Creating a Report on Relational Database
Creating Reports Based on a UDM
Managing Your Analysis Services Reports
Ad-Hoc Reports using Report Builder
Summary
Chapter 18: Designing Real-Time Cubes
Proactive Caching
Proactive Caching at Work
Long Latency Scenario
Average Latency Scenario
No Latency Scenario
Summary
Chapter 19: Securing Your Data in Analysis Services
Securing Your Source Data
Securing Your Dimension Data
Securing your Cube Data
Summary
Appendix A: MDX Function and Operator Reference
Basic Operators
Index
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
List of Figures
List of Tables
List of Code Examples
Professional SQL Server Analysis Services 2005 with MDX (Programmer to Programmer)
ISBN: 0764579185
EAN: 2147483647
Year: 2004
Pages: 176
Authors:
Sivakumar Harinath
,
Stephen R. Quinn
BUY ON AMAZON
Qshell for iSeries
The Exit Status and Decision-Making
Path-Name Expansion
Grep
Writing Programs for Qshell
C and C++ Development Tools
FileMaker Pro 8: The Missing Manual
Organizing and Editing Records
Layout Basics
Scripting for Fields
Printing
Developer Utilities
Cisco Voice Gateways and Gatekeepers
Applications for Connecting to an IP WAN
Review Questions
Determining the DSP Resources Required
Configuring DSP Resources
Appendix A. Answers to Chapter-Ending Review Questions
Lotus Notes Developers Toolbox: Tips for Rapid and Successful Deployment
Design Tabs
Working with Layout Regions
Variables
Change Document to Edit Mode
Miscellaneous Enhancements
Java Concurrency in Practice
Liveness and Performance
Blocking Queues and the Producer-consumer Pattern
Part II: Structuring Concurrent Applications
Other Forms of Single-threaded Subsystems
Thinking about Performance
Telecommunications Essentials, Second Edition: The Complete Global Source (2nd Edition)
Satellite
Data Communications Basics
LAN Basics
Internet Basics
The Optical Edge
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies