这种sql看不懂

[handyzhu]

在报表中出现的 好像不是sql语句
SELECT NON EMPTY { [Measures].[Is Data], [Measures].[Happen Money] } ON COLUMNS, NON EMPTY { ([Dim Time].[The Year].[The Year].ALLMEMBERS * [Dim Time].[Quarter Of Year].[Quarter Of Year].ALLMEMBERS * [Dim Time].[Month Of Year].[Month Of Year].ALLMEMBERS * [Fee Type].[Fee Type Catalog Name].[Fee Type Catalog Name].ALLMEMBERS * [Department].[Catalog Name].[Catalog Name].ALLMEMBERS * [Department].[Dep Name].[Dep Name].ALLMEMBERS * [Department].[Department].[Department].ALLMEMBERS * [Department].[Department Catalog].[Department Catalog].ALLMEMBERS * [Department].[Total ID].[Total ID].ALLMEMBERS * [Department].[Top Dep].[Top Dep].ALLMEMBERS * [Fee Type].[Fee Type Catalog].[Fee Type Catalog].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( -{ [Department].[Dep Name].&[PVP海外], [Department].[Dep Name].&[PVP金融], [Department].[Dep Name].&[PVP欧美] } ) ON COLUMNS FROM ( SELECT ( -{ [Department].[Catalog Name].&[PVP], [Department].[Catalog Name].&[总裁室] } ) ON COLUMNS FROM ( SELECT ( -{ [Fee Type].[Fee Type Catalog Name].&[行业国内出差费用], [Fee Type].[Fee Type Catalog Name].&[行业海外出差费用] } ) ON COLUMNS FROM [Project DW]))) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS

[LongRui888]

mdx 多维查询语言，用来查询 cube 主题的，是微软的ssas中用到的

[TFXu]

MDX语言，在OLAP应用中用于查询多维数据集，如果你会基本的SQL语句，看完MDX的百度百科介绍，你基本上也就会用了，很简单的，自己去看吧，多说无益。 http://baike.baidu.com/link?url=cBltHsv_xVdKYh02s3f3raDkIunfug3YaXIjVJxKQK2UTJ2SYqnfU7DdwSkBNLaWnJSyPqy6NZaYoDFVdFdll_