Một số các tài liệu của Microsoft về datawarehouse

Discussion in 'Giải pháp ERP, CRM, EPM and BI' started by bsdinsight, Jul 11, 2014.

  1. bsdinsight

    bsdinsight Well-Known Member

    Data Mining Extensions (DMX) Reference

    Data Mining Extensions (DMX) is a language that you can use to create and work with data mining models in Microsoft SQL Server Analysis Services. You can use DMX to create the structure of new data mining models, to train these models, and to browse, manage, and predict against them. DMX is composed of data definition language (DDL) statements, data manipulation language (DML) statements, and functions and operators.

    data mining extensions reference.png
     

    Attached Files:

  2. Loading...


  3. bsdinsight

    bsdinsight Well-Known Member

    Multidimensional Expressions (MDX) Reference

    Multidimensional Expressions (MDX) is the query language that you use to work with and retrieve multidimensional data in Microsoft Analysis Services. MDX is based on the XML for Analysis (XMLA) specification, with specific extensions for SQL Server Analysis Services. MDX utilizes expressions composed of identifiers, values, statements, functions, and operators that Analysis Services can evaluate to retrieve an object (for example a set or a member), or a scalar value (for example, a string or a number).

    multidimensional expressions (mdx) reference.png
     

    Attached Files:

  4. bsdinsight

    bsdinsight Well-Known Member

    Analysis Services Tutorial

    Welcome to the Analysis Services Tutorial. This tutorial describes how to use SQL Server Data Tools to develop and deploy an Analysis Services project, using the fictitious company Adventure Works Cycles for all examples. What You Will LearnIn this tutorial, you will learn the following:
    • How to define data sources, data source views, dimensions, attributes, attribute relationships, hierarchies, and cubes in an Analysis Services project within SQL Server Data Tools.
    • How to view cube and dimension data by deploying the Analysis Services project to an instance of Analysis Services, and how to then process the deployed objects to populate them with data from the underlying data source.
    • How to modify the measures, dimensions, hierarchies, attributes, and measure groups in the Analysis Services project, and how to then deploy the incremental changes to the deployed cube on the development server.
    • How to define calculations, Key Performance Indicators (KPIs), actions, perspectives, translations, and security roles within a cube.

    A scenario description accompanies this tutorial so that you can better understand the context for these lessons

    Analysis Services Tutorial.png
     

Share This Page