Sold Out
Book Categories |
Acknowledgements Page iii
Introduction Page 1
CHAPTER 1 What’s New In Analysis Services Page 5
Cube Enhancements Page 6
Dimension Enhancements Page 8
Data Mining Enhancements Page 10
Security Enhancements Page 11
Client Connectivity Enhancements in PivotTable Service Page 12
Other Enhancements Page 12
CHAPTER 2 Installing Analysis Services Page 15
Hardware and Software Requirements for Installing Analysis Services Page 16
Running Setup Page 17
Setup Parameters and Silent Installation Page 19
Reinstalling Analysis Services Page 20
Stopping or Removing Analysis Services Page 21
Upgrading from an Earlier Version Page 21
Backward Compatibility Page 22
7.0 Analysis Services Client and Local Cube Support Page 23
Supported Migration Paths for Analysis Services Repositories Page 25
Archiving and Restoring Databases Between Versions of Analysis Services Page 26
CHAPTER 3 Analysis Services Architecture Page 27
Analysis Services Features Page 27
Ease of Use Page 28
Flexible Data Model Page 31
Scalability Page 34
Integration Page 36
Widely Supported APIs and Open Architecture Page 38
Server and Client Architecture Page 39
Server Architecture Page 39
Client Architecture Page 40
Object Architecture Page 42
Object Architecture Overview Page 43
Analysis Server Page 44
Databases Page 46
Data Sources Page 46
Dimensions Page 48
Levels and Members Page 76
Measures Page 87
Cells Page 101
Cubes Page 115
Partitions Page 136
Aggregations Page 148
Roles Page 150
Commands Page 154
Member Properties Page 159
Data Mining Models Page 164
Data Mining Columns Page 176
Security and Authentication Page 186
Administrator Security Page 187
End-User Security Page 188
Operational Considerations Page 229
CHAPTER 4 Data Warehousing and OLAP Page 233
About Data Warehouses Page 234
About OLAP Page 235
OLAP and Data Warehouses Page 235
Maintaining OLAP Data Page 237
CHAPTER 5 Administering Analysis Services Page 241
Before Administering Analysis Services Page 241
Administrative Tools Page 242
Analysis Manager Page 242
Using Active Directory with Analysis Services Page 248
Using Data Transformation Services with Analysis Services Page 249
Using MDX with Analysis Services Page 249
Msmdarch Command Page 250
Administrative Tasks Page 250
Configuring Analysis Servers Page 252
Creating Prerequisite Objects for Cubes Page 254
Building and Processing Cubes Page 261
Creating Security Roles Page 279
Managing Partitions Page 282
Enhancing Dimensions with Optional Features Page 289
Enhancing Cubes with Optional Features Page 296
Updating Cubes and Dimensions Page 315
Building and Using Data Mining Models Page 318
Archiving, Restoring, and Copying Data Page 328
Analyzing and Optimizing Performance Page 333
Automating and Scheduling Administrative Tasks Page 352
CHAPTER 6 Administrator’s Reference Page 361
Specifications and Limits Page 361
SQL Page 364
OLE DB Compliance Page 368
OLE DB for Data Mining Compliance Page 372
CHAPTER 7 Multidimensional Expressions (MDX) Page 377
MDX Overview Page 378
Introduction to MDX Page 378
Key Concepts in MDX Page 379
Comparison of SQL and MDX Page 383
Basic MDX Page 384
The Basic MDX Query Page 385
Members, Tuples, and Sets Page 387
Axis and Slicer Dimensions Page 393
Establishing Cube Context Page 396
Advanced MDX Page 397
Creating and Using Property Values Page 398
Building Named Sets in MDX Page 415
Building Calculated Members in MDX Page 418
Building Caches in MDX Page 426
Building Calculated Cells in MDX Page 428
Creating and Using UserDefined Functions in MDX Page 431
Using Writebacks Page 434
Using DRILLTHROUGH to Retrieve Source Data Page 436
Understanding Pass Order and Solve Order Page 437
Effective MDX Page 448
Comments in MDX Page 448
Working with Empty Cells Page 449
Creating a Cell Within the Context of a Cube Page 454
Working with the RollupChildren Function Page 455
WHERE Clause Overrides Page 457
MDX Functions in Analysis Services Page 458
MDX Function Reference Page 458
Registered Function Libraries Page 551
UserDefined Functions with MDX Syntax Page 554
CHAPTER 8 How To Perform Common Analysis Services Tasks Page 557
Configuring Analysis Servers Page 557
How to register an Analysis server Page 557
How to add a linked Analysis server using SQL Server Enterprise Manager Page 558
How to start the Migrate Repository Wizard Page 559
How to configure Analysis Services for the Web Page 559
Creating Cubes’ Prerequisite Objects Page 560
How to create a database Page 560
How to specify a data source Page 561
How to create a shared dimension using the Dimension Wizard Page 561
How to create a shared dimension using Dimension Editor Page 562
How to browse a shared dimension Page 563
How to browse a private dimension Page 563
How to create a virtual dimension based on member properties Page 563
How to create a virtual dimension based on columns Page 564
Building and Processing Cubes Page 566
How to start the Cube Wizard Page 567
How to build a cube with Cube Editor Page 567
How to create a private dimension Page 568
How to add a multiplecolumn measure to a cube Page 569
How to start the Virtual Cube Wizard Page 569
How to start the Storage Design Wizard Page 569
How to process a cube Page 570
How to process a virtual cube Page 570
How to view an SQL statement Page 571
How to change the temporary file folder used by Analysis Services Page 571
How to browse sample data in Cube Editor Page 571
Creating Security Roles Page 572
How to create a database role Page 572
How to create a cube role, change its default values, and specify cell security Page 574
How to create a mining model role and change its default values Page 578
How to create a custom rule for dimension security in a database role Page 579
How to create a custom rule for dimension security in a cube role Page 581
How to create a custom rule for cell security Page 584
Managing Cube Storage Page 584
How to start the Partition Wizard Page 585
How to process a partition Page 585
How to merge two partitions Page 585
How to specify a data source for a linked cube Page 586
How to create a linked cube Page 586
How to process a linked cube Page 587
Enhancing Dimensions Page 587
How to create a member property in a shared dimension Page 588
How to create a custom rollup operator for a shared dimension Page 588
How to create a custom rollup operator for a private dimension Page 589
How to create or select a column to store custom member formulas Page 591
How to create a custom member formula in a writeenabled dimension Page 592
How to create member groups Page 592
How to create a dimension with multiple hierarchies in the Dimension Wizard Page 594
How to create a dimension with multiple hierarchies in Dimension Editor Page 595
How to add a hierarchy to an existing dimension Page 596
Enhancing Cubes with Optional Features Page 597
How to create calculated cells Page 598
How to import calculated cells into a virtual cube Page 599
How to edit a calculated cells definition Page 599
How to rename a calculated member Page 600
How to create a calculated member in a regular cube Page 600
How to import a calculated member into a virtual cube Page 602
How to edit a calculated member in a virtual cube Page 602
How to create a calculated member in a virtual cube Page 603
How to create a named set in a regular cube Page 604
How to import a named set into a virtual cube Page 605
How to edit a named set in a virtual cube Page 605
How to create a named set in a virtual cube Page 606
How to create an action in a regular cube Page 606
How to import an action into a virtual cube Page 607
How to edit an action in a virtual cube Page 607
How to create an action in a virtual cube Page 608
How to test an action Page 608
How to writeenable a cube Page 609
How to browse writeback data for a cube Page 610
How to delete writeback data for a cube and writedisable it Page 610
How to convert a cube’s writeback data to a partition and writedisable the cube Page 610
How to specify drillthrough options for a regular cube Page 611
How to specify drillthrough options for a virtual cube Page 612
How to specify drillthrough options for a linked cube Page 613
How to specify drillthrough options for a partition Page 615
Updating Cubes and Dimensions Page 616
How to incrementally update a cube Page 616
How to refresh data in a cube Page 618
How to incrementally update a shared dimension Page 618
How to rebuild the structure of a shared dimension Page 618
Managing Data Mining Models Page 619
How to start the Mining Model Wizard Page 619
How to start Relational Mining Model Editor Page 620
How to start OLAP Mining Model Editor Page 620
How to process a data mining model Page 620
How to start Mining Model Role Manager Page 621
How to add a role to a data mining model Page 621
Archiving, Restoring, and Copying Data Page 622
How to archive an Analysis Services database using Analysis Manager Page 622
How to archive an Analysis Services database using the msmdarch command Page 623
How to restore an Analysis Services database using Analysis Manager Page 624
How to restore an Analysis Services database using the msmdarch command Page 625
How to copy and paste an object Page 626
Analyzing and Optimizing Performance Page 627
How to start the Usage Analysis Wizard Page 627
How to start the UsageBased Optimization Wizard Page 627
Automating and Scheduling Administrative Tasks Page 627
How to create an Analysis Services Processing task Page 628
How to create a Relational Data Mining Prediction Query task Page 629
INDEX Topics in the SQL Server 2000 Reference Library Page 631
Login|Complaints|Blog|Games|Digital Media|Souls|Obituary|Contact Us|FAQ
CAN'T FIND WHAT YOU'RE LOOKING FOR? CLICK HERE!!! X
You must be logged in to add to WishlistX
This item is in your Wish ListX
This item is in your CollectionMicrosoft SQL Server 2000 Reference Library
X
This Item is in Your InventoryMicrosoft SQL Server 2000 Reference Library
X
You must be logged in to review the productsX
X
X
Add Microsoft SQL Server 2000 Reference Library, Microsoft SQL Server 2000 dramatically reduces the time required to bring the most powerful e-commerce, data warehousing, and line-of-business applications to market. Microsoft SQL Server 2000 Reference Library provides the ideal set of reference materi, Microsoft SQL Server 2000 Reference Library to the inventory that you are selling on WonderClubX
X
Add Microsoft SQL Server 2000 Reference Library, Microsoft SQL Server 2000 dramatically reduces the time required to bring the most powerful e-commerce, data warehousing, and line-of-business applications to market. Microsoft SQL Server 2000 Reference Library provides the ideal set of reference materi, Microsoft SQL Server 2000 Reference Library to your collection on WonderClub |