Power Pivot是多维的吗? [英] Is Power Pivot Multi Dimensional?

问题描述

我在Excel中创建了一个多维数据透视表，然后使用以下添加项生成了MDX: http://olappivottableextend.codeplex.com/releases/view/618637

I created a multi dimensional pivot table in Excel and then used the following add on to generate the MDX: http://olappivottableextend.codeplex.com/releases/view/618637

MDX由Excel生成，如下所示:

The MDX was generated by Excel as follows:

SELECT NON EMPTY Hierarchize(DrilldownMember({{{DrilldownLevel({[Customer].[Customer Geography].[All]},,,INCLUDE_CALC_MEMBERS)}}}, {[Customer].[Customer Geography].[State Province].&[New South Wales]&[Australia]},,,INCLUDE_CALC_MEMBERS)) DIMENSION PROPERTIES PARENT_UNIQUE_NAME,HIERARCHY_UNIQUE_NAME,[Customer].[Customer Geography].[State Province].[Country-Region],[Customer].[Customer Geography].[City].[State Province] ON COLUMNS , NON EMPTY Hierarchize({DrilldownLevel({[Customer].[FullName].[All]},,,INCLUDE_CALC_MEMBERS)}) DIMENSION PROPERTIES PARENT_UNIQUE_NAME,HIERARCHY_UNIQUE_NAME ON ROWS  FROM [Adventure Works DW2012] WHERE ([Measures].[Sales Amount]) CELL PROPERTIES VALUE, FORMAT_STRING, LANGUAGE, BACK_COLOR, FORE_COLOR, FONT_FLAGS

然后我打开Power Pivot窗口并复制并粘贴MDX.它生成了二维数据结构.

I then opened the Power Pivot windows and copied and pasted the MDX. It generated a two dimensional data structure.

我意识到Power Pivot可用是因为Excel中的最大行限制，即它可以处理更多行. Power Pivot只是二维数据源吗?也就是说，它用于将所有数据收集到一个位置，以便可以使用标准数据透视表从多维角度分析数据?

I realise that Power Pivot is available because of the max row limitation in Excel i.e. it can deal with more rows. Is Power Pivot just a two dimensional data source? i.e. it is used to get all of the data into one place so that a standard Pivot Table can be used to analyse the data from a multi dimensional perspective?

推荐答案

这是使用mdx的数据透视表.数据透视表与olap大约在同一时间出现-它们使用相同的技术.我认为，即使我们创建一个数据透视表并将其指向服务器端表格模型，xl数据透视表仍将在mdx中讨论.

It is the pivot table which is using mdx. Pivot tables came about around the same time as olap - they use the same technology. I think even if we create a pivot and point it at a server-side tabular model then the xl pivot will still be talking in mdx.

因此，无论数据源如何，数据透视表都需要使用mdx.

So the pivot table needs to work with mdx irrespective of the data source.

Power Pivot和表格模型使用一种称为DAX的语言.表格使用分析服务，但不同于多维....它是表格[em>表格

Power Pivot and Tabular models use a language called DAX. Tabular uses analysis services but is different from multi-dimensional .... it is tabular

这篇关于Power Pivot是多维的吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！