当前位置:首页 > 技术专区 >

MDX 如何 翻译 转换 为 SQL 脚本

看微软的文档即可,本地如果安装msdn教全也有:

地址: http://msdn.microsoft.com/en-us/library/ms719711(VS.85).aspx
 
Mapping MDX to SQL Statements
 
The mappings described in this section assume that the cube is stored as a set of tables in an SQL schema. A precise specification of the mappings requires a correspondingly precise specification of the structure of the tables that constitute a cube. One such representation is detailed here, but there are many possible ways in which a cube can be represented as a set of tables. Discussion of which particular representation is the most efficient is beyond the scope of this section. If the representations differ, it is not difficult to alter mappings to accommodate the differences.
或分析Mondrian源码.
如需理论思路,查找sql Grouping实现olap相关论文