WITH Member [ENGINE_SERIAL_NUM] AS[建造数据 Build Data].[发动机号 ESN].CurrentMember.membervalue
Member [BUILD_DATE] AS [建造数据 Build Data].[生产日期 Build Date].CurrentMember.membervalue
Member [USER_APPL_CODE]AS CoalesceEmpty([建造数据 Build Data].[发动机应用领域 USERAPP].CurrentMember.membervalue,'Not Used')
Member [ENGINE_FAMILY_CODE] AS[建造数据 Build Data].[发动机平台 Engine Platform].CurrentMember.membervalue
Member [DESIGN_PHASE_CODE] AS [建造数据 Build Data].[排放 Emission Level].CurrentMember.membervalue
--Member [SHIP_DATE]AS CoalesceEmpty([建造数据 Build Data].[发动机发运日期 Engine Ship Date].[发动机发运日期 Engine Ship Date].membervalue,'Not Used')
Member [SERVICE_ENGINE_MODEL] AS CoalesceEmpty([建造数据 Build Data].[车型 Vehicle Model].CurrentMember.membervalue,'Not Used')
Member [APPLICATION_CODE] AS CoalesceEmpty([建造数据 Build Data].[细分市场 Vehicle Type].CurrentMember.membervalue,'Not Used')
Member [PLANT_CODE] AS [建造数据 Build Data].[发动机厂 Engine Plant].CurrentMember.membervalue
SELECT
-- NON EMPTY
{
[ENGINE_SERIAL_NUM],
[BUILD_DATE],
[USER_APPL_CODE],
[ENGINE_FAMILY_CODE],
[DESIGN_PHASE_CODE],
--[SHIP_DATE],
[SERVICE_ENGINE_MODEL],
[APPLICATION_CODE],
[PLANT_CODE]
}ON COLUMNS,
NON EMPTY {( [建造数据 Build Data].[发动机号 ESN].[发动机号 ESN].ALLMEMBERS*
[建造数据 Build Data].[生产日期 Build Date].[生产日期 Build Date].ALLMEMBERS*
[建造数据 Build Data].[发动机应用领域 USERAPP].[发动机应用领域 USERAPP].ALLMEMBERS*
[建造数据 Build Data].[发动机平台 Engine Platform].[发动机平台 Engine Platform].ALLMEMBERS*
[建造数据 Build Data].[排放 Emission Level].[排放 Emission Level].ALLMEMBERS*
[建造数据 Build Data].[发动机发运日期 Engine Ship Date].[发动机发运日期 Engine Ship Date].ALLMEMBERS*
[建造数据 Build Data].[车型 Vehicle Model].[车型 Vehicle Model].ALLMEMBERS*
[建造数据 Build Data].[细分市场 Vehicle Type].[细分市场 Vehicle Type].ALLMEMBERS*
[建造数据 Build Data].[发动机厂 Engine Plant].[发动机厂 Engine Plant].ALLMEMBERS
)}ON ROWS
FROM ( SELECT ( {[建造数据 Build Data].[建造年 Build year].&[2019] } ) ON COLUMNS
FROM ( SELECT ( {[建造数据 Build Data].[建造月份 Build month].&[6] } ) ON COLUMNS
FROM ( SELECT ( { [建造数据 Build Data].[发动机平台 Engine Platform].&[X] } ) ON COLUMNS
FROM ( SELECT ( { [建造数据 Build Data].[发动机厂 Engine Plant].&[BFCEC] } ) ON COLUMNS
FROM ( SELECT ( { [建造数据 Build Data].[排放 Emission Level].&[NS6] } ) ON COLUMNS
FROM [Model] )))))
// 用户要求必须要把个别列重命名
执行上述这段代码的时候,如果ON COLUMNS里没有[]Build_Date]就可以正常执行,加了这个就报错,错误信息就是函数中成员、元组或集必须使用相同的层次结构。但是我看来看去都没发现哪里的层次结构不对。求大神帮忙指导!