The Resource Fast track to MDX, Mark Whitehorn, Robert Zare, and Mosha Pasumansky, (electronic resource)

Fast track to MDX, Mark Whitehorn, Robert Zare, and Mosha Pasumansky, (electronic resource)

Label
Fast track to MDX
Title
Fast track to MDX
Statement of responsibility
Mark Whitehorn, Robert Zare, and Mosha Pasumansky
Creator
Contributor
Provider
Subject
Language
eng
Summary
OLAP (On-Line Analytical Processing) is the most powerful Business Intelligence tool currently available and Microsoft's Analysis Manager makes OLAP cubes incredibly easy to build and deploy. However the real power of OLAP lies in its ability to help you solve real-life business problems; to release that power you need to use the language that controls the cubes and allows them to be queried. That language is MDX (Multi Dimensional eXpressions). Fast Track to MDX gives you all the necessary background to let you to write useful, powerful MDX expressions and introduces the most frequently used MDX functions and constructs. No prior knowledge is assumed and examples are used throughout the book to rapidly develop your MDX skills to the point where you can solve real business problems. Mark Whitehorn, co-author of the best-selling Inside Relational Databases, is renowned for his knowledge of database systems and the lucidity of his writing. Robert Zare is a Program Manager for Analysis Services at Microsoft: his inspiring talks on MDX sowed the seeds from which this book grew. Mosha Pasumansky was one of the authors of the OLEDB for OLAP specification that defined the MDX language and later he was the developer in charge of the first implementation of MDX in the Microsoft OLAP Services 7.0 product. He is currently the development lead of the Analysis Services engine team. Second Edition – It was the clarity, precision and sheer readability of the first edition that made it a best-seller. With that firmly in mind the authors have left the original 18 chapters intact (apart from minor updates); meaning that the second edition remains the best introduction to MDX that is available. What they have done is to add three brand new chapters. These introduce the topic of recursion in MDX, walk the reader through the process of creating recursive expressions and finally demonstrate how recursion can be used to effectively solve a series of business problems. Forward by Amir Netz, Product Unit Manager, SQL Server – Analysis Services at Microsoft
Member of
Cataloging source
COO
http://library.link/vocab/creatorDate
1953-
http://library.link/vocab/creatorName
Whitehorn, Mark
Image bit depth
0
LC call number
QA76.73.M39
LC item number
W48 2006
Literary form
non fiction
Nature of contents
dictionaries
http://library.link/vocab/relatedWorkOrContributorDate
  • 1974-
  • 1970-
http://library.link/vocab/relatedWorkOrContributorName
  • SpringerLink
  • Zare, Robert
  • Pasumansky, Mosha
http://library.link/vocab/subjectName
  • MDX (Computer program language)
  • OLAP technology
  • COMPUTERS
  • COMPUTERS
  • COMPUTERS
  • Informatique
  • MDX (Computer program language)
  • OLAP technology
  • Programmeertalen
  • Databanken
Label
Fast track to MDX, Mark Whitehorn, Robert Zare, and Mosha Pasumansky, (electronic resource)
Instantiates
Publication
Note
Includes index
Antecedent source
mixed
Carrier category
online resource
Carrier category code
cr
Carrier MARC source
rdacarrier
Color
not applicable
Content category
text
Content type code
txt
Content type MARC source
rdacontent
Contents
Readme.doc — definitions you need to know -- How MDX is used -- MDX queries -- MDX syntax -- MDX expressions -- Navigating the hierarchy -- Snapshot data analysis -- Moving averages -- Filters -- Setting the default member -- Member properties and dimension security -- Distinct Count -- Parent-Child dimensions -- Advanced data modeling — Custom Order, Custom Rollup, Custom Members -- Further advanced data modeling techniques -- Actions -- Server side color coding -- More about querying
Dimensions
unknown
Edition
2nd ed.
Extent
1 online resource (xxv, 309 pages)
File format
multiple file formats
Form of item
  • online
  • electronic
Isbn
9781846281747
Level of compression
uncompressed
Media category
computer
Media MARC source
rdamedia
Media type code
c
Other physical details
illustrations
Quality assurance targets
absent
Reformatting quality
access
Specific material designation
remote
System control number
  • (OCoLC)262691002
  • (OCoLC)ocn262691002
Label
Fast track to MDX, Mark Whitehorn, Robert Zare, and Mosha Pasumansky, (electronic resource)
Publication
Note
Includes index
Antecedent source
mixed
Carrier category
online resource
Carrier category code
cr
Carrier MARC source
rdacarrier
Color
not applicable
Content category
text
Content type code
txt
Content type MARC source
rdacontent
Contents
Readme.doc — definitions you need to know -- How MDX is used -- MDX queries -- MDX syntax -- MDX expressions -- Navigating the hierarchy -- Snapshot data analysis -- Moving averages -- Filters -- Setting the default member -- Member properties and dimension security -- Distinct Count -- Parent-Child dimensions -- Advanced data modeling — Custom Order, Custom Rollup, Custom Members -- Further advanced data modeling techniques -- Actions -- Server side color coding -- More about querying
Dimensions
unknown
Edition
2nd ed.
Extent
1 online resource (xxv, 309 pages)
File format
multiple file formats
Form of item
  • online
  • electronic
Isbn
9781846281747
Level of compression
uncompressed
Media category
computer
Media MARC source
rdamedia
Media type code
c
Other physical details
illustrations
Quality assurance targets
absent
Reformatting quality
access
Specific material designation
remote
System control number
  • (OCoLC)262691002
  • (OCoLC)ocn262691002

Library Locations

  • African Studies LibraryBorrow it
    771 Commonwealth Avenue, 6th Floor, Boston, MA, 02215, US
    42.350723 -71.108227
  • Alumni Medical LibraryBorrow it
    72 East Concord Street, Boston, MA, 02118, US
    42.336388 -71.072393
  • Astronomy LibraryBorrow it
    725 Commonwealth Avenue, 6th Floor, Boston, MA, 02445, US
    42.350259 -71.105717
  • Fineman and Pappas Law LibrariesBorrow it
    765 Commonwealth Avenue, Boston, MA, 02215, US
    42.350979 -71.107023
  • Frederick S. Pardee Management LibraryBorrow it
    595 Commonwealth Avenue, Boston, MA, 02215, US
    42.349626 -71.099547
  • Howard Gotlieb Archival Research CenterBorrow it
    771 Commonwealth Avenue, 5th Floor, Boston, MA, 02215, US
    42.350723 -71.108227
  • Mugar Memorial LibraryBorrow it
    771 Commonwealth Avenue, Boston, MA, 02215, US
    42.350723 -71.108227
  • Music LibraryBorrow it
    771 Commonwealth Avenue, 2nd Floor, Boston, MA, 02215, US
    42.350723 -71.108227
  • Pikering Educational Resources LibraryBorrow it
    2 Silber Way, Boston, MA, 02215, US
    42.349804 -71.101425
  • School of Theology LibraryBorrow it
    745 Commonwealth Avenue, 2nd Floor, Boston, MA, 02215, US
    42.350494 -71.107235
  • Science & Engineering LibraryBorrow it
    38 Cummington Mall, Boston, MA, 02215, US
    42.348472 -71.102257
  • Stone Science LibraryBorrow it
    675 Commonwealth Avenue, Boston, MA, 02445, US
    42.350103 -71.103784
Processing Feedback ...