MDX查询“有成员”和总和问题
|
我有一个查询
WITH MEMBER [measures].[Count] AS
SUM(([Location].[Hierarchy].[Zone].[1].Children),[Measures].[Length])
SELECT {[measures].[Count]} ON 0,
{[Location].[Hierarchy].[Zone].&[1].Children} on 1
FROM [NTAP]
1 103026769420
2 103026769420
3 103026769420
4 103026769420
1 84984958
2 9494949
3 934883
4 9458948588
1
1
2
3
2
1
2
3
没有找到相关结果
已邀请:
2 个回复
淘圃跺枯替
WITH MEMBER [Measures].[Count] AS SUM([Location].[Hierarchy].CurrentMember.Children, [Measures].[Length]) SELECT {[Measures].[Count]} ON 0, {[Location].[Hierarchy].[Zone].&[1].Children} on 1 FROM [NTAP]号拳藐孔妇
WITH MEMBER [Measures].[Count of Children with L more than 0] AS FILTER([Location].[Hierarchy].CurrentMember.Children, [Measures].[Length] > 0).COUNT SELECT { [Measures].[Count of Children with L more than 0] } ON 0, { [Location].[Hierarchy].[Zone].&[1] } ON 1 FROM [Your Cube]