Practical MDX Queries: For Microsoft SQL Server Analysis Services 2008 (Paperback)
暫譯: 實用 MDX 查詢：針對 Microsoft SQL Server Analysis Services 2008

Art Tennick

Practical MDX Queries: For Microsoft SQL Server Analysis Services 2008 (Paperback)
  • 出版商: McGraw-Hill Education
  • 出版日期: 2010-06-14
  • 售價: $2,270
  • 貴賓價: 9.5 折 $2,157
  • 語言: 英文
  • 頁數: 304
  • 裝訂: Paperback
  • ISBN: 0071713360
  • ISBN-13: 9780071713368
  • 相關分類: MSSQL、SQL

    • 已過版

買這商品的人也買了...

商品描述

300+ ready-to-use, powerful MDX queries

This hands-on guide shows you how to use Multi-Dimensional Expressions (MDX) to extract business intelligence from multi-dimensional cubes. Practical MDX Queries contains more than 300 downloadable MDX queries that can be applied across a wide variety of business intelligence-related problems. The use, syntax, and results of each query are described in detail. The book emphasizes MDX for use with SSAS within SSMS, but the techniques and queries also apply to SSRS, SSIS, MDX in SQL, MDX in DMX, MDX in XMLA, WinForms, WebForms, PerformancePoint Server, ProClarity, and many third-party applications.

  • Work with dimensions, hierarchies, levels, and members
  • Navigate both horizontally and vertically across dimensions and hierarchies
  • Sort the results of your queries
  • Access subsets of dimension members and measure values using the Where clause and Filter function
  • Use MDX query calculations
  • Extract and manipulate dates and times
  • Produce totals, subtotals, and changes cross time using aggregate and other functions
  • Create, visualize, and manipulate sets
  • Work with perspectives, subselects, and subcubes
  • Display and hide empty cells
  • Use, modify, format, and create Key Performance Indicators (KPIs)
  • Deliver MDX query results to end users

商品描述(中文翻譯)

300+ 個可立即使用的強大 MDX 查詢

本實用指南展示了如何使用多維表達式 (Multi-Dimensional Expressions, MDX) 從多維立方體中提取商業智慧。《實用 MDX 查詢》包含超過 300 個可下載的 MDX 查詢，這些查詢可以應用於各種與商業智慧相關的問題。每個查詢的使用、語法和結果都詳細描述。本書強調在 SQL Server Management Studio (SSMS) 中與 SQL Server Analysis Services (SSAS) 一起使用 MDX，但這些技術和查詢同樣適用於 SQL Server Reporting Services (SSRS)、SQL Server Integration Services (SSIS)、SQL 中的 MDX、DMX 中的 MDX、XMLA 中的 MDX、WinForms、WebForms、PerformancePoint Server、ProClarity 以及許多第三方應用程式。

- 與維度、層級、級別和成員一起工作
- 在維度和層級之間水平和垂直導航
- 對查詢結果進行排序
- 使用 Where 子句和 Filter 函數訪問維度成員和度量值的子集
- 使用 MDX 查詢計算
- 提取和操作日期和時間
- 使用聚合和其他函數生成總計、小計和時間變化
- 創建、可視化和操作集合
- 與視角、子選擇和子立方體一起工作
- 顯示和隱藏空單元格
- 使用、修改、格式化和創建關鍵績效指標 (KPI)
- 將 MDX 查詢結果交付給最終用戶

類似商品